final

Tables (9)

Comment (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • review_id (Key3) — Foreign key → Review.id — NOT NULL
  • user_id (Key2) — Foreign key → User.ID — NOT NULL
  • content (Field)
  • created_at (Field2)
  • updated_at (Field3)

Genre (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • tmdb_id (Field2)

Like-Movie (Untitled7)

  • ID (Key) — Foreign key → User.ID — NOT NULL
  • id (Key2) — Foreign key → Movie.id — NOT NULL

Movie (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • release_date (Field2)
  • overview (Field3)
  • tmdb_id (Field4)
  • original_language (Field5)
  • poster_path (Field6)
  • backdrop_path (Field7)
  • runtime (Field8)
  • tagline (Field9)
  • vote_average (Field10)
  • rate_average (Field11)

Movie-Genre (Untitled4)

  • movie_id (Key) — Foreign key → Movie.id — NOT NULL
  • genre_id (Key2) — Foreign key → Genre.id — NOT NULL

Profile (Untitled8)

  • ID (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → User.ID — NOT NULL
  • profile_message (Field)
  • favorite_genre1 (Field2)
  • favorite_genre2 (Field3)
  • favorite_genre3 (Field4)

Review (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.ID — NOT NULL
  • movie_id (Key3) — Foreign key → Movie.id — NOT NULL
  • content (Field3)
  • title (Field4)
  • rate (Field)
  • created_at (Field2)
  • updated_at (Field5)

Review_Like (Untitled9)

  • user_id (Key) — Foreign key → User.ID — NOT NULL
  • review_id (Key3) — Foreign key → Review.id — NOT NULL

User (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • username (Char)
  • nickname (Field2)
  • password (Field)