erd_1

Tables (9)

accounts_user (유저)

  • user_id (Key) — integer — Primary key — NOT NULL
  • password (pw) — text
  • username (name) — text
  • first_name (Field5) — text
  • last_name (Field6) — text
  • email (Field4) — text
  • age (Field) — integer
  • sex (Field2) — boolean
  • preference (Field3) — integer

admin (관리자)

  • admin_id (Key) — integer — Primary key — NOT NULL
  • name (이름) — varchar()
  • password (비번) — varchar()

community_comment (커뮤니티 댓글)

  • user_id (Key2) — integer — Foreign key → accounts_user.user_id — NOT NULL
  • review_id (Key3) — integer — Foreign key → community_review.review_id — NOT NULL
  • content (Field) — varchar()

community_review (커뮤니티 리뷰)

  • review_id (Key3) — integer — Primary key — NOT NULL
  • user_id (Key) — integer — Foreign key → accounts_user.user_id — NOT NULL
  • movie_id (Key2) — integer — Foreign key → movies_movie.movie_id — NOT NULL
  • title (Field) — varchar()
  • content (Field2) — varchar()
  • rating (Field3) — integer
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

movies_genre (영화장르)

  • genre_id (Key2) — Primary key — NOT NULL
  • movie_id (Key) — integer — Foreign key → movies_movie.movie_id — NOT NULL
  • name (Field) — text

movies_genre_like (유저 선호 장르)

  • user_id (Key) — integer — Foreign key → accounts_user.user_id — NOT NULL
  • genre_id (Key2) — Foreign key → movies_genre.genre_id — NOT NULL

movies_movie (영화정보)

  • movie_id (Key) — integer — Primary key — NOT NULL
  • genre_id (Key23) — Foreign key → movies_genre.genre_id — NOT NULL
  • adult (Field2) — boolean
  • genres (Field) — array
  • original_title (Field3) — text
  • overview (Field4) — text
  • popularity (Field5) — float
  • poster_path (Field6) — text
  • release_date (Field7) — text
  • runtime (Key22) — integer — NOT NULL
  • title (Key2) — text — NOT NULL
  • vote_average (Field8) — float
  • vote_count (Field9) — integer

movies_movie_dislike (영화 싫어요)

  • user_id (Key) — integer — Foreign key → accounts_user.user_id — NOT NULL
  • movie_id (Key2) — integer — Foreign key → movies_movie.movie_id — NOT NULL

movies_movie_like (영화 좋아요)

  • movie_id (Key) — integer — Foreign key → movies_movie.movie_id — NOT NULL
  • user_id (Key2) — integer — Foreign key → accounts_user.user_id — NOT NULL