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