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