see the image for explanation..
what are they?
im using heidi sql 9.4.0.5125 (64bit)
CREATE TABLE "TR_WO_ITEM" (
"ROW_ID" INT NOT NULL,
"WO_NO" VARCHAR(15) NOT NULL,
"REVISION_NO" INT NOT NULL,
"ITEM_ID" VARCHAR(10) NULL DEFAULT NULL,
"ITEM_PACKAGE_TYPE_ID" CHAR(1) NULL DEFAULT NULL,
"QTY_REQUIRED" INT NULL DEFAULT NULL,
"QTY_STOCK" INT NULL DEFAULT NULL,
"QTY_LOAN" INT NULL DEFAULT NULL,
"QTY_RENT" INT NULL DEFAULT NULL,
"QTY_PURCHASE" INT NULL DEFAULT NULL,
"ITEM_REMARKS" VARCHAR(500) NULL DEFAULT NULL,
"LOGISTIC_STATUS_ID" VARCHAR(5) NULL DEFAULT NULL,
"LOGISTIC_REMARK" VARCHAR(255) NULL DEFAULT NULL,
"PARENT_ITEM_ID" VARCHAR(10) NULL DEFAULT NULL,
"SOURCE_ITEM_ID" VARCHAR(10) NULL DEFAULT NULL,
"ITEM_TYPE_FLAG" CHAR(1) NULL DEFAULT NULL,
"ITEM_ALIAS_ID" VARCHAR(10) NULL DEFAULT NULL,
"REQUEST_PIC_CREW_ID" VARCHAR(10) NULL DEFAULT NULL,
"ITEM_MOVEMENT_CHECK" VARCHAR(1) NULL DEFAULT 'N',
"RELEASE_FLAG" VARCHAR(1) NULL DEFAULT NULL,
"QTY_CHECK_OUT" INT NULL DEFAULT NULL,
"LOGISTIK_RECOMENDATION" VARCHAR(50) NULL DEFAULT NULL,
"IF_CI" NCHAR(1) NULL DEFAULT NULL,
"IS_TRANSFER" NCHAR(1) NULL DEFAULT NULL,
"REPLACEMENT_FLAG" NCHAR(1) NULL DEFAULT NULL,
"WO_ITEM_REPLACED" VARCHAR(10) NULL DEFAULT NULL,
"IS_ITEM_SET" NCHAR(1) NULL DEFAULT NULL,
"IS_ITEM_ADDED" NCHAR(1) NULL DEFAULT NULL,
PRIMARY KEY ("ROW_ID"),
UNIQUE INDEX "UNIQUE" ("WO_NO", "ITEM_ID", "ITEM_ALIAS_ID", "PARENT_ITEM_ID")
);
created on MSSQL Database Manager
Please login to leave a reply, or register at first.