adsf

Tables (9)

BoxOffice (Untitled3)

  • rank (랭킹) — string — Primary key — NOT NULL
  • movieNm (영화명(국문)) — string
  • openDt (개봉일) — string
  • audiAcc (누적관객수) — string

Movie (Untitled2)

  • movieCd (영화코드) — string — Primary key
  • movieNm (영화명(국문)) — string
  • movieNmEn (영화명(영문)) — string
  • showTm (상영시간) — string
  • openDt (개봉연도) — string
  • genreNm (장르명) — string
  • directors (감독명) — string
  • actors (배우명) — string
  • watchGradeNm (관람등급) — string
  • Movie_wish_id (Key) — Foreign key → Movie_wish.id — NOT NULL
  • Movie_like_id (Key2) — Foreign key → Movie_like.id — NOT NULL
  • Movie_dislike_id (Key3) — Foreign key → Movie_dislike.id — NOT NULL
  • Poster_path (Field)

Movie_dislike (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — integer — Foreign key → User.user_id — NOT NULL
  • movieCd (Field)
  • movieCd (영화코드) — string — Foreign key → Movie.movieCd

Movie_like (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — integer — Foreign key → User.user_id — NOT NULL
  • movieCd (Field)
  • movieCd (영화코드) — string — Foreign key → Movie.movieCd

Movie_wish (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — integer — Foreign key → User.user_id — NOT NULL
  • movieCd (영화코드) — string — Foreign key → Movie.movieCd

User (Untitled)

  • user_id (Key) — integer — Primary key — NOT NULL
  • username (아이디) — string
  • password (비밀번호) — string
  • first_name (이름) — string
  • last_name (성) — string
  • email (이메일) — string

community_comment (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — integer — Foreign key → User.user_id — NOT NULL
  • content (Key3) — Foreign key → community_review.id — NOT NULL
  • review_id (Field)

community_review (리뷰)

  • id (Key) — integer — Primary key — NOT NULL
  • user_id (Key2) — integer — Foreign key → User.user_id — NOT NULL
  • title (Field)
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • movie_title (Field5)

short_comment (한줄평)

  • id (Key) — integer — Primary key — NOT NULL
  • movieCd (영화코드) — string — Foreign key → Movie.movieCd
  • user_id (유저) — integer — Foreign key → User.user_id — NOT NULL
  • content (한줄평) — string
  • star (평점) — integer