공부

테이블 (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