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)