Movie_PJT
Tables (8)
Copy Of movies_review_love_users (CopyOfCopyOfUntitled6)
- Key — Primary key — NOT NULL
- Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
- Key (review_id) — integer — Foreign key → movies_review.Key — NOT NULL
accounts_user (Untitled)
- Key (user_id) — Primary key — NOT NULL
- Field (password) — varchar(128)
- Field (username) — varchar(150)
- Field (email) — varchar(254)
- Field (is_superuser) — bool
- Field (is_staff) — bool
- Field (is_active) — bool
- Field (last_name) — varchar(150)
- Field (first_name) — varchar(150)
- Field (date_joined) — datetime
- Field (last_login) — datetime
movies_genre (Untitled4)
- Key (genre_id) — Primary key — NOT NULL
- Field (name) — varchar(50)
movies_genre_pick_user (CopyOfUntitled62)
- Key — Primary key — NOT NULL
- Key (genre_id) — integer — Foreign key → movies_genre.Key — NOT NULL
- Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
movies_movie (Untitled2)
- Key (movie_id) — Primary key — NOT NULL
- Field1 (title) — varchar(100)
- Field7 (poster_path) — varchar(200)
- Field6 (overview) — text
- Field2 (release_date) — date
- Field3 (popularity) — real
- Field4 (vote_count) — integer
- Field5 (vote_average) — real
movies_movie_genres (Untitled6)
- Key — Primary key — NOT NULL
- Key (movie_id) — integer — Foreign key → movies_movie.Key — NOT NULL
- Key (genre_id) — integer — Foreign key → movies_genre.Key — NOT NULL
movies_movie_like_users (CopyOfUntitled6)
- Key — Primary key — NOT NULL
- Key (movie_id) — integer — Foreign key → movies_movie.Key — NOT NULL
- Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
movies_review (Untitled3)
- Key (review_id) — Primary key — NOT NULL
- Field (content) — text
- Field (created_at) — datetime
- Field2 (updated_at) — datetime
- Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
- Key (movie_id) — integer — Foreign key → movies_movie.Key — NOT NULL