movie_booking_system
Tables (7)
Screen (Untitled6)
- screen_id (Key) — Primary key — NOT NULL
- theater_id (Key2) — Foreign key → theater.theater_id — NOT NULL
- movie_id (Key3) — Foreign key → movie.movie_id — NOT NULL
- screen_number (Field)
- screen_floor (Field2)
- seating count (Field4)
- classification (Field3)
actor (Untitled8)
- actor (Key) — Primary key — NOT NULL
- Field
member (Untitled)
- member_id (Key) — Primary key — NOT NULL
- nickname (Field2)
- grade (Field)
- favorite theater (Field3)
movie (Untitled2)
- movie_id (Key) — Primary key — NOT NULL
- movie_name (Field7)
- released date (Field3)
- running time (Field4)
- film rating (Field6)
- genre (Field5)
- director (Field)
- actor (Field2)
order (Untitled7)
- reservation_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → member.member_id — NOT NULL
theater (Untitled3)
- theater_id (Key) — Primary key — NOT NULL
- theater_name (Field3)
- theater_phone (Field4)
- location (Field)
ticket (Untitled4)
- ticket_id (Key) — Primary key — NOT NULL
- screen_id (Key4) — Foreign key → Screen.screen_id — NOT NULL
- order_id (Key3) — Foreign key → order.reservation_id — NOT NULL
- ticket date (Field)
- ticket hour (Field4)
- seating number (Field2)
- price (Field3)