연습
테이블 (4)
Customer
- CustomerID — INT
- Name — VARCHAR(100) — NOT NULL
- Email — VARCHAR(100) — NOT NULL
- Phone — VARCHAR(20)
- Country — VARCHAR(50)
Order
- OrderID — INT
- CustomerID — INT — NOT NULL
- OrderDate — DATETIME — NOT NULL
- TotalAmount — DECIMAL(10, 2) — NOT NULL
OrderItem
- OrderItemID — INT
- OrderID — INT — NOT NULL
- ProductID — INT — NOT NULL
- Quantity — INT — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
Product
- ProductID — INT
- ProductName — VARCHAR(100) — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
- Stock — INT — NOT NULL