movie pjt
Tables (16)
accounts_user (Untitled6)
- id (Key) — integer — Primary key — NOT NULL
- movie_id (Key2) — integer — Foreign key → movies_movie.id — NOT NULL
- password (Field) — varchar(128)
- username (Field2) — varchar(150)
- email (Field3) — varchar(254)
- last_name (Field4) — varchar(150)
- first_name (Field5) — varchar(150)
- date_joined (Field6) — datetime
- last_login (Field7) — datetime
accounts_user (Untitled10)
- Key (id) — integer — Primary key — NOT NULL
- Field (password) — varchar
- Field (username) — varchar
- Field (first_name) — varchar
- Field (last_name) — varchar
- Field (email) — varchar
community_comment (게시글 댓글)
- id (Key4) — integer — Primary key — NOT NULL
- review_id (Key) — integer — Foreign key → community_post.user_id — NOT NULL
- user_id (Key3) — integer — Foreign key → accounts_user.id — NOT NULL
- content (Field4) — text
- created_at (Field5) — datetime
- updated_at (Field6) — datetime
community_comment (Untitled12)
- Key (id) — integer — Primary key — NOT NULL
- Key (post_id) — integer — Foreign key → community_post.Key — NOT NULL
- Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
- Field (content) — text
- Field (created_at) — datetime
- Field (updated_at) — datetime
community_post (게시글)
- id (Key2) — integer — Primary key — NOT NULL
- user_id (Key) — integer — Foreign key → accounts_user.id — NOT NULL
- title (Field)
- content (Field2)
- created_ate (Field3)
- updated_at (Field4)
community_post (Untitled13)
- Key (id) — integer — Primary key — NOT NULL
- Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
- Field (title) — varchar
- Field (content) — text
- Field (created_at) — datetime
- Field (updated_at) — datetime
movie_comment (영화 댓글)
- id (Key) — Primary key — NOT NULL
- movie_id (영화id) — integer — Foreign key → movies_movie.id — NOT NULL
- user_id (유저id) — integer — Foreign key → accounts_user.id — NOT NULL
- rank (평점) — integer
- content (내용) — char
- created_at (생성시간) — datetime
- updated_at (수정시간) — datetime
movies.movie (Untitled4)
- Key (id) — integer — Primary key — NOT NULL
- Field (title) — text
- Field (original_title) — text
- Field (overview) — text
- Field (poster_path) — text
- Field (vote_average) — real
- Field (vote_count) — integer
- Field (release_date) — text
- Field (runtime) — integer
- Field (popularity) — real
- Field (adult) — bool
movies_genre (Untitled2)
- id (Key) — integer — Primary key — NOT NULL
- name (Field) — varchar(50)
movies_genre (Untitled5)
- Key (id) — integer — Primary key — NOT NULL
- Field (name) — text
movies_movie (Untitled)
- id (Key) — integer — Primary key — NOT NULL
- poster_path (Field) — varchar(200)
- audlt (Field2) — bool
- overview (Field3) — text
- release_date (Field4) — date
- original_title (Field5) — varchar(100)
- original_language (Field6) — varchar(100)
- title (Field7) — varchar(100)
- popularity (Field8) — real
- vote_count (Field9) — integer
- vote_average (Field10) — real
movies_movie_genre_ids (Untitled3)
- id (Key) — integer — Primary key — NOT NULL
- id (Key2) — integer — Foreign key → movies_movie.id — NOT NULL
- id (Key3) — integer — Foreign key → movies_genre.id — NOT NULL
movies_movie_genres (Untitled7)
- Key (id) — integer — 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 (Untitled11)
- Key (id) — integer — Primary key — NOT NULL
- Key (movie_id) — bigint — Foreign key → movies.movie.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → accounts_user.Key — NOT NULL
movies_review (Untitled8)
- Key (id) — integer — Primary key — NOT NULL
- Key (movie_id) — integer — Foreign key → movies.movie.Key — NOT NULL
- Key (id2) — integer — Foreign key → accounts_user.Key — NOT NULL
- Field (title) — varchar
- Field (content) — text
- Field (rank) — integer
- Field (created_at) — datetime
- Field (updated_at) — datetime
movies_reviewcomment (Untitled9)
- Key (id) — integer — Primary key — NOT NULL
- Key (review_id) — bigint — Foreign key → movies_review.Key — NOT NULL
- Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
- Key (id2) — integer — Foreign key → movies_review.Key — NOT NULL
- Field (content) — text
- Field (rank) — integer
- Field (created_at) — datetime
- Field (updated_at) — datetime