movies

Tables (7)

Genre (genre)

  • Genre Id (genre_id) — Not Null — Primary key — NOT NULL
  • Name (name) — CHAR(20)

Movie (movie)

  • Movie Id (movie_id) — Not Null — Primary key — NOT NULL
  • Movie Title (movie_title) — CHAR(100)
  • Movie Original Title (movie_original_title) — CHAR(100)
  • Movie Release Date (movie_release_date) — DATE
  • Movie Runtime (movie_runtime) — INT(11)
  • Movie Poster Path (movie_poster_path) — TEXT
  • Movie Overview (movie_overview) — TEXT
  • Movie Adult (movie_adult) — BOOLEAN
  • Movie Award (movie_award) — BOOLEAN
  • Movie Kewards (movie_kewards) — CHAR(100)
  • Movie Director (movie_director) — CHAR(100)
  • Movie Actors (movie_actors) — TEXT
  • Movie Produce Year (movie_produce_year) — CHAR(30)
  • Movie Nation (movie_nation) — CHAR(30)
  • Movie Rating (movie_rating) — CHAR(30)
  • Movie Isboxoffice (movie_isboxoffice) — BOOLEAN
  • Movie Stills (movie_stills) — TEXT

Movie Genre (movie_genre)

  • Movie Genre Id (movie_genre_id) — Not Null — Primary key — NOT NULL
  • Movie Id (movie_id) — Not Null — Foreign key → Movie.Movie Id — NOT NULL
  • Genre Id (genre_id2) — Not Null — Foreign key → Genre.Genre Id — NOT NULL

Movie Like (movie_like)

  • Movie Like Id (movie_like_id) — Not Null — Primary key — NOT NULL
  • User Id (user_id) — Not Null — Foreign key → User.User Id — NOT NULL
  • Movie Id (movie_id) — Not Null — Foreign key → Movie.Movie Id — NOT NULL

Survey Movie Genre (survey_movie_genre)

  • Survey Movie Genre Id (survey_movie_genre_id) — Not Null — Primary key — NOT NULL
  • Survey Movie Id (survey_movie_id) — Not Null — Foreign key → Survey_movie.Survey Movie Id — NOT NULL
  • Genre Id (genre_id) — Not Null — Foreign key → Genre.Genre Id — NOT NULL

Survey_movie (survey_movie)

  • Survey Movie Id (survey_movie_id) — Not Null — Primary key — NOT NULL
  • Survey Movie Title (survey_movie_title) — CHAR(100)
  • Survey Movie Poster Path (survey_movie_poster_path) — TEXT

User (user)

  • User Id (user_id) — Not Null — Primary key — NOT NULL
  • User Survey Genre Id (user_survey_genre_id) — INT(11)