영화 예매 시스템
테이블 (7)
Hall (관)
- hall_id (PK) — 기본 키 — NOT NULL
- theater_id (pk) — 외래 키 → Theater.theater_id — NOT NULL
- movie_id (Key) — 외래 키 → Movie.movie_id — NOT NULL
Movie (영화)
- movie_id (Key) — 기본 키 — NOT NULL
- movie_name (Field)
- genre (Field2)
- actor (Field3)
- ditrector (Field4)
Seat (Untitled)
- seat_id (Key) — 기본 키 — NOT NULL
- hall_id (PK) — 외래 키 → Hall.hall_id — NOT NULL
Theater (Untitled2)
- theater_id (pk) — 기본 키 — NOT NULL
- count (Field)
- theater_name (Field2)
Ticket (Untitled7)
- movie_id (Key) — 외래 키 → Movie.movie_id — NOT NULL
- theater_id (pk) — 외래 키 → Theater.theater_id — NOT NULL
- hall_id (PK) — 외래 키 → Hall.hall_id — NOT NULL
- ticketing_id (Key2) — 외래 키 → reservation.ticket_id — NOT NULL
- date (Field)
- seat_id (Key3) — 외래 키 → Seat.seat_id — NOT NULL
member (Untitled3)
- member_id (PK) — 기본 키 — NOT NULL
- member_name (Field)
- member_phone (Field2)
- member_age (Field3)
reservation (Untitled5)
- ticket_id (Key) — 기본 키 — NOT NULL
- member_id (PK) — 외래 키 → member.member_id — NOT NULL