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