UK Ecommerce
Tables (4)
Customers (customers)
- 고객 ID (customer_id) — string — Primary key — NOT NULL
- 배송지 국가 (country) — string
Items (items)
- 상품 ID (item_id) — string — Primary key — NOT NULL
- 상품명 (name) — string
Order_items (order_items)
- 상품 ID (item_id) — string — Foreign key → Items.상품 ID — NOT NULL
- 거래 ID (order_id) — string — Foreign key → Orders.거래 ID — NOT NULL
- 1개 당 가격 (price) — number
- 수량 (quantity) — integer
Orders (orders)
- 거래 ID (order_id) — string — Primary key — NOT NULL
- 고객 ID (customer_id) — string — Foreign key → Customers.고객 ID — NOT NULL
- 거래일 (order_date) — date