Product
테이블 (3)
카테고리
- Key (category_id) — int — 기본 키 — NOT NULL
- Field (category_name) — varchar
판매
- Key (order_id) — int — 기본 키 — NOT NULL
- Key (item_id) — int — 외래 키 → 품목.Key — NOT NULL
- Field (user_name) — varchar
- Field (order_date) — varchar
- Field (total_price) — int
- Field (order_count) — int
품목
- Key (item_id) — int — 기본 키 — NOT NULL
- Key (category_id) — int — 외래 키 → 카테고리.Key — NOT NULL
- Field (item_name) — varchar
- Field (item_price) — int
- Field (item_life) — varchar
- Field (item_on_event) — tinyint
- Field (item_on_sale) — tinyint