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