Movie_Bigdata

Tables (5)

Genre (Untitled2)

  • pk — integer — Primary key — NOT NULL
  • name — string

Movie (Untitled)

  • pk — integer — Primary key — NOT NULL
  • genre — object — Foreign key → Genre.pk — NOT NULL
  • keyword (keyoword) — string
  • actora (actor) — string
  • director — string
  • budget — float
  • overview — text
  • popularity — float
  • poster_path — text
  • release_date — string
  • revenue — float
  • runtime — float
  • spoken_language — string
  • tagline — text
  • title — string
  • vote_average — float
  • vote_count — integer

MovieScore (Untitled4)

  • pk — integer — Primary key — NOT NULL
  • name — string
  • score — float

Review (Untitled5)

  • pk — integer — Primary key — NOT NULL
  • user — user — Foreign key → User.pk — NOT NULL
  • movie — movie — Foreign key → Movie.pk — NOT NULL
  • title — string
  • body — text

User (Untitled3)

  • pk — integer — Primary key — NOT NULL
  • movie_score — object — Foreign key → MovieScore.pk — NOT NULL
  • email — string
  • nickname — string
  • is_active — boolean
  • is_admin — boolean
  • is_superuser — boolean
  • is_staff — boolean
  • date_joined — datetime
  • Field