movie_pjt
Tables (8)
Cast (cast)
- cast_id — IntergerField — Primary key — NOT NULL
- character — CharField
- title — CharField
- poster_path — CharField
- overview — TextField
- gender — IntegerField
- profile_path — CharField
- imdb_id — IntegerField
M:N (Movie & Cast)
- movie_id (id) — IntegerField — Foreign key → Movie.movie_id — NOT NULL
- cast_id — IntergerField — Foreign key → Cast.cast_id — NOT NULL
M:N (Like)
- user_id — IntegerField — Foreign key → User.user_id — NOT NULL
- review_id — IntegerField — Foreign key → Review.review_id — NOT NULL
- movie_id (id2) — IntegerField — Foreign key → Review.movie_id — NOT NULL
Movie (movie)
- movie_id (id) — IntegerField — Primary key — NOT NULL
- title — CharField
- overview — TextField
- poster_path — CharField
- cast — ManyToManyField
MovieComment (moviecomment)
- moviecomment_id — IntegerField — Primary key — NOT NULL
- movie_id (id) — IntegerField — Foreign key → Movie.movie_id — NOT NULL
- user_id — IntegerField — Foreign key → User.user_id — NOT NULL
- score — IntegerField
- content — CharField
- created_at — DateTimeField
- updated_at — DateTimeField
ReivewComment (reviewcomment)
- comment_id — IntegerField — Primary key — NOT NULL
- review_id — IntegerField — Foreign key → Review.review_id — NOT NULL
- movie_id (id) — IntegerField — Foreign key → Review.movie_id — NOT NULL
- user_id (user_id2) — IntegerField — Foreign key → User.user_id — NOT NULL
- content — CharField
- created_at — DateTimeField
- updated_at — DateTimeField
Review (review)
- review_id — IntegerField — Primary key — NOT NULL
- movie_id (id) — IntegerField — Foreign key → Movie.movie_id — NOT NULL
- user_id — IntegerField — Foreign key → User.user_id — NOT NULL
- title — CharField
- content — TextField
- created_at — DateTimeField
- updated_at — DateTimeField
- like_users — ManyToManyField
User (user)
- user_id — IntegerField — Primary key — NOT NULL
- username — CharField
- password1 — CharField
- password2 — CharField
- follower — ManyToManyField