ERP-L2J-02
Tables (3)
ITEMS (Untitled)
- Item_ID (Key) — int — Primary key — NOT NULL
- Item_Type (Field) — varchar — IG,Temp,Official
- Item_Name (Field2) — varchar
- IG_Supplier (Field3) — varchar
- Regist_Date (Field4) — datetime
- Field5
ITEM_HISTORY (Untitled3)
- History_ID (Key) — int — Primary key — NOT NULL
- Item_ID (Key2) — int — Foreign key → ITEMS.Item_ID — NOT NULL
- PreItem_ID (Field2) — varchar — PreviousItem
- ChangeDate (Field3) — datetime
- Field
SPEC (Untitled2)
- SPEC_ID (Key) — int — Primary key — NOT NULL
- Item_ID (Key2) — int — Foreign key → ITEMS.Item_ID — NOT NULL
- YarnComp (Field2) — varchar — Yarn_Composition
- YarnThick (Field3) — int — Yarn_Thickness
- YarnUnit (Field4) — varchar — Denier, 's
- YarnBright (Field5) — varchar — Yarn_Brightness
- YarnProcess (Field6) — varchar
- WP_YarnDensity (Field7) — int
- WT_YarnDensity (Field8) — int
- WP_YarnWeight (Field9) — int
- WT_YarnWeight (Field10) — int
- FabricComp (Field11) — varchar
- ResinWeight (Field12) — int
- FabricWidth (Field13) — int