new android kill
Tables (7)
MOVIE (영화)
- movie_id (영화id) — text — Primary key
- post (포스트) — url
- original_title (영화원제)
- title (영화이름) — text — NOT NULL
- summary (줄거리) — text
- grade (평점) — integer
- director (감독) — text
- release_date (오픈일) — text
- reg_date (등록일자) — text — NOT NULL
- genre_id (장르id) — Foreign key → genre.genre_id — NOT NULL
- post (포스터)
- tmdb_id (tmdb상 영화 id)
REVIEW (리뷰)
- review_id (리뷰id) — text — Primary key — NOT NULL
- title (제목) — text
- content (내용) — blob
- grade (별점) — integer
- reg_date (작성일자) — text
- user_id (사용자id) — text — Foreign key → USER.user_id — NOT NULL
- movie_id (영화id) — text — Foreign key → MOVIE.movie_id — NOT NULL
USER (사용자)
- user_id (사용자 id) — text — Primary key — NOT NULL
- email (이메일) — text
- password (비밀번호) — text
- nickName (닉네임) — text
- reg_date (가입일자) — text
genre (장르)
- genre_id (장르id) — Primary key — NOT NULL
- genre_name (장르명)
history (접속기록)
- history_id (히스토리id) — text — Primary key — NOT NULL
- reg_date (등록일자) — text
- review_id (리뷰id) — text — Foreign key → REVIEW.review_id — NOT NULL
movie_like (영화 좋아요)
- user_id (사용자 id) — text — Foreign key → USER.user_id — NOT NULL
- movie_id (영화id) — text — Foreign key → MOVIE.movie_id — NOT NULL
- reg_date (생성일자) — text
- status (상태) — text
review_like (리뷰 좋아요)
- user_id (사용자 id) — text — Foreign key → USER.user_id — NOT NULL
- review_id (리뷰id) — text — Foreign key → REVIEW.review_id — NOT NULL
- reg_date (생성일자) — text
- status (상태) — text