영화 예매하기
테이블 (6)
Member
- member_id — INT
- name — VARCHAR(255)
- email — VARCHAR(255)
- phone_number — VARCHAR(20)
- membership_level — VARCHAR(50)
- Field
Movie
- movie_id — INT
- title — VARCHAR(255)
- director — VARCHAR(255)
- genre — VARCHAR(50)
Reservation
- reservation_id — INT
- member_id — INT
- movie_id — INT
- showtime_id — INT
- seat_id — INT
- payment_info — VARCHAR(255)
Seat
- seat_id — INT
- seat_number — VARCHAR(10)
- seat_type — VARCHAR(20)
Showtime
- showtime_id — INT
- movie_id — INT
- theater_id — INT
- showtime — DATETIME
Theater
- theater_id — INT
- name — VARCHAR(255)
- location — VARCHAR(255)