Shipment_ID (PK)
Order_ID
Shipping_Company
Tracking_Number
Shipment_Date
Delivery_Date
Shipment_Status
Order_ID (PK)
Customer_ID
Order_Date
Total_Amount
Order_Status
Shipping_Address
Payment_Method_ID
Order_Item_ID (PK)
Product_ID
Quantity
Unit_Price
Subtotal
Payment_Method_ID (PK)
Payment_Type
Card_Number_Last4
Expiry_Date
Is_Default
Customer_ID (PK)
Full_Name
Email
Phone_Number
Registration_Date
Address
Review_ID (PK)
Rating
Review_Text
Review_Date
Product_ID (PK)
Product_Name
Category
Price
Stock_Quantity
Brand
Description
Product_Supplier_ID (PK)
Supplier_ID
Supply_Price
Last_Supply_Date
Contract_Status
Supplier_ID (PK)
Supplier_Name
Contact_Person
by claude
