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