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