bread
Tables (9)
accounts_preference (유저 선호장르)
- 유저_pk (user_pk) — integer — Foreign key → accounts_user.유저_pk — NOT NULL
- 장르_pk (genre_pk) — integer — Foreign key → movies_genre.장르_pk — NOT NULL
- 점수 (score) — integer
- 선호장르 (like) — bool
accounts_user (유저)
- 유저_pk (user_pk) — integer — Primary key — NOT NULL
- 유저ID (username) — varchar(150)
- 비밀번호 (password) — varchar(128)
- 마지막 로그인 (last_login) — datetime
- 슈퍼관리자권한 (is_superuser) — bool
- 성 (first_name) — varchar(150)
- 이름 (last_name) — varchar(150)
- 이메일 (email) — varchar(254)
- is_staff — bool
- is_active — bool
- date_joined — datetime
accounts_user_collection (컬렉션)
- 영화_pk (movie_pk) — integer — Foreign key → movies_movie.영화_pk — NOT NULL
- 유저_pk (user_pk) — integer — Foreign key → accounts_user.유저_pk — NOT NULL
accounts_user_followings (팔로우)
- from_user_id — integer — Foreign key → accounts_user.유저_pk — NOT NULL
- to_user_id — integer — Foreign key → accounts_user.유저_pk — NOT NULL
community_review (리뷰)
- 리뷰_pk (review_pk) — integer — Primary key — NOT NULL
- 유저_pk (user_pk) — integer — Foreign key → accounts_user.유저_pk — NOT NULL
- 영화_pk (movie_pk) — integer — Foreign key → movies_movie.영화_pk — NOT NULL
- 내용 (content) — varchar
- 만들어진 시간 (created_at) — datetime
- 수정된 시간 (updated_at) — datetime
- 점수 (score) — integer
- 스포일러여부 (is_spoiler) — bool
community_review_like (Untitled)
- 리뷰_pk (review_pk) — integer — Foreign key → community_review.리뷰_pk — NOT NULL
- 좋아요를 누른 사람 (user_pk) — integer — Foreign key → accounts_user.유저_pk — NOT NULL
movies_genre (장르)
- 장르_pk (genre_pk) — integer — Primary key — NOT NULL
- 장르명 (genre) — varchar — NOT NULL
movies_movie (영화)
- 영화_pk (movie_pk) — integer — Primary key — NOT NULL
- title — varchar
- overview — varchar
- release_date — datetime
- popularity — float
- adult — bool
- 점수 평균 (vote_average) — float
- 점수를 매긴 사람의 개수 (vote_count) — integer
- backdrop_path — varchar
- poster_path — varchar
- genre_ids — Json
- original_language — varchar
- original_title — varchar
movies_movie_genres (영화장르)
- 영화_pk (movie_pk) — integer — Foreign key → movies_movie.영화_pk — NOT NULL
- 장르_pk (genre_pk) — integer — Foreign key → movies_genre.장르_pk — NOT NULL