shipment
Tables (6)
Box (box)
- boxId (Key) — Primary key — NOT NULL
- expectedWidth (Field2)
- expectedDepth (Field3)
- expectedHeight (Field4)
- expectedVolumeWeight (Field5)
- expectedNetWeight (Field6)
- expectedPrice (Field12)
- width (Field7)
- depth (Field8)
- height (Field9)
- volumeWeight (Field10)
- netWeight (Field11)
- price (Field13)
- koreanInvoice (Field14)
- koreanShippingCompany (Field15)
- koreanShippingstatus (Field)
- orderId (Field16) — Foreign key → Order.orderId
Member (member)
- memberId (Key) — Primary key — NOT NULL
- email (Field)
- password (Field2)
- name (Field3)
- phoneNumber (Field4)
Order
- orderId (Field) — Primary key
- orderNumber (Field7)
- expectedOrderPrice (Field2)
- orderPrice (Field3)
- invoice (Field5)
- shipppingCompany (Field6)
- adminMemo (Field8)
- userMemo (Field4)
- status (Field9)
- memberId (Key) — Foreign key → Member.memberId — NOT NULL
- recipientId (Key2) — Foreign key → Recipient.recipientId — NOT NULL
PointHistory
- pointHistoryId (Key) — Primary key — NOT NULL
- balance (Field)
- deposit (Field2)
- withdraw (Field3)
- section (Field4)
- detail (Field5)
- memberId (Key2) — Foreign key → Member.memberId — NOT NULL
- orderId (Field6) — Foreign key → Order.orderId
Product
- productId (Key) — Primary key — NOT NULL
- productDetail (Field)
- quntity (Field2)
- price (Field3)
- weight (Field4)
- orderId (Field5) — Foreign key → Order.orderId
Recipient
- recipientId (Key) — Primary key — NOT NULL
- name (Field2)
- email (Field7)
- country (Field)
- state (Field3)
- city (Field4)
- address1 (Field5)
- address2 (Field10)
- address3 (Field11)
- zipcode (Field6)
- countryCode (Field8)
- phoneNumber (Field9)
- memberId (Key2) — Foreign key → Member.memberId — NOT NULL