theater
Tables (14)
Actor (Untitled13)
- actor_id (Key) — Primary key — NOT NULL
- actor_name (Field)
Actor_Movie (Untitled14)
- actor_movie_id (PK) — Primary key — NOT NULL
- movie_key (FK) — Foreign key → Movie.movie_id — NOT NULL
- actor_id (FK2) — Foreign key → Actor.actor_id — NOT NULL
Customer (Untitled2)
- custromer_id (PK) — Primary key — NOT NULL
- review_id (FK) — Foreign key → Review.review_id — NOT NULL
- customer_name (Field)
Director (Untitled10)
- director_id (PK) — Primary key — NOT NULL
- director_name (Field)
Distributor (Untitled9)
- distributor_id (PK) — Primary key — NOT NULL
- distributor_name (Field)
Genre (Untitled7)
- genre_id (PK) — Primary key — NOT NULL
- genre_name (Field)
Movie (Untitled3)
- movie_id (PK) — Primary key — NOT NULL
- director_id (FK) — Foreign key → Director.director_id — NOT NULL
- distributor_id (FK2) — Foreign key → Distributor.distributor_id — NOT NULL
- movie_name (Field)
Movie_Genre (Untitled8)
- movie_genre_id (PK) — Primary key — NOT NULL
- genre_id (FK) — Foreign key → Genre.genre_id — NOT NULL
- movie_key (FK2) — Foreign key → Movie.movie_id — NOT NULL
Review (Untitled12)
- review_id (PK) — Primary key — NOT NULL
- movie_key (FK) — Foreign key → Movie.movie_id — NOT NULL
- review_rating (Field)
Screen (Untitled)
- screen_id (PK) — Primary key — NOT NULL
Screen_Movie (Untitled11)
- screen_movie_id (PK) — Primary key — NOT NULL
- screen_id (FK) — Foreign key → Screen.screen_id — NOT NULL
- movie_id (FK2) — Foreign key → Movie.movie_id — NOT NULL
Seat (Untitled6)
- seat_id (PK) — Primary key — NOT NULL
- screen_id (FK) — Foreign key → Screen.screen_id — NOT NULL
Ticket (Untitled4)
- ticket_id (PK) — Primary key — NOT NULL
- seat_id (FK) — Foreign key → Seat.seat_id — NOT NULL
- movie_key (FK2) — Foreign key → Movie.movie_id — NOT NULL
- ticket_price (Field2)
Ticketing (Untitled5)
- ticketing_record_id (PK) — Primary key — NOT NULL
- custromer_id (FK) — Foreign key → Customer.custromer_id — NOT NULL
- ticket_id (FK2) — Foreign key → Ticket.ticket_id — NOT NULL