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