영화리뷰사이트

테이블 (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