1학기 pjt

테이블 (12)

accounts_user

  • user_id (id) — int — 기본 키 — NOT NULL
  • password — varchar(128)
  • username — varchar(150)
  • last_name (lastname) — varchar(150)
  • first_name (firstname) — varchar(150)
  • date_joined (datejoined) — datetime
  • nick_name (nickname) — varchar(150)
  • email — varchar(254)

actor_detail

  • person_id — int — 외래 키 → movies_credit.person_id
  • movie_id (id2) — int — 외래 키 → movies_credit.movie_id — NOT NULL
  • person_id (person_id2) — int — 외래 키 → movies_credit.person_id
  • name — varchar(128)
  • profile_path — varchar(254)
  • overview — text
  • vote_average — int
  • vote_count — int

actor_movie_list

  • person_id — int — 외래 키 → actor_detail.person_id
  • movie_id (id2) — int — 외래 키 → actor_detail.movie_id — NOT NULL
  • person_id (person_id2) — int — 외래 키 → actor_detail.person_id
  • title — varchar(128)
  • genre_ids — int
  • poster_path — varchar(254)
  • release_date
  • vote_average — int
  • vote_count — int

community_comment

  • id (review_id) — int — 외래 키 → community_review.id — NOT NULL
  • user_id — int — 외래 키 → accounts_user.user_id — NOT NULL
  • content — text
  • created_at — datetime

community_review (communtiy review)

  • id (review_id) — int — 기본 키 — NOT NULL
  • person_id — int — 외래 키 → movies_movie.person_id
  • title — varchar(100)
  • content — text
  • liked — bool
  • created_at — datetime
  • updated_at — datetime
  • Field

community_review_like_users

  • user_id (id) — int — 외래 키 → community_review.id — NOT NULL
  • person_id — int — 외래 키 → community_review.person_id
  • id (review_id) — int — 외래 키 → accounts_user.user_id — NOT NULL

director_detail

  • person_id — int — 외래 키 → movies_credit.person_id
  • movie_id (id2) — int — 외래 키 → movies_credit.movie_id — NOT NULL
  • person_id (person_id2) — int — 외래 키 → movies_credit.person_id
  • name — varchar(128)
  • profile_path — varchar(254)
  • overview — text
  • vote_average — int
  • vote_count — int

director_movie_list

  • person_id — int — 외래 키 → director_detail.person_id
  • movie_id (id2) — int — 외래 키 → director_detail.movie_id — NOT NULL
  • person_id (person_id2) — int — 외래 키 → director_detail.person_id
  • title — varchar(128)
  • genre_ids — int
  • poster_path — varchar(254)
  • release_date
  • vote_average — int
  • vote_count — int

movies_credit

  • person_id — int — 기본 키
  • movie_id (id) — int — 외래 키 → movies_movie.movie_id — NOT NULL
  • person_id (person_id2) — int — 외래 키 → movies_movie.person_id
  • name — varchar(128)
  • profile_path — varcahr(254)
  • character — varchar(128)
  • known_for_department (is_acting) — bool
  • known_for_department (id_directing) — bool

movies_genre

  • genre_id — int — 기본 키 — NOT NULL
  • genre_name — varchar(128) — 기본 키 — NOT NULL
  • movie_id (id) — int — 외래 키 → movies_movie.movie_id — NOT NULL
  • actor_id — int — 외래 키 → movies_movie.actor_id
  • person_id — int — 외래 키 → movies_movie.person_id

movies_movie

  • movie_id (id) — int — 기본 키 — NOT NULL
  • actor_id — int — 외래 키 → actor_movie_list.person_id
  • person_id — int — 외래 키 → director_movie_list.person_id
  • title — varchar(128)
  • released_date (releaseddate) — date
  • poster_path (poster) — varchar(254)
  • overview — text
  • adult — bool
  • vote_average — int
  • vote_count — int
  • backdrop_path — varchar(254)

movies_video

  • Key — varchar(128) — 기본 키 — NOT NULL
  • movie_id (id) — int — 외래 키 → movies_movie.movie_id — NOT NULL