test

Tables (7)

334 (33)

  • seq (Key2) — Foreign key → wms_transfer_item.seq — NOT NULL

custom (Untitled4)

  • cust_no (Key) — Primary key — NOT NULL

custom_addr (CopyOfUntitled4)

  • seq?? (Key) — Primary key — NOT NULL
  • cust_no (Key3) — Foreign key → custom.cust_no — NOT NULL
  • cust_no (Key2) — Foreign key → custom.cust_no — NOT NULL
  • cust_no (Key4) — Foreign key → custom.cust_no — NOT NULL

t_xwms_sync_order (Untitled)

  • mng_no (Key) — notnull — Primary key — NOT NULL
  • sync_no (Field)
  • mng_no (Field2)
  • items (Field3)

wms_transfer_detail (Untitled3)

  • seq (Key) — notnull — Primary key — NOT NULL
  • ref_mng_no (Field2)
  • Field3
  • mst_seq (Key2) — notnull — Foreign key → wms_transfer_mst.seq — NOT NULL
  • price (Field4)
  • sku (Field5)
  • order_no (Field6)
  • tracking_no (Field7)
  • weight (Field8)
  • packing_no (Field9)
  • request_items (Field10)
  • order_mng_no (Key3) — notnull — Foreign key → t_xwms_sync_order.mng_no — NOT NULL

wms_transfer_item (Untitled5)

  • seq (Key2) — Primary key — NOT NULL
  • mst_seq (Key) — notnull — Foreign key → wms_transfer_mst.seq — NOT NULL
  • transfer_items... (Field)

wms_transfer_mst (Untitled2)

  • seq (Key) — notnull — Primary key — NOT NULL
  • packing_no (Field)
  • service_company_code (Field2)
  • request_msg (Field4)
  • response_msg (Field5)
  • cust_no (Field6)
  • order_sync_no (Field7)
  • Field8
  • order_mng_no (Key2) — notnull — Foreign key → t_xwms_sync_order.mng_no — NOT NULL
  • new_packing_no (Field3)
  • status (Field9)
  • mng_no (Key3) — notnull — Foreign key → t_xwms_sync_order.mng_no — NOT NULL
  • seq (Key4) — notnull — Foreign key → wms_transfer_detail.seq — NOT NULL