final-pjt

Tables (7)

accounts_user (user)

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

community_comment (CopyOfCopyOfuser)

  • user_id (Key2) — integer — Foreign key → accounts_user.id
  • review_id (Key22) — integer — Foreign key → community_review.user_id
  • content (Field2) — text

community_review (CopyOfuser)

  • user_id (Key2) — integer — Foreign key → accounts_user.id
  • title (Field) — varchar(100)
  • movie_title (Field2) — varchar(50)
  • rank (Field3) — integer
  • content (Field4) — text
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

community_review_like (CopyOfCopyOfCopyOfuser)

  • user_id (Key2) — integer — Foreign key → accounts_user.id
  • review_id (Key22) — integer — Foreign key → community_review.user_id

movies_genre (CopyOfCopyOfCopyOfCopyOfuser)

  • name (Key2) — varchar(50) — Foreign key → movies_movie.id

movies_movie (CopyOfCopyOfuser2)

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

movies_review (CopyOfCopyOfCopyOfCopyOfCopyOfuser)

  • user_id (Key) — integer — Foreign key → accounts_user.id
  • movie_id (Key2) — integer — Foreign key → movies_movie.id
  • context (Field2) — text
  • rank (Field3) — integer