erd test

Tables (3)

SHPORDER (주문)

  • ID_SHPORDER (Key) — UNIQUEIDENTIFIER — Primary key — NOT NULL
  • Field

SHPSCH (출하지시)

  • 주문작업ID (ID_SHPSCH) — UNIQUEIDENTIFIER — Primary key — NOT NULL
  • Field (ID_SHPORDER) — UNIQUEIDENTIFIER
  • Field

SHPWRK (주문작업)

  • 주문작업ID (ID_SHPWRK) — UNIQUEIDENTIFIER — Primary key — NOT NULL
  • 주문작업ID (ID_SHPSCH) — UNIQUEIDENTIFIER — Foreign key → SHPSCH.주문작업ID — NOT NULL
  • 주문PKG (ID_PKG) — UNIQUEIDENTIFIER
  • Field (EXC_SCH_QTY) — NUMERIC(18,0)
  • Field (EXC_CMP_QTY) — NUMERIC(18,0)
  • Field (EXC_CNC_QTY) — NUMERIC(18,0)
  • 출고목적지 (ID_DST) — UNIQUEIDENTIFIER
  • 작업이력ID (ID_WRK) — UNIQUEIDENTIFIER