movie_project

Tables (9)

Cast

  • cast (Key) — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → movie_cast.Key — NOT NULL
  • Key2 (Key22) — INT — Foreign key → movie_cast.Key2 — NOT NULL
  • Key3 — INT — Foreign key → movie_cast.Key3 — NOT NULL
  • name (Field) — VARCHAR(50) — NOT NULL
  • path (Field2) — VARCHAR(200)

Followers (CopyOfCopyOfUntitled22)

  • Key — INT — Primary key — NOT NULL
  • Key2 — INT — Primary key — NOT NULL
  • Key3 — INT — Primary key — NOT NULL

Genre

  • genre (Key) — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → movie_genre.Key — NOT NULL
  • Key2 (Key22) — INT — Foreign key → movie_genre.Key2 — NOT NULL
  • Key3 — INT — Foreign key → movie_genre.Key3 — NOT NULL
  • name (Field) — VARCHAR(20)

Like_users (CopyOfUntitled22)

  • Key — INT — Primary key — NOT NULL
  • Key2 — INT — Primary key — NOT NULL
  • Key3 — INT — Primary key — NOT NULL

Movie

  • movie (Key) — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → movie_cast.Key — NOT NULL
  • Key2 (Key22) — INT — Foreign key → movie_cast.Key2 — NOT NULL
  • Key3 — INT — Foreign key → movie_cast.Key3 — NOT NULL
  • Key (Key4) — INT — Foreign key → movie_genre.Key — NOT NULL
  • Key2 (Key23) — INT — Foreign key → movie_genre.Key2 — NOT NULL
  • Key3 (Key32) — INT — Foreign key → movie_genre.Key3 — NOT NULL
  • Key (Key5) — INT — Foreign key → Like_users.Key — NOT NULL
  • Key2 (Key24) — INT — Foreign key → Like_users.Key2 — NOT NULL
  • Key3 (Key33) — INT — Foreign key → Like_users.Key3 — NOT NULL
  • Key (Key6) — INT — Foreign key → Followers.Key — NOT NULL
  • Key2 (Key25) — INT — Foreign key → Followers.Key2 — NOT NULL
  • Key3 (Key34) — INT — Foreign key → Followers.Key3 — NOT NULL
  • title (Field) — VARCHAR(30) — NOT NULL
  • overview (Field2) — TEXT — NOT NULL
  • vote_average (Field3) — INT
  • genre_ids (Field4) — INT
  • poster_path (Field5) — VARCHAR(200)
  • like_users (Field6)
  • trailer (Field7) — VARCHAR(50)
  • cast (Field8)
  • director (Field9) — VARCHAR(30)

Review (CopyOfUntitled2)

  • Key — INT — Primary key — NOT NULL
  • movie (Key2) — INT — Foreign key → Movie.movie — NOT NULL
  • Key (Key22) — INT — Foreign key → Movie.Key — NOT NULL
  • Key2 (Key222) — INT — Foreign key → Movie.Key2 — NOT NULL
  • Key3 — INT — Foreign key → Movie.Key3 — NOT NULL
  • Key (Key4) — INT — Foreign key → Movie.Key — NOT NULL
  • Key2 (Key23) — INT — Foreign key → Movie.Key2 — NOT NULL
  • Key3 (Key32) — INT — Foreign key → Movie.Key3 — NOT NULL
  • genre (Key6) — INT — Foreign key → Genre.genre — NOT NULL
  • Key (Key25) — INT — Foreign key → Genre.Key — NOT NULL
  • Key2 (Key224) — INT — Foreign key → Genre.Key2 — NOT NULL
  • Key3 (Key34) — INT — Foreign key → Genre.Key3 — NOT NULL
  • Key (Key5) — INT — Foreign key → Movie.Key — NOT NULL
  • Key2 (Key24) — INT — Foreign key → Movie.Key2 — NOT NULL
  • Key3 (Key33) — INT — Foreign key → Movie.Key3 — NOT NULL
  • Key (Key62) — INT — Foreign key → Movie.Key — NOT NULL
  • Key2 (Key252) — INT — Foreign key → Movie.Key2 — NOT NULL
  • Key3 (Key342) — INT — Foreign key → Movie.Key3 — NOT NULL
  • content (Field) — VARCHAR(140)
  • score (Field2) — INT

account_user (Untitled2)

  • Key — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → Like_users.Key — NOT NULL
  • Key2 (Key22) — INT — Foreign key → Like_users.Key2 — NOT NULL
  • Key3 — INT — Foreign key → Like_users.Key3 — NOT NULL
  • Key (Key4) — INT — Foreign key → Followers.Key — NOT NULL
  • Key2 (Key23) — INT — Foreign key → Followers.Key2 — NOT NULL
  • Key3 (Key32) — INT — Foreign key → Followers.Key3 — NOT NULL
  • username (Field) — VARCHAR(150)
  • email (Field2) — VARCHAR(150)
  • password (Field3) — VARCHAR(150)
  • is_staff (Field4) — Boolean

movie_cast (Untitled)

  • Key — INT — Primary key — NOT NULL
  • Key2 — INT — Primary key — NOT NULL
  • Key3 — INT — Primary key — NOT NULL

movie_genre (CopyOfUntitled)

  • Key — INT — Primary key — NOT NULL
  • Key2 — INT — Primary key — NOT NULL
  • Key3 — INT — Primary key — NOT NULL