Movie recommendation

Tables (8)

Account (User)

  • Key (pk) — Primary key — NOT NULL
  • Username (username) — char
  • First name (first_name) — char
  • Last name (last_name) — char
  • Birth (birth) — date
  • Like Genres (like_genres) — json

Movie

  • Key (pk) — Primary key — NOT NULL
  • tmdb id (tmdb_id) — int
  • Title (title) — char
  • Overview (overview) — text
  • Poster path (poster_path) — text — NOT NULL
  • Genre (genre) — json
  • Adult (adult) — bool
  • Director (director) — json
  • casting — json
  • runtime — int
  • Vote avg (vote_avg) — float
  • production company (company) — json

Movie (movie_hate)

  • Key — Primary key — NOT NULL
  • user id (user_id) — int — Foreign key → Movie.Key — NOT NULL
  • movie id (movie_id) — int — Foreign key → Account.Key — NOT NULL

Movie (Movie_like)

  • Key — Primary key — NOT NULL
  • user id (user_id) — int — Foreign key → Movie.Key — NOT NULL
  • movie id (movie_id) — int — Foreign key → Account.Key — NOT NULL

Movie (Keyword)

  • Key (pk) — Primary key — NOT NULL
  • Key (movie id) — int — Foreign key → Movie.Key — NOT NULL
  • Keyword (keyword) — char

Movie (Review)

  • Key — Primary key — NOT NULL
  • User_id (user_id) — int — Foreign key → Account.Key — NOT NULL
  • movie id (movie_id) — int — Foreign key → Movie.Key — NOT NULL
  • title (Field) — char
  • content (Field2) — text
  • created_at — datetime
  • updated_at (update_at) — datetime

Movie (Review_like)

  • Key (pk) — Foreign key → Account.Key — NOT NULL
  • User_id (user_id) — int — Foreign key → Movie.User_id — NOT NULL
  • Review id (review_id) — int — Foreign key → Movie.Key — NOT NULL

Movie (keyword_agree)

  • Key (pk) — Foreign key → Movie.Key — NOT NULL
  • keyWord_id (keyword_id) — int — Foreign key → Movie.Key — NOT NULL
  • User id (user_id) — int — Foreign key → Account.Key — NOT NULL