5jodda

Tables (5)

Genre

  • Key (id) — Integer — Primary key — NOT NULL
  • name — VARCHAR(20)

Movie

  • id — Integer — Primary key — NOT NULL
  • title — VARCHAR(30)
  • audience — Integer
  • poster_url — VARCHAR(140)
  • description — Text

Untitled (Movie-Genre)

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

Untitled (User)

  • Key (id) — Integer — Primary key — NOT NULL
  • Field (username) — VARCHAR(150)
  • Field (password) — VARCHAR(128)
  • Field (email) — VARCHAR

Untitled (Review)

  • Key (user_id) — Integer — Foreign key → Untitled.Key — NOT NULL
  • id (movie_id) — Integer — Foreign key → Movie.id — NOT NULL
  • Field (content) — VARCHAR(140)
  • Field (score) — Float