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