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