Advertisement
ryanarnold

hv_labgen_acc_icd10_codes dll

Jul 12th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.54 KB | None | 0 0
  1.   CREATE TABLE "HV_LABGEN_ACC_ICD10_CODES"
  2.    (    "SOURCE_CLINIC" VARCHAR(15) NOT NULL,
  3.     "ACCESSION" VARCHAR(15) NOT NULL,
  4.     "ICD10_CODE" VARCHAR(8) NOT NULL,
  5.     "DSYS_INSTANCE_ID" FLOAT NOT NULL,
  6.     "DSYS_PROCESS_ID" FLOAT NOT NULL,
  7.     "DSYS_BATCH_ID" FLOAT NOT NULL
  8.    );
  9.  
  10.   CREATE INDEX "HV_LABGEN_ACC_ICD10_CODES_SYS" ON "HV_LABGEN_ACC_ICD10_CODES" ("DSYS_INSTANCE_ID", "DSYS_PROCESS_ID", "DSYS_BATCH_ID");
  11.  
  12.   CREATE UNIQUE INDEX "HV_LABGEN_ACC_ICD10_CODES_U1" ON "HV_LABGEN_ACC_ICD10_CODES" ("ACCESSION", "SOURCE_CLINIC", "ICD10_CODE");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement