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