STC

Tables (5)

BOM (MBOM)

  • Itm_pcd (Key) — Primary key — NOT NULL
  • Itm_cd (Key2) — Primary key — NOT NULL
  • Proc_cd (Key3) — Primary key — NOT NULL
  • Itm_cd (Key4) — Foreign key → ItemPrice.Itm_cd — NOT NULL
  • Itm_Price (Key22) — Foreign key → ItemPrice.Itm_Price — NOT NULL

Item master (Item Master)

  • Itm_cd (Key) — Primary key — NOT NULL
  • 비중 (Field)

ItemPrice (Item Price)

  • Itm_cd (Key) — Primary key — NOT NULL
  • Itm_Price (Key2) — Primary key — NOT NULL

Machine Master (고정자산)

  • act_cd (Key) — Primary key — NOT NULL
  • mc_type (Key2) — Primary key — NOT NULL

Routing (Item Routing)

  • Itm_cd (Key) — Primary key — NOT NULL
  • Proc_cd (Key2) — Primary key — NOT NULL
  • Kcal (Key3) — NOT NULL
  • MC1-1 (Key4) — NOT NULL
  • MC1-2 (Key5) — NOT NULL
  • MC1-3 (Key6) — NOT NULL
  • MC2-1 (Key7) — NOT NULL
  • MC2-2 (Key8) — NOT NULL
  • MC2-3 (Key9) — NOT NULL
  • Itm_pcd (Key10) — Foreign key → BOM.Itm_pcd — NOT NULL
  • Itm_cd (Key22) — Foreign key → BOM.Itm_cd — NOT NULL
  • Proc_cd (Key32) — Foreign key → BOM.Proc_cd — NOT NULL