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