movie

Tables (5)

Copy Of Untitled (User)

  • Key (id) — Integer — Primary key — NOT NULL
  • Field (nickname) — string
  • Field (password) — Date
  • Field (email) — string
  • Field (image) — string
  • Field (userRating) — Integer

Untitled (Movie)

  • Key (id) — Integer — Primary key — NOT NULL
  • Field (title) — string
  • Field (pubDate) — Date
  • Field (country) — string
  • Field (genre) — string
  • Field (userRating) — Integer
  • Field (actor) — string
  • Field (director) — string
  • Field (poster1) — string
  • Field (poster2) — string
  • Field (link) — string
  • Field (runningTime) — Integer

Untitled (Review)

  • Key (id) — Integer — Primary key — NOT NULL
  • Field (title) — string
  • Field2 (content) — string
  • Field3 (created_at) — Date
  • Field4 (updated_at) — Date
  • Key (user_id) — Integer — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (movie_id) — Integer — Foreign key → Untitled.Key — NOT NULL

Untitled (Comment)

  • Key (id) — Primary key — NOT NULL
  • Field (content) — string
  • Field2 (created_at) — Date
  • Key (review_id) — Integer — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — Integer — Foreign key → Copy Of Untitled.Key — NOT NULL

Untitled (Movie_User)

  • Key (movie_id) — Integer — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — Integer — Foreign key → Copy Of Untitled.Key — NOT NULL