공부
테이블 (4)
book
- book_id — int — 기본 키 — NOT NULL
- book_name — varchar(20) — NOT NULL
order
- order_id — int — 기본 키 — NOT NULL
- order_name — varchar(24) — NOT NULL
order_detail
- order_detail (order_detail_id) — int — 기본 키 — NOT NULL
- order_name (order_detail_name) — varchar(20) — NOT NULL
- order_id — int — 외래 키 → order.order_id — NOT NULL
- book_id — int — 외래 키 → book.book_id — NOT NULL
review
- order_detail (order_detail_id) — int — 외래 키 → order_detail.order_detail — NOT NULL
- review_name — varchar(100) — NOT NULL
- book_id — int — 외래 키 → book.book_id — NOT NULL