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