movie recommendation
Tables (21)
Actor (Untitled11)
- id (Key) — INT — Primary key — NOT NULL
- code (Key2) — CHAR — Primary key — NOT NULL
- name (Field) — CHAR
- image_url (Field3) — TEXT
CommingMovie (Untitled15)
- id (Key) — INT — Primary key — NOT NULL
- title (Field) — CHAR
- openDt (Field2)
Director (Untitled13)
- id (Key) — INT — Primary key — NOT NULL
- code (Key2) — CHAR — Primary key — NOT NULL
- name (Field) — CHAR
- image_url (Field2) — TEXT
Genre (Untitled3)
- id (Key) — INT — Primary key — NOT NULL
- name (Key2) — CHAR — Primary key — NOT NULL
Movie (Untitled2)
- id (Key) — INT — Primary key — NOT NULL
- title (Field) — CHAR
- post_url (Field2) — TEXT
- code (Field3) — CHAR
- discription (Field4) — TEXT
- audience (Field5) — INT
- watch_grade (Field6) — INT
- watch_grade_name (Field7) — CHAR
- score (Field8) — FLOAT
MovieComment (Untitled10)
- id (Key) — INT — Primary key — NOT NULL
- recommend_id (Key2) — INT — Foreign key → Recommend.id — NOT NULL
- movie_id (Key3) — INT — Foreign key → Movie.id — NOT NULL
- content (Field) — TEXT
Movie_like_Actor (Untitled12)
- id (Key) — Primary key — NOT NULL
- actor_id (Key2) — INT — Foreign key → Actor.id — NOT NULL
- movie_id (Key3) — INT — Foreign key → Movie.id — NOT NULL
Movie_like_Director (Untitled14)
- id (Key) — INT — Primary key — NOT NULL
- movie_id (Key2) — INT — Foreign key → Movie.id — NOT NULL
- director_id (Key3) — INT — Foreign key → Director.id — NOT NULL
Movie_like_Genre (Untitled7)
- id (Key) — Primary key — NOT NULL
- genre_id (Key2) — INT — Foreign key → Genre.id — NOT NULL
- movie_id (Key3) — INT — Foreign key → Movie.id — NOT NULL
Movie_like_Recommend (Untitled8)
- id (Key) — INT — Primary key — NOT NULL
- movie_id (Key2) — INT — Foreign key → Movie.id — NOT NULL
- recommend_id (Key22) — INT — Foreign key → Recommend.id — NOT NULL
Recommend (Untitled5)
- id (Key2) — INT — Primary key — NOT NULL
- user_id (Key) — INT — Foreign key → User.id — NOT NULL
- title (Field) — CHAR
- discription (Field2) — TEXT
RecommendReview (Untitled9)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- recommend_id (Key22) — INT — Foreign key → Recommend.id — NOT NULL
- content (Field) — CHAR
Review (Untitled4)
- id (Key3) — INT — Primary key — NOT NULL
- user_id (Key) — INT — Foreign key → User.id — NOT NULL
- movie _id (Key2) — INT — Foreign key → Movie.id — NOT NULL
- content (Field) — CHAR
- score (Field2) — INT
User (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- username (Field) — CHAR
- email (Field2) — VAR
- password (Field3) — VAR
- age (Field4) — INT
User_like_Actor (Untitled18)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- actor_id (Key3) — INT — Foreign key → Actor.id — NOT NULL
User_like_CommingMovie (Untitled19)
- id (Key) — INT — Primary key — NOT NULL
- commingmovie_id (Key2) — INT — Foreign key → CommingMovie.id — NOT NULL
- user_id (Key3) — INT — Foreign key → User.id — NOT NULL
User_like_Director (Untitled17)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- director_id (Key3) — INT — Foreign key → Director.id — NOT NULL
User_like_Genre (Untitled16)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- gnere_id (Key3) — INT — Foreign key → Genre.id — NOT NULL
User_like_Movie (Untitled6)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- movie_id (Key3) — INT — Foreign key → Movie.id — NOT NULL
User_like_Recommend (Untitled20)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- recommend_id (Key22) — INT — Foreign key → Recommend.id — NOT NULL
User_like_Review (Untitled21)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- review_id (Key3) — INT — Foreign key → Review.id — NOT NULL