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