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