Shopping Mall

Tables (5)

Receiver

  • Recipient ID — VARCHAR(20) — Primary key — NOT NULL
  • phoneNumber (phoneNumbe) — VARCHAR(20)
  • Postal Code — VARCHAR(10)
  • Shipping Request Details — VARCHAR(300)
  • Basic Address — VARCHAR(300)
  • Detailed Address — VARCHAR(300)
  • Recipient Name — VARCHAR(20)
  • Registration Date and Time — DATE
  • Registrant ID — VARCHAR(20)
  • Modification Date and Time — DATE
  • Modifier ID — VARCHAR(20)
  • Deletion Status — CHAR(1)
  • Member ID — VARCHAR(20) — Foreign key → member___1.member id — NOT NULL

Return

  • Return ID — VARCHAR(20) — Primary key — NOT NULL
  • Return Reason Code — VARCHAR(20)
  • Return Details — VARCHAR(300)
  • Request Date and Time — DATE
  • Scheduled Pickup Date — DATE
  • Pickup Completion Date — DATE
  • Processing Status Code — VARCHAR(20)
  • Registration Date and Time — DATE
  • Registrant ID — VARCHAR(20)
  • Modification Date and Time — DATE
  • Modifier ID — VARCHAR(20)
  • Deletion Status — CHAR(1)
  • Shipping ID — VARCHAR(20) — Foreign key → Shipment.Shipping ID — NOT NULL

Shipment

  • Shipping ID — VARCHAR(20) — Primary key — NOT NULL
  • Courier ID — VARCHAR(20)
  • Shipping Status Code — VARCHAR(20)
  • Delivery Driver Phone Number — VARCHAR(20)
  • Location Info — VARCHAR(200)
  • Shipping Fee — NUMBER(10)
  • Delivery Photo URL — VARCHAR(200)
  • Delivery Photo Taken Time — DATE
  • Delivered Location — VARCHAR(30)
  • Shipping Start Date — DATE
  • Shipping Completion Date — DATE
  • Estimated Delivery Date — DATE
  • Release Date and Time — DATE
  • Shipping Fee Payer — VARCHAR(20)
  • Registration Date — DATE
  • Registrant ID — VARCHAR(20)
  • Modification Date — DATE
  • Modifier ID — VARCHAR(20)
  • Deletion Status — CHAR(1)
  • Recipient ID — VARCHAR(20) — Foreign key → Receiver.Recipient ID — NOT NULL
  • Order ID — VHARCHAR(20) — Foreign key → order____1.order — NOT NULL

member___1

  • member id — VARCHAR(20) — Primary key — NOT NULL

order____1

  • order — VHARCHAR(20) — Primary key — NOT NULL