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