ship
Tables (6)
Customer
- CustomerID — INT — Primary key
- Name — VARCHAR(100) — NOT NULL
- Email — VARCHAR(100) — NOT NULL
- Phone — VARCHAR(15)
- Address — VARCHAR(255)
Order
- OrderID — INT — Primary key
- CustomerID — INT
- OrderDate — DATE — NOT NULL
- TotalAmount — DECIMAL(10,2) — NOT NULL
- ShippingAddress — VARCHAR(255)
- CustomerID (CustomerID2) — INT — Foreign key → Customer.CustomerID
OrderItem
- OrderItemID — INT — Primary key
- OrderID — INT
- ProductID — INT
- Quantity — INT — NOT NULL
- Price — DECIMAL(10,2) — NOT NULL
- CustomerID — INT — Foreign key → Customer.CustomerID
Product
- ProductID — INT — Primary key
- Name — VARCHAR(100) — NOT NULL
- Description — TEXT
- Price — DECIMAL(10,2) — NOT NULL
- StockQuantity — INT — NOT NULL
- OrderItemID — INT — Foreign key → OrderItem.OrderItemID
Shipment
- ShipmentID — INT — Primary key
- OrderID — INT
- ShippedDate — DATE
- DeliveryDate — DATE
- Carrier — VARCHAR(100)
- TrackingNumber — VARCHAR(50)
- OrderID (OrderID2) — INT — Foreign key → Order.OrderID
ShipmentStatus
- StatusID — INT — Primary key
- ShipmentID — INT
- Status — VARCHAR(50) — NOT NULL
- UpdateDate — DATE — NOT NULL
- ShipmentID (ShipmentID2) — INT — Foreign key → Shipment.ShipmentID