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