테이블 명세 보고서
테이블 (4)
customers
- Key (customer_id) — not null — 기본 키 — NOT NULL
- Field (name) — not null
- Field (email) — not null
- Field (password) — not null
- Field (address) — not null
- Field (phone_number) — not null
order_items (Untitled)
- Key (product_id) — not null — 기본 키 — NOT NULL
- Field (quantity) — not null
- Field (price) — not null
- Key (order_id) — not null — 외래 키 → orders.Key — NOT NULL
orders
- Key (order_id) — not null — 기본 키 — NOT NULL
- Field (order_date) — not null
- Key (customer_id) — not null — 외래 키 → customers.Key — NOT NULL
products (Untitled2)
- Field (name) — not null
- Field (description)
- Field (price) — not null
- Key (product_id) — not null — 외래 키 → order_items.Key — NOT NULL