19팀

테이블 (5)

MOVIE_REVIEW_Table (Untitled4)

  • index (Key) — NOT NULL — 기본 키 — NOT NULL
  • user_index (Key2) — NOT NULL — 외래 키 → USER_Table.index — NOT NULL
  • movie_index (Key3) — NOT NULL — 외래 키 → MOVIE_Table.index — NOT NULL
  • score (Field) — NULL
  • comment (Field2) — NULL

MOVIE_Table (Untitled2)

  • index (Key) — NOT NULL — 기본 키 — NOT NULL
  • title (Field) — NOT NULL
  • genre (Field2) — NULL
  • plot (Field3) — NULL
  • publish_year (Field4) — NULL
  • poster_url (Field5) — NULL
  • imdb_score (Field6) — default=0
  • naver_user_score (Field7) — default=0
  • naver_user_count (Field8) — default=0
  • naver_expert_score (Field9) — default=0
  • naver_expert_count (Field10) — default=0

USER_REVIEW_Table (Untitled5)

  • index (Key3) — NOT NULL — 기본 키 — NOT NULL
  • reviewed_index (Key2) — NOT NULL — 기본 키 — NOT NULL
  • reviewer_index (Key) — NOT NULL — 외래 키 → USER_Table.index — NOT NULL

USER_Table (Untitled)

  • index (Key) — NOT NULL — 기본 키 — NOT NULL
  • id (Field2) — NOT NULL
  • name (Field) — NOT NULL
  • password (Field3) — NOT NULL
  • profile_image (Field4) — default="프로필없는이미지"
  • temperature (Field5) — default = 0
  • review_num (Field6) — default = 0
  • social (Field7) — default= "local"

WANT_WATCH_Table (Untitled3)

  • index (Key3) — NOT NULL — 기본 키 — NOT NULL
  • user_index (Key) — NOT NULL — 외래 키 → USER_Table.index — NOT NULL
  • movie_index (Key2) — NOT NULL — 외래 키 → MOVIE_Table.index — NOT NULL