MovieAPI

Tables (4)

Genre (Untitled)

  • id — int — Primary key — NOT NULL
  • name (장르) — char

Movie (Untitled2)

  • id — int — Primary key — NOT NULL
  • genres (장르) — mtom — Foreign key → Genre.id — NOT NULL
  • title (제목) — char
  • year (연도) — char
  • summary (영화소개) — text

Review (Untitled3)

  • id — int — Primary key — NOT NULL
  • movie_id (영화) — foreign — Foreign key → Movie.id — NOT NULL
  • text (리뷰 내용) — text
  • rating (평점) — int

ReviewVote (Untitled4)

  • id — int — Primary key — NOT NULL
  • review_id (리뷰) — foreign — Foreign key → Review.id — NOT NULL