영화리뷰사이트
테이블 (9)
Genres (Untitled7)
- genres id (Key) — 기본 키 — NOT NULL
- genre (Field)
Like(Review-User) (Untitled9)
- review id (id) — 외래 키 → Review.review id — NOT NULL
- movie id (2) — 외래 키 → Review.movie id — NOT NULL
- user id (Key2) — 외래 키 → Review.user id — NOT NULL
- user id (id2) — 외래 키 → User.user id — NOT NULL
Movie (Untitled)
- movie id — 기본 키 — NOT NULL
- title
- release date
- popularity
- vote count
- overview
- poster path
- upcoming
Movie Comment (Untitled4)
- movie comment id (Key) — 기본 키 — NOT NULL
- movie id — 외래 키 → Movie.movie id — NOT NULL
- user id (Key2) — 외래 키 → User.user id — NOT NULL
- content (Field)
- rank (Field2)
- created_at (Field3)
- updated_at (Field4)
Movie-Genres (Untitled8)
- genres id (Key) — 외래 키 → Genres.genres id — NOT NULL
- movie id (2) — 외래 키 → Movie.movie id — NOT NULL
PlayList (Untitled6)
- movie id — 외래 키 → Movie.movie id — NOT NULL
- user id — 외래 키 → User.user id — NOT NULL
Review (Untitled2)
- review id (id) — 기본 키 — NOT NULL
- movie id (2) — 외래 키 → Movie.movie id — NOT NULL
- user id (Key2) — 외래 키 → User.user id — NOT NULL
- title (Field)
- content (Field2)
- rank (Field3)
- created_at (Field4)
- updated_at (Field5)
Review Comment (Untitled3)
- user id (Key3) — 외래 키 → User.user id — NOT NULL
- review id (id) — 외래 키 → Review.review id — NOT NULL
- movie id (2) — 외래 키 → Review.movie id — NOT NULL
- user id (Key2) — 외래 키 → Review.user id — NOT NULL
- content (Field)
- created_at (Field2)
- updated_at (Field3)
User (Untitled5)
- user id (id) — 기본 키 — NOT NULL
- user name (username)
- email
- password