unknown2

Tables (16)

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

Copy Of Untitled5 (CopyOfUntitled5)

  • Key2 (Key) — Primary key — NOT NULL
  • Field
  • Field2

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

Untitled

  • Key1 (Key) — Primary key — NOT NULL
  • Field

Untitled2

  • Key2 — Primary key — NOT NULL
  • Key — Foreign key → Untitled.Key1 — NOT NULL
  • Key4 (Key3) — Foreign key → Untitled3.Key4 — NOT NULL
  • Field
  • Field2
  • Key7 (Key4) — Foreign key → Untitled4.Key7 — NOT NULL
  • Key1 (Key22) — Foreign key → Untitled4.Key1 — NOT NULL

Untitled3

  • Key4 (Key) — Primary key — NOT NULL
  • Field

Untitled4

  • Key7 (Key) — Primary key — NOT NULL
  • Key1 (Key2) — Foreign key → Untitled5.Key1 — NOT NULL
  • Field

Untitled5

  • Key1 (Key) — Primary key — NOT NULL
  • Field
  • Field2

Untitled6

  • Key3 (Key) — Primary key — NOT NULL
  • Key1 (Key2) — Foreign key → Untitled5.Key1 — NOT NULL
  • Field
  • Field2
  • Key2 (Key3) — Foreign key → Copy Of Untitled5.Key2 — NOT NULL

Untitled7

    User (user)

    • user_id — IntegerField — Primary key — NOT NULL
    • username — CharField
    • password1 — CharField
    • password2 — CharField
    • follower — ManyToManyField