final_project
Tables (8)
accounts_user (계정)
- id (pk) — integer — Primary key — NOT NULL
- password (비밀번호) — varchar(128)
- username (유저 id) — varchar(150)
- email (이메일) — varchar(254)
- is_superuser (슈퍼 유저 권한) — bool
- is_staff — bool
- is_active (로그인 유무) — bool
- last_name (성) — varchar(150)
- first_name (이름) — varchar(150)
- date_joined (가입 날짜) — datetime
- last_login (마지막 로그인) — datetime
- following (팔로우 id) — integer — Foreign key → accounts_user.id — NOT NULL
accounts_user_wishlist (유저-영화 M:N 필드)
- id (pk) — integer — Primary key — NOT NULL
- user_id (유저 pk) — integer — Foreign key → accounts_user.id — NOT NULL
- movie_id (영화 pk) — integer — Foreign key → movies_movie.id — NOT NULL
movies_genre (영화 장르)
- id (pk) — integer — Primary key — NOT NULL
- name (장르 이름) — varchar(50)
movies_movie (영화)
- id (pk) — integer — Primary key — NOT NULL
- title (제목) — varchar(100)
- release_date (개봉일) — date
- popularity (인기도) — float
- vote_count (투표 수) — integer
- vote_average (평균 점수) — real
- overview (영화 줄거리) — text
- poster_path (포스터 url) — varchar(200)
- rate_average (유저 평균 점수) — float
movies_movie_genres (영화-장르 M:N 필드)
- id (pk) — integer — Primary key — NOT NULL
- movie_id (영화 pk) — integer — Foreign key → movies_movie.id — NOT NULL
- genre_id (장르 pk) — integer — Foreign key → movies_genre.id — NOT NULL
reviews_comment (리뷰 댓글)
- id (pk) — integer — Primary key — NOT NULL
- user_id (유저 pk) — integer — Foreign key → accounts_user.id — NOT NULL
- review_id (리뷰 pk) — integer — Foreign key → reviews_review.user_id — NOT NULL
- content (댓글 내용) — text
- created_at (작성 날짜) — datetime
- updated_at (수정 날짜) — datetime
reviews_review (사용자 작성 리뷰)
- id (pk) — integer — Primary key — NOT NULL
- user_id (유저 pk) — integer — Foreign key → accounts_user.id — NOT NULL
- movie_id (영화 pk) — integer — Foreign key → movies_movie.id — NOT NULL
- title (리뷰 제목) — varchar(100)
- rank (리뷰 점수) — integer
- content (리뷰 내용) — text
- created_at (작성 날짜) — datetime
- updated_at (수정 날짜) — datetime
reviews_review_like (리뷰 좋아요)
- id (pk) — integer — Primary key — NOT NULL
- user_id (유저 pk) — integer — Foreign key → accounts_user.id — NOT NULL
- review_id (리뷰 pk) — integer — Foreign key → reviews_review.id — NOT NULL
- id (pk2) — integer — Foreign key → reviews_review.movie_id — NOT NULL