Skip to content

Instantly share code, notes, and snippets.

@KySoto

KySoto/data.txt Secret

Created August 21, 2019 19:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save KySoto/5a764f3fa3c0d139131056ed6d44529b to your computer and use it in GitHub Desktop.
Save KySoto/5a764f3fa3c0d139131056ed6d44529b to your computer and use it in GitHub Desktop.
Output data
DBServer : Redacted
SourceDB : Redacted
SourceTableOrScript : SELECT [ID]
,[DATE]
,[P_NUMBER]
,[CUST_PN]
,[CUSTOMER]
,[NOTES]
,[MADE_FROM]
,[DOWN_GRADE]
,[T_PIV]
,[T_VR]
,[T_IR]
,[T_VF]
,[T_VF_LOW]
,[T_IF]
,[T_TRR]
,[TRR_COND]
,[T_THRESP]
,[T_THCURR]
,[T_THTIME]
,[T_THCONST]
,[SPEC_TEST]
,[R_VRWM]
,[R_IO_55C]
,[R_IO_100C]
,[R_IR_25C]
,[R_IR_100C]
,[R_VF]
,[R_IF]
,[R_TRR]
,[R_IFSM]
,[R_IFRM]
,[R_TI_000]
,[R_TI_125]
,[R_TI_250]
,[R_TI_375]
,[R_TI_500]
,[R_JUNC_CAP]
,[MIN_PLAT_TEMP]
,[MAX_PLAT_TEMP]
,[MIN_RESIS]
,[MAX_RESIS]
,[MIN_THICKNESS]
,[MAX_THICKNESS]
,[NUM_ACTIVE]
,[DIE_SIZE]
,[DIE_CUT]
,[LENGTH]
,[LEAD]
,[PIN]
,[BODYDIA]
,[BODY_DIAMETER_MAX]
,[BODY_DIAMETER_MIN]
,[GLSS_EPXY]
,[SECOND_SILVER]
,[PREFORM]
,[ORIGINATING_ENGINEER]
,[PASSIVE_THICKNESS]
,[PASSIVE_DIFFUSED]
,[PLAT_RECIPE]
,[GOLD]
,[BP_DIFFUSION_TIME]
,[Serialized]
,[DOWN_GRADE_]
,[PARENT_DIE]
FROM [Diodes_Lookup_Diodes1]
DestinationFile : C:\Apps\Testfile.accdb
DestinationTable : Diodes_Lookup_Diodes1
AccessDropScript : Drop table `Diodes_Lookup_Diodes1`
AccessCreateScript : CREATE TABLE
`Diodes_Lookup_Diodes1`
(
`ID` long NOT NULL
, `DATE` datetime NULL
, `P_NUMBER` text(16) NOT NULL Primary Key
, `CUST_PN` text(16) NULL
, `CUSTOMER` text(20) NULL
, `NOTES` text(254) NULL
, `MADE_FROM` text(16) NULL
, `DOWN_GRADE` text(16) NULL
, `T_PIV` double NULL
, `T_VR` double NULL
, `T_IR` double NULL
, `T_VF` double NULL
, `T_VF_LOW` double NULL
, `T_IF` double NULL
, `T_TRR` double NULL
, `TRR_COND` double NULL
, `T_THRESP` double NULL
, `T_THCURR` double NULL
, `T_THTIME` double NULL
, `T_THCONST` double NULL
, `SPEC_TEST` text(254) NULL
, `R_VRWM` double NULL
, `R_IO_55C` double NULL
, `R_IO_100C` double NULL
, `R_IR_25C` double NULL
, `R_IR_100C` double NULL
, `R_VF` double NULL
, `R_IF` double NULL
, `R_TRR` double NULL
, `R_IFSM` double NULL
, `R_IFRM` double NULL
, `R_TI_000` double NULL
, `R_TI_125` double NULL
, `R_TI_250` double NULL
, `R_TI_375` double NULL
, `R_TI_500` double NULL
, `R_JUNC_CAP` double NULL
, `MIN_PLAT_TEMP` double NULL
, `MAX_PLAT_TEMP` double NULL
, `MIN_RESIS` double NULL
, `MAX_RESIS` double NULL
, `MIN_THICKNESS` double NULL
, `MAX_THICKNESS` double NULL
, `NUM_ACTIVE` double NOT NULL
, `DIE_SIZE` DECIMAL(4,3) NOT NULL
, `DIE_CUT` text(12) NULL
, `LENGTH` double NULL
, `LEAD` text(12) NULL
, `PIN` text(12) NULL
, `BODYDIA` text(4) NULL
, `BODY_DIAMETER_MAX` double NULL
, `BODY_DIAMETER_MIN` double NULL
, `GLSS_EPXY` text(1) NULL
, `SECOND_SILVER` text(1) NULL
, `PREFORM` text(12) NULL
, `ORIGINATING_ENGINEER` text(16) NULL
, `PASSIVE_THICKNESS` Long NULL
, `PASSIVE_DIFFUSED` bit NOT NULL
, `PLAT_RECIPE` text(255) NOT NULL
, `GOLD` text(1) NULL
, `BP_DIFFUSION_TIME` Long NULL
, `Serialized` text(1) NULL
, `DOWN_GRADE_` text(16) NULL
, `PARENT_DIE` text(16) NULL
)
Active : True
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment