db

Tables (15)

Actor (actor)

  • ActorID (id) — int — Primary key — NOT NULL
  • ActorName (name) — varchar(100)
  • Gender (gender) — varchar(10)
  • Age (age) — int

Cinema (cinema)

  • CinemaID (id) — int — Primary key — NOT NULL
  • CinemaName (name) — varchar(100)
  • CinemaLocation (location) — varchar(225)
  • Time (time) — varchar(225)

Cinema_Room (Untitled)

  • CinemaID (id) — int — Foreign key → Cinema.CinemaID — NOT NULL
  • SeatID (id2) — int — Foreign key → Room.SeatID — NOT NULL

Director

  • DirectorID (id) — int — Primary key — NOT NULL
  • DirectorName (name) — varchar(100)
  • Gender (gender) — varchar(10)
  • Age (age) — int

Favorite (favorite)

  • MovieID (id2) — int — Foreign key → Movie.MovieID
  • UserID (id3) — int — Foreign key → User.UserID — NOT NULL

Genre (genre)

  • GenreName (name) — varchar(25) — Primary key — NOT NULL

Language (language)

  • LanguageName (id) — varchar(25) — Primary key — NOT NULL

Movie (movie)

  • MovieID (id) — int — Primary key
  • MovieName (name) — varchar(100)
  • MoviePoster (poster) — varchar(225)
  • ReleaseYear (year) — int
  • Summary (summary) — varchar(225)
  • Rating (rating) — int
  • LanguageName (id2) — varchar(25) — Foreign key → Language.LanguageName — NOT NULL

Room (seat)

  • SeatID (id) — int — Primary key — NOT NULL

Tickets (ticket)

  • TicketID (id) — int — Primary key — NOT NULL
  • Price (price) — int
  • Date (date) — varchar(100)
  • UserID (id2) — int — Foreign key → User.UserID — NOT NULL
  • CinemaID (id3) — int — Foreign key → Cinema_Room.CinemaID — NOT NULL
  • SeatID (id22) — int — Foreign key → Cinema_Room.SeatID — NOT NULL

User (users)

  • UserID (id) — int — Primary key — NOT NULL
  • User Name (name) — varchar(20)
  • User Password (password) — varchar(20)

director-movie connect (director_movie_connect)

  • MovieID (id2) — int — Foreign key → Movie.MovieID
  • DirectorID (id) — int — Foreign key → Director.DirectorID — NOT NULL

movie-actor connect (movie_actor_connect)

  • ActorID (id) — int — Foreign key → Actor.ActorID — NOT NULL
  • MovieID (id2) — int — Foreign key → Movie.MovieID

movie-cinema connect (movie_cinema_connect)

  • MovieID (id) — int — Foreign key → Movie.MovieID
  • CinemaID (id2) — int — Foreign key → Cinema.CinemaID — NOT NULL

movie-genre connect (movie_genere_connect)

  • GenreName (name) — varchar(25) — Foreign key → Genre.GenreName — NOT NULL
  • MovieID (id2) — int — Foreign key → Movie.MovieID