Movie_ticketing

Tables (12)

Actor (Untitled4)

  • actor_id (PK) — int — Primary key — NOT NULL
  • actor_name (Field) — varchar
  • Field2

Actor_Movie (Untitled12)

  • actor_movie_id (Key) — int — Primary key — NOT NULL
  • actor_id (PK) — int — Foreign key → Actor.actor_id — NOT NULL
  • movie_id (PK2) — int — Foreign key → Movie.movie_id — NOT NULL

Cinema (Untitled7)

  • cinema_id (Key) — int — Primary key — NOT NULL
  • cinema_name (Field2) — varchar
  • Field

Director (Untitled9)

  • director_id (PK) — int — Primary key — NOT NULL
  • director_name (Field) — varchar
  • Field2

Director_Movie (Untitled10)

  • director_movie_id (PK) — int — Primary key — NOT NULL
  • movie_id (FK) — int — Foreign key → Movie.movie_id — NOT NULL
  • director_id (PK2) — int — Foreign key → Director.director_id — NOT NULL
  • Field

Genre (Untitled5)

  • genre_id (PK) — Primary key — NOT NULL
  • gere_name (Field) — varchar
  • Field2

Genre_Movie (Untitled6)

  • genre_movie_id (PK) — int — Primary key — NOT NULL
  • genre_id (FK) — int — Foreign key → Genre.genre_id — NOT NULL
  • movie_id (FK2) — int — Foreign key → Movie.movie_id — NOT NULL

Member (Untitled2)

  • member_id (PK) — int — Primary key — NOT NULL
  • member_name (Field) — varchar
  • Field2

Movie (Untitled)

  • movie_id (PK) — int — Primary key — NOT NULL
  • movie_title (Field) — varchar
  • runningtime (Field4) — time
  • Field2

Reservation (Untitled11)

  • reservation_id (Key) — int — Primary key — NOT NULL
  • member_id (PK) — int — Foreign key → Member.member_id — NOT NULL
  • Field

Theater (Untitled13)

  • theater_id (PK) — int — Primary key — NOT NULL
  • cinema_id (Key) — int — Foreign key → Cinema.cinema_id — NOT NULL
  • movie_id (PK2) — int — Foreign key → Movie.movie_id — NOT NULL
  • location (Field) — String
  • seat (Field2) — int
  • Field3

Ticket (Untitled3)

  • ticket_id (Key) — int — Primary key — NOT NULL
  • reservation_id (Key3) — int — Foreign key → Reservation.reservation_id — NOT NULL
  • theater_id (PK) — int — Foreign key → Theater.theater_id — NOT NULL
  • cinema_id (Key2) — int — Foreign key → Theater.cinema_id — NOT NULL
  • movie_id (PK2) — int — Foreign key → Theater.movie_id — NOT NULL
  • reservation_available (Field) — boolean
  • price (Field3)