Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE "HV_LABGEN_ACC_ICD10_CODES"
- ( "SOURCE_CLINIC" VARCHAR(15) NOT NULL,
- "ACCESSION" VARCHAR(15) NOT NULL,
- "ICD10_CODE" VARCHAR(8) NOT NULL,
- "DSYS_INSTANCE_ID" FLOAT NOT NULL,
- "DSYS_PROCESS_ID" FLOAT NOT NULL,
- "DSYS_BATCH_ID" FLOAT NOT NULL
- );
- CREATE INDEX "HV_LABGEN_ACC_ICD10_CODES_SYS" ON "HV_LABGEN_ACC_ICD10_CODES" ("DSYS_INSTANCE_ID", "DSYS_PROCESS_ID", "DSYS_BATCH_ID");
- 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