AwsMovie
Tables (3)
MOVIE
- 영화ID (MOVIE_ID) — BIGINT — Primary key — NOT NULL — Auto Increament
- 제목 (TITLE) — VARCHAR(50) — NOT NULL
- 줄거리 (CONTENTS) — TEXT — NOT NULL
- 개봉일 (OPEN_DATE) — DATETIME — NOT NULL
- 감독 (DIRECTOR) — VARCHAR(20) — NOT NULL
- 리뷰ID (REVIEW_ID) — INT — NOT NULL
- 제작일 (MAKE_DATE) — DATETIME — NOT NULL
- 제작국가 (COUNTRY) — VARCHAR(50)
- 창성일자 (CREATED_DATE) — DATETIME — NOT NULL
- 수정일자 (MODIFIED_DATE) — DATETIME — NOT NULL
REVIEW
- 리뷰ID (REVIEW_ID) — BIGINT — Primary key — NOT NULL — Auto Increament
- 영화ID (MOVIE_ID) — BIGINT — Foreign key → MOVIE.영화ID — NOT NULL
- USER ID (USER_ID) — BIGINT — Foreign key → USER.USER ID
- 리뷰내용 (REVIEW_CONTENTS) — TEXT — NOT NULL
- 평점 (SCORE) — INT — NOT NULL
- 창성일자 (CREATED_DATE) — DATETIME — NOT NULL
- 수정일자 (MODIFIED_DATE) — DATETIME — NOT NULL
USER
- USER ID (USER_ID) — BIGINT — Primary key — Auto Increment
- 이름 (USER_NAME) — VARCHAR(50) — NOT NULL
- EMAIL — VARCHAR(50)
- PICTURE — VARCHAR(200) — NOT NULL
- 창성일자 (CREATED_DATE) — DATETIME — NOT NULL
- 수정일자 (MODIFIED_DATE) — DATETIME — NOT NULL