red

Tables (5)

genres (Untitled2)

  • Key — integer — Primary key — NOT NULL
  • Field — char

genres_movie (Untitled4)

  • Key — integer — Primary key — NOT NULL
  • Key (Key2) — integer — Foreign key → movie.Key — NOT NULL
  • Key (Key3) — integer — Foreign key → genres.Key — NOT NULL

movie (Untitled)

  • Key — integer — Primary key — NOT NULL
  • Field — integer
  • Field2 — date
  • Field3 — integer
  • Field4 — integer
  • Field5 — float
  • Field6 — text
  • Field7 — char
  • Field8

review (Untitled5)

  • Key — integer — Primary key — NOT NULL
  • Key (Key2) — foregin_key — Foreign key → user.Key — NOT NULL
  • Key (Key3) — foregin_key — Foreign key → movie.Key — NOT NULL
  • Field — char
  • Field2 — comments
  • Field3 — integer
  • Field4 — date
  • Field5 — date
  • Field6

user (Untitled6)

  • Key — integer — Primary key — NOT NULL
  • Field