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