DD

Tables (4)

TBL_DSH (배송 이력)

  • history_id (Key) — Primary key — NOT NULL
  • status (Field2)
  • remarks (Field3)
  • change_date (Field4)
  • shipment_id (Key2) — Foreign key → TBL_SHIPMENTS.shipment_id — NOT NULL

TBL_PRODUCT (제품정보)

  • product_id (Key) — Primary key — NOT NULL
  • name (Field)
  • price (Field2)
  • weight (Field3)
  • received (Field4)

TBL_SHIPITEMS (배송품목)

  • ship_item_id (Key) — Primary key — NOT NULL
  • product_id (Field2)
  • product_name (Field3)
  • quantity (Field4)
  • updated_at (Field5)
  • shipment_id (Key2) — Foreign key → TBL_SHIPMENTS.shipment_id — NOT NULL

TBL_SHIPMENTS (배송정보)

  • shipment_id (Key) — Primary key — NOT NULL
  • order_id (Field)
  • tracking_no (Field2)
  • courier (Field3)
  • shipped_dt (Field4)
  • delivered_dt (Field5)