Movie_PJT

Tables (8)

Copy Of movies_review_love_users (CopyOfCopyOfUntitled6)

  • Key — Primary key — NOT NULL
  • Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
  • Key (review_id) — integer — Foreign key → movies_review.Key — NOT NULL

accounts_user (Untitled)

  • Key (user_id) — Primary key — NOT NULL
  • Field (password) — varchar(128)
  • Field (username) — varchar(150)
  • Field (email) — varchar(254)
  • Field (is_superuser) — bool
  • Field (is_staff) — bool
  • Field (is_active) — bool
  • Field (last_name) — varchar(150)
  • Field (first_name) — varchar(150)
  • Field (date_joined) — datetime
  • Field (last_login) — datetime

movies_genre (Untitled4)

  • Key (genre_id) — Primary key — NOT NULL
  • Field (name) — varchar(50)

movies_genre_pick_user (CopyOfUntitled62)

  • Key — Primary key — NOT NULL
  • Key (genre_id) — integer — Foreign key → movies_genre.Key — NOT NULL
  • Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL

movies_movie (Untitled2)

  • Key (movie_id) — Primary key — NOT NULL
  • Field1 (title) — varchar(100)
  • Field7 (poster_path) — varchar(200)
  • Field6 (overview) — text
  • Field2 (release_date) — date
  • Field3 (popularity) — real
  • Field4 (vote_count) — integer
  • Field5 (vote_average) — real

movies_movie_genres (Untitled6)

  • Key — Primary key — NOT NULL
  • Key (movie_id) — integer — Foreign key → movies_movie.Key — NOT NULL
  • Key (genre_id) — integer — Foreign key → movies_genre.Key — NOT NULL

movies_movie_like_users (CopyOfUntitled6)

  • Key — Primary key — NOT NULL
  • Key (movie_id) — integer — Foreign key → movies_movie.Key — NOT NULL
  • Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL

movies_review (Untitled3)

  • Key (review_id) — Primary key — NOT NULL
  • Field (content) — text
  • Field (created_at) — datetime
  • Field2 (updated_at) — datetime
  • Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
  • Key (movie_id) — integer — Foreign key → movies_movie.Key — NOT NULL