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