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)