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