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)