2024-1 DB

테이블 (3)

관객 (Audience)

  • id (aud_id) — int — 기본 키 — NOT NULL
  • name (aud_name) — varchar(30)
  • age (aud_age) — int

영화 (Movie)

  • id (movie_id) — int — 기본 키 — NOT NULL
  • title (movie_title) — varchar(30)
  • director (movie_director) — varchar(30)
  • price (movie_price) — int

예매 (reservation)

  • grade — int
  • movie_id — int — 외래 키 → 영화.id — NOT NULL
  • aud_id — int — 외래 키 → 관객.id — NOT NULL