finalpjt

Tables (6)

accounts_user (Untitled2)

  • id (Key) — integer — Primary key — NOT NULL
  • password (Field) — varchar
  • last_login (Field2) — datetime
  • is_superuser (Field3) — bool
  • username (Field4) — varchar(150)
  • first_name (Field5) — varchar(150)
  • last_name (Field6) — varchar(150)
  • email (Field7) — varchar(254_
  • is_staff (Field8) — bool
  • is_active (Field9) — bool
  • date_joined (Field10)
  • Field11

movies_comment (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • Key (Key2) — integer — Foreign key → accounts_user.id — NOT NULL
  • content (Field) — varchar
  • Field2

movies_genre (Untitled5)

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

movies_movie (Untitled4)

  • id (Key) — integer — Primary key — NOT NULL
  • id (Key2) — integer — Foreign key → movies_review.id — NOT NULL
  • user_id (Key22) — integer — Foreign key → movies_review.user_id — NOT NULL
  • id (Key3) — Foreign key → movies_review.id — NOT NULL
  • Key (Key222) — integer — Foreign key → movies_review.Key — NOT NULL
  • popularity (Field) — real
  • vote_count (Field2) — integer
  • vote_average (Field3) — real
  • overview (Field4) — text
  • poster_path (Field5) — varchar(200)
  • title (Field6) — varchar(50)
  • release_date (Field7) — date
  • video (Field8) — bool
  • adult (Field9) — bool
  • backdrop_path (Field10) — varchar(200)
  • original_language (Field11) — varchar(10)
  • original_title (Field12) — varchar(50)

movies_movie_genre_ids (Untitled6)

  • id (Key) — integer — Primary key — NOT NULL
  • user_id (Key222) — integer — Foreign key → movies_movie.user_id — NOT NULL
  • movie_id (Key2) — integer — Foreign key → movies_genre.id — NOT NULL

movies_review (Untitled)

  • id (Key) — integer — Primary key — NOT NULL
  • user_id (Key2) — integer — Foreign key → accounts_user.id — NOT NULL
  • id (Key3) — Foreign key → movies_comment.id — NOT NULL
  • Key (Key22) — integer — Foreign key → movies_comment.Key — NOT NULL
  • title (Field) — varchar
  • score (Field2) — integer
  • content (Field3) — text
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime
  • Field6
  • Field7