ryanarnold

cmd_box33_reference ddl

Jul 12th, 2019
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.79 KB | None | 0 0
  1.   CREATE TABLE "CMD_BOX33_REFERENCE"
  2.    (    "ACCESSION_NUMBER_STARTS_WITH" VARCHAR(10),
  3.     "SALES_GROUP" VARCHAR(12),
  4.     "TEST_TYPE" VARCHAR(26),
  5.     "INSURANCE_TYPE" VARCHAR(26),
  6.     "SENDOUT_LAB" VARCHAR(128),
  7.     "BOX_33_LAB_NAME" VARCHAR(128),
  8.     "BOX_33_LAB_NPI" VARCHAR(26),
  9.     "BOX_33_PREFIX" VARCHAR(26),
  10.     "BOX_33_LAB_TAX_ID" VARCHAR(26),
  11.     "BOX_33_LAB_ADDRESS" VARCHAR(26),
  12.     "BOX_33_LAB_ADDRESS_2" VARCHAR(26),
  13.     "BOX_33_STATE" VARCHAR(26),
  14.     "BOX_33_CITY" VARCHAR(26),
  15.     "BOX_33_CLIA" VARCHAR(26),
  16.     "BOX_33_PHONE_NUMBER" VARCHAR(26),
  17.     "BOX_33_ZIP_CODE" VARCHAR(26),
  18.     "START_DATE" DATETIME,
  19.     "END_DATE" DATETIME
  20.    );
  21.  
  22.   CREATE INDEX "CMD_BOX33_REFERENCE_INDEX6" ON "CMD_BOX33_REFERENCE" ("ACCESSION_NUMBER_STARTS_WITH", "SENDOUT_LAB", "SALES_GROUP", "TEST_TYPE", "INSURANCE_TYPE");
Advertisement
Add Comment
Please, Sign In to add comment