final_pjt
Tables (7)
accounts_user
- PK (id) — NOT NULL — Primary key — NOT NULL
- 비밀번호 (password) — NOTNULL
- 유저이름 (username) — NOTNULL
community_comment (Untitled2)
- PK (comment_id) — NOT NULL — Primary key — NOT NULL
- PK (review_id) — NOT NULL — Foreign key → community_review.PK — NOT NULL
- FK (movie_id) — NOT NULL — Foreign key → community_review.FK — NOT NULL
- FK (user_id) — NOT NULL — Foreign key → community_review.FK — NOT NULL
- 댓글내용 (comment) — NOTNULL
community_review (Untitled)
- PK (review_id) — NOT NULL — Primary key — NOT NULL
- FK (movie_id) — NOT NULL — Foreign key → moives_movie.PK — NOT NULL
- FK (user_id) — NOT NULL — Foreign key → accounts_user.PK — NOT NULL
- 리뷰제목 (title) — NOTNULL
- 리뷰내용 (content) — NOTNULL
community_review_like (Untitled5)
- PK (id) — NOT NULL — Primary key — NOT NULL
- PK (review_id) — NOT NULL — Foreign key → community_review.PK — NOT NULL
- FK (movie_id) — NOT NULL — Foreign key → community_review.FK — NOT NULL
- PK (user_id) — NOT NULL — Foreign key → accounts_user.PK — NOT NULL
moives_movie (movies_movie)
- PK (id) — NOT NULL — Primary key — NOT NULL
- 제목 (title) — NOTNULL
- 줄거리 (overview) — NOTNULL
- 개봉일 (relase_date) — NOTNULL
- 관객수 (popularity) — NOTNULL
- 평점 (vote_average) — NOTNULL
- 포스터 (poster_url) — NULL
movies_genre (Untitled3)
- PK (id) — NOT NULL — Primary key — NOT NULL
- PK (id2) — NOT NULL — Foreign key → moives_movie.PK — NOT NULL
- 장르이름 (name) — NOTNULL
movies_movie_recommeded_movies (Untitled4)
- PK (id) — NOT NULL — Primary key — NOT NULL
- PK (id2) — NOT NULL — Foreign key → moives_movie.PK — NOT NULL