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