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