222
Tables (4)
Customer
- CustomerID — INT — Primary key
- Name — VARCHAR(100) — NOT NULL
- Email — VARCHAR(100) — NOT NULL
- Phone — VARCHAR(20)
- Country — VARCHAR(50)
Order
- OrderID — INT — Primary key
- CustomerID — INT — NOT NULL
- OrderDate — DATETIME — NOT NULL
- TotalAmount — DECIMAL(10, 2) — NOT NULL
- CustomerID (CustomerID2) — INT — Foreign key → Customer.CustomerID
OrderItem
- OrderItemID — INT — Primary key
- OrderID (OrderID2) — INT — Foreign key → Order.OrderID
- OrderID — INT — NOT NULL
- ProductID — INT — NOT NULL
- Quantity — INT — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
Product
- ProductID — INT — Primary key
- ProductName — VARCHAR(100) — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
- Stock — INT — NOT NULL
- OrderID — INT — Foreign key → Order.OrderID