final pjt
Tables (11)
account_user (Untitled5)
- id (Key) — integer — Primary key — NOT NULL
- username (Field2) — varchar(150)
- email (Field3) — varchar(254)
- password (Field) — varchar(128)
- 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
accounts_user_followers (Untitled7)
- id (Key) — integer — Primary key — NOT NULL
- from_user_id (Key2) — integer — Foreign key → account_user.id — NOT NULL
- to_user_id (Key3) — integer
community_comment (Untitled6)
- id (Key) — integer — Primary key — NOT NULL
- review_id (ForeignKey) — integer — Foreign key → community_review.movie_id — NOT NULL
- user_id (ForeignKey2) — integer — Foreign key → account_user.id — NOT NULL
- content (Field) — text
community_review (Untitled2)
- id (Key) — integer — Primary key — NOT NULL
- movie_id (ForeignKey) — integer — Foreign key → movies_movie.id — NOT NULL
- user_id (Key2) — integer — Foreign key → account_user.id — NOT NULL
- title (Field) — varchar(50)
- rank (Field2) — integer
- content (Field3) — text
- created_at (Field4) — datetime
- updated_at (Field5) — datetime
community_review_like (Untitled8)
- id (Key) — integer — Primary key — NOT NULL
- review_id (Key2) — integer — Foreign key → community_review.id — NOT NULL
- user_id (Key3) — integer — Foreign key → account_user.id — NOT NULL
movies_genre (Untitled3)
- id (Key) — integer — Primary key — NOT NULL
- name (Field) — varchar(50)
movies_keyword (Untitled10)
- Key — integer — Primary key — NOT NULL
- word (Field) — varchar(200)
- count (Field2) — integer
movies_movie (Untitled)
- id (Key) — integer — Primary key — NOT NULL
- title (Field) — varchar(200)
- poster_path (Field2) — varchar(200)
- popularity (Field3) — real
- vote_count (Field4) — integer
- vote_average (Field5) — real
- overview (Field6) — text
- release_date (Field7) — date
- adult (Field8) — bool
movies_movie_genres (Untitled4)
- id (Key) — integer — Primary key — NOT NULL
- movie_id (Key2) — integer — Foreign key → movies_movie.id — NOT NULL
- genre_id (Key3) — integer — Foreign key → movies_genre.id — NOT NULL
movies_movie_movie_keywords (Untitled9)
- Key — integer — Primary key — NOT NULL
- movie_id (Key2) — integer — Foreign key → movies_movie.id — NOT NULL
- keyword_id (Key3) — integer — Foreign key → movies_keyword.Key — NOT NULL
movies_movie_movie_like_users (Untitled11)
- id (Key) — integer — Primary key — NOT NULL
- movie_id (Key2) — integer — Foreign key → movies_movie.id — NOT NULL
- user_id (Key3) — integer — Foreign key → account_user.id — NOT NULL