movie_recommendation_site

Tables (7)

Comment (Untitled5)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • uid (Key2) — Integer — Foreign key → User.id — NOT NULL
  • mid (Key3) — Integer — Foreign key → Movie.id — NOT NULL
  • content (Field) — TextField
  • created_at (Field2) — DateTimeField
  • updated_at (Field3) — DateTimeField

Credit (Untitled4)

  • id (Key) — Integer — Primary key — NOT NULL
  • mid (Key2) — Integer — Foreign key → Movie.id — NOT NULL
  • credit_id (Field) — CharField
  • name (Field2) — CharField
  • character (Field3) — CharField
  • cast_id (Field4) — IntegerField
  • credit_id (Field5) — CharField
  • cid (Field6) — IntegerField
  • popularity (Field7) — FloatField
  • profile_path (Field8) — CharField

Genre (Untitled3)

  • id (Key) — Integer — Primary key — NOT NULL
  • gid (Field) — Integer
  • gname (Field2) — CharField

Genre_Movies (Untitled6)

  • mid (Key2) — Integer — Foreign key → Movie.id — NOT NULL
  • gid (Key) — Integer — Foreign key → Genre.id — NOT NULL

Movie (Untitled2)

  • id (Key) — Integer — Primary key — NOT NULL
  • mid (Field) — Integer
  • title (Field2) — CharField
  • overview (Field3) — TextField
  • popularity (Field4) — FloatField
  • original_title (Field5) — CharField
  • vote_average (Field6) — FloatField
  • vote_count (Field7) — IntegerField
  • poster_path (Field8) — CharField
  • backdrop_path (Field9) — CharField
  • relase_date (Field10) — DateField
  • adult (Field11) — BooleanField

User (Untitled)

  • id (Key) — Integer — Primary key — NOT NULL
  • username (Field) — CharField
  • password (Field2) — CharField

user_likes_movies (Untitled7)

  • uid (Key) — Integer — Foreign key → User.id — NOT NULL
  • mid (Key2) — Integer — Foreign key → Movie.id — NOT NULL