MovieVibe

Tables (5)

Genre

  • (genre_id) — int(1) — Primary key — NOT NULL
  • (name) — Char

Movie

  • (movie_id) — int(1) — Primary key — NOT NULL
  • (genre_id) — int(1) — Foreign key → Genre.genre_id — NOT NULL
  • (title) — Char
  • Field2 (original_title) — Char
  • Field3 (release_date) — Date
  • Field4 (popularity) — Float
  • Field5 (vote_count) — Integer
  • Field6 (vote_average) — Float
  • Field7 (adult) — Boolean
  • Field8 (overview) — Text
  • Field9 (original_language) — Char
  • Field10 (poster_path) — Char
  • Field (backdrop_path) — Char

Untitled (User)

  • Key (user_id) — int(1) — Primary key — NOT NULL
  • Field (username) — Char
  • Field (password) — Char
  • Field (profile_image) — Char
  • Field (introduction) — Char
  • Field

Untitled3 (Review)

  • Key (review_id) — int(1) — Primary key — NOT NULL
  • (movie_id) — int(1) — Foreign key → Movie.movie_id — NOT NULL
  • (genre_id) — int(1) — Foreign key → Movie.genre_id — NOT NULL
  • Field (movie)
  • Field (user)
  • Field (title) — Char
  • Field (content) — Text
  • Field (rank) — Integer
  • Field (spoiler) — Boolean
  • Field (created_at) — Date
  • Field (updated_at) — Date

Untitled3 (Comment)

  • Key (comment_id) — int(1) — Primary key — NOT NULL
  • Field (review)
  • Field (user)
  • Field (content) — Char
  • Field (created_at) — Date
  • Field (updated_at) — Date