11111
Tables (4)
Customer
- CustomerID — INT
- FirstName — VARCHAR(50) — NOT NULL
- LastName — VARCHAR(50) — NOT NULL
- Email — VARCHAR(100)
- Phone — VARCHAR(15)
- Country — VARCHAR(50)
Order
- OrderID — INT
- CustomerID — INT — NOT NULL
- OrderDate — DATETIME
- TotalAmount — DECIMAL(10, 2) — NOT NULL
OrderItem
- OrderItemID — INT
- OrderID — INT — NOT NULL
- ProductID — INT — NOT NULL
- Quantity — INT
- UnitPrice — DECIMAL(10, 2) — NOT NULL
Product
- ProductID — INT
- ProductName — VARCHAR(100) — NOT NULL
- UnitPrice — DECIMAL(10, 2) — NOT NULL
- Stock — INT