moobeer

Tables (5)

accounts (User)

  • id — INTEGER — Primary key — NOT NULL
  • username — CHAR
  • password — PASSWORD

genre (Genre)

  • id — INTEGER — Primary key — NOT NULL
  • movie_id — INTEGER — Foreign key → movie.id — NOT NULL
  • name — TEXT

movie (Movie)

  • id — INTEGER — Primary key — NOT NULL
  • title — CHAR
  • original_title (original title) — CHAR
  • release_date (release date) — DATETIME
  • popularity — INTEGER
  • vote_count (vote count) — INTEGER
  • vote_average (vote average) — FLOAT
  • adult — BOOLEAN
  • overview — CHAR
  • original_language (original language) — CHAR
  • poster_path (poster path) — CHAR
  • backdrop_path (backdrop path) — CHAR

review (Review)

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → accounts.id — NOT NULL
  • movie_id — INTEGER — Foreign key → movie.id — NOT NULL
  • like_users (like users) — INTEGER
  • score — INTEGER
  • content — CHAR
  • created_at (created at) — DATETIME
  • updated_at (updated at) — DATETIME
  • user_id (user id) — INTEGER
  • movie_id (movie id) — INTEGER

user-like

  • user_id — INTEGER — Foreign key → accounts.id — NOT NULL
  • review_id — INTEGER — Foreign key → review.id — NOT NULL