ㅁㄴㅇ
Tables (9)
Actor
- actor_id — INT
- casting_date — DATE
Booking
- booking_id — INT
- member_id — INT
- booking_date — DATE
- payment_method — VARCHAR(50)
Booking_Detail
- booking_id — INT
- seat_id — INT
Member
- member_id — INT
- name — VARCHAR(255)
- phone_number — VARCHAR(20)
- email — VARCHAR(255)
- password — VARCHAR(255)
- region — VARCHAR(255)
Movie
- movie_id — INT
- title — VARCHAR(255)
- genre — VARCHAR(50)
- director — VARCHAR(255)
- release_date — DATE
- production_company — VARCHAR(255)
Performance
- movie_id — INT
- actor_id — INT
- performance_number — INT
Screening
- screening_id — INT
- movie_id — INT
- theater_id — INT
- screening_date — DATE
- auditorium_name — VARCHAR(255)
- screening_time — TIME
Seat
- seat_id — INT
- theater_id — INT
- row — CHAR(1)
- number — INT
- seat_name — VARCHAR(50)
Theater
- theater_id — INT
- name — VARCHAR(255)
- location — VARCHAR(255)
- auditorium_count — INT