impix
Tables (11)
OWP-PACK-WORK (포장작업)
- PACK_WORK_SEQ (Key) — Primary key — NOT NULL
- PACK_LINE_CD (key)
- PROD_ID (Key2) — Foreign key → PROD.PROD_ID — NOT NULL
- WORK_LOT_ID (Key3) — Foreign key → WORK_LOT.WORK_LOT_ID — NOT NULL
- DATE (Field2)
- STATUS (Field3)
- TUBE_IN_CT_CNT (Field)
- CT_IN_PAL_CNT (Field4)
OWP_CT (CT박스)
- CT_SEQ (Key) — Primary key — NOT NULL
- CT_CD (UNIQUE)
- CT_STATE (Field)
- PAL_SEQ (Key3) — Foreign key → OWP_PALLET.PAL_SEQ — NOT NULL
- TUBE_CNT (Field2)
- READ_DT (Field3)
OWP_CT_TUBE (Untitled2)
- CT_SEQ (Key) — Foreign key → OWP_CT.CT_SEQ — NOT NULL
- TUBE_SEQ (Key2) — Foreign key → OWP_TUBE.TUBE_SEQ — NOT NULL
OWP_CUSTOMER (거래처)
- CUSTOMER_SEQ (Key) — Primary key — NOT NULL
- CUSTOMER_CD (UNIQUE)
- CUSTOMER_NM (Field)
OWP_ORDER (주문정보)
- ORDER_SEQ (Key) — Primary key — NOT NULL
- ORDER_NO (UNIQUE)
- CUSTOMER_SEQ (Key2) — Foreign key → OWP_CUSTOMER.CUSTOMER_SEQ — NOT NULL
- ORDER_DATE (Field)
- ORDER_CNT (Field2)
OWP_PALLET (팔레트)
- PAL_SEQ (Key) — Primary key — NOT NULL
- PACK_WORK_SEQ (Key2) — Foreign key → OWP-PACK-WORK.PACK_WORK_SEQ — NOT NULL
- PAL_CD (UNIQUE)
- PAL_STATE (Field)
- CT_CNT (Field2)
- READ_DT (Field3)
- WRITE_DT (Field4)
OWP_PAL_CT (Untitled)
- PAL_SEQ (Key) — Foreign key → OWP_PALLET.PAL_SEQ — NOT NULL
- CT_SEQ (Key2) — Foreign key → OWP_CT.CT_SEQ — NOT NULL
OWP_RELEASE (출고)
- RELEASE_SEQ (Key) — Primary key — NOT NULL
- ORDER_SEQ (Key2) — Foreign key → OWP_ORDER.ORDER_SEQ — NOT NULL
- RELEASE_YMD (Field)
- PAL_SEQ (Key3) — Foreign key → OWP_PALLET.PAL_SEQ — NOT NULL
OWP_TUBE (지관통)
- TUBE_SEQ (Key) — Primary key — NOT NULL
- TUBE_CD (UNIQUE)
- STATUS (Field)
- CT_SEQ (Key2) — Foreign key → OWP_CT.CT_SEQ — NOT NULL
PROD (제품관리)
- PROD_ID (Key) — Primary key — NOT NULL
- PROD_CD (UNIQUE) — NOT NULL
- Field2
WORK_LOT (제조번호관리)
- WORK_LOT_ID (Key) — Primary key — NOT NULL
- WORK_LOT_C (UNIQUE)