movie

Tables (11)

MoviesAndGenre (영화와장르)

  • movie_id (영화아이디) — Foreign key → movies.movie_id — NOT NULL
  • genre_id (장르아이디) — Foreign key → genre.genre_id — NOT NULL

accounts (계정)

  • accounts_id (계정아이디) — Primary key — NOT NULL
  • accounts_name (계정명)
  • accounts_username (계정이름)
  • accounts_password (계정비밀번호)
  • accounts_email (계정이메일)
  • accounts_phonenumber (계정전화번호)

accounts_vote (영화평가점수)

  • accounts_id (계정아이디) — Foreign key → accounts.accounts_id — NOT NULL
  • movie_id (영화아이디) — Foreign key → movies.movie_id — NOT NULL
  • vote (평가)

comments (댓글(리뷰))

  • comments_id (댓글아이디) — Primary key — NOT NULL
  • accounts_id (계정아이디) — Foreign key → accounts.accounts_id — NOT NULL
  • movie_id (영화아이디) — Foreign key → movies.movie_id — NOT NULL
  • comments_contents (댓글내용)
  • comments_status (댓글상태)
  • comments_created_at (작성일)

comments_history (댓글수정내역)

  • count — Primary key — NOT NULL
  • comments_id (댓글아이디) — Foreign key → comments.comments_id — NOT NULL
  • before_content (그전내용)
  • comments_history_created_at (댓글수정일)

comments_like (댓글좋아요)

  • comments_id (댓글아이디) — Foreign key → comments.comments_id — NOT NULL
  • accounts_id (계정아이디) — Foreign key → accounts.accounts_id — NOT NULL

genre (장르)

  • genre_id (장르아이디) — Primary key — NOT NULL
  • genre_name (장르명)

movies (영화)

  • movie_id (영화아이디) — Primary key — NOT NULL
  • adult (성인여부)
  • original_language (본래언어)
  • original_title (본래제목)
  • overview (내용)
  • popularity (인기도)
  • poster_path (포스터경로)
  • release_date (개봉날짜)
  • video (비디오여부)
  • vote_average (평점)
  • vote_count (투표수)

recoments (대댓글)

  • recomments_id (대댓글아이디) — Primary key — NOT NULL
  • comments_id (댓글아이디) — Foreign key → comments.comments_id — NOT NULL
  • accounts_id (계정아이디) — Foreign key → accounts.accounts_id — NOT NULL
  • recomments_contents (대댓글내용)
  • comments_status (대댓글상태)

recomments_history (대댓글수정내역)

  • count — Primary key — NOT NULL
  • recomments_id (대댓글아이디) — Foreign key → recoments.recomments_id — NOT NULL
  • before_content (그전내용)
  • recomments_history_created_at (대댓글수정일)

recomments_like (대댓글좋아요)

  • accounts_id (계정아이디) — Foreign key → accounts.accounts_id — NOT NULL
  • recomments_id (대댓글아이디) — Foreign key → recoments.recomments_id — NOT NULL