pjt_final

Tables (5)

accounts_user (Untitled)

  • Key — Primary key — NOT NULL
  • password (Field) — varchar
  • username (Field2) — varchar
  • email (Field3) — varchar
  • last_name (Field4) — varchar
  • first_name (Field5) — varchar
  • image (Field6) — Image
  • face_recognition_name (Field7) — varchar
  • face_recognition_image (Field8) — image

community_comment (Untitled3)

  • Key — Primary key — NOT NULL
  • user_id2 (Key3) — integer — Foreign key → accounts_user.Key — NOT NULL
  • review_id (Key2) — integer — Foreign key → community_review.Key2 — NOT NULL
  • content (Field) — text

community_review (Untitled2)

  • Key2 — Primary key — NOT NULL
  • user_id (Key3) — integer — Foreign key → accounts_user.Key — NOT NULL
  • title (Field) — varchar
  • movie_title (Field2) — varchar
  • rank (Field3) — integer
  • content_at (Field4) — datetime
  • updated_at (Field5) — datetime

movies_movie (Untitled5)

  • Key — Primary key — NOT NULL
  • title (Field) — varchar
  • release_date (Field2) — date
  • popularity (Field3) — real
  • vote_count (Field4) — integer
  • vote_average (Field5) — real
  • overview (Field6) — text
  • poster_path (Field7) — varchar
  • genre (Field8) — varchar

movies_rank (Untitled4)

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