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