PDD

Tables (8)

Copy Of Untitled (Director)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(100)
  • Field3 (popularity) — double
  • Field4 (profile_path) — text

Untitled (Actor)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(100)
  • Field3 (popularity) — double
  • Field4 (profile_path) — text

Untitled (Genres)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(100)

Untitled (Movie)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (adult) — boolean
  • Field2 (title) — varchar(100)
  • Field3 (tagline) — text
  • Field4 (overview) — text
  • Field5 (poster_path) — varchar(200)
  • Field6 (backdrop_path) — varchar(200)
  • Field7 (popularity) — double
  • Field8 (release_date) — datetime
  • Field9 (runtime) — int
  • Field10 (vote_average) — double
  • Field11 (trailer_youtube_key) — text
  • Field12 (movie_similar) — text
  • Field13 (GENRE)
  • Field14 (Director)
  • Field15 (ACTOR)

Untitled (Characters)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (actor_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (movie_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (character_name) — varchar(100)

Untitled (Rating)

  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (movie_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (rate) — int
  • Field2 (comment) — text
  • Field3 (spoiler) — boolean
  • Field4 (created_at) — datetime
  • Field5 (updated_at) — datetime
  • Field6 (LIKE_USERS)

Untitled (User)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (profile_image) — text
  • Field (username) — varchar(150)
  • Field (first_name) — varchar(150)
  • Field (last_name) — varchar(150)
  • Field (email) — varchar(254)
  • Field (is_staff) — boolean
  • Field (is_active) — boolean
  • Field (is_superuser) — boolean
  • Field (date_joined) — datetime
  • Field (last_login) — datetime

Untitled (Movies_director)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (director_id) — bigint — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (movie_id) — bigint — Foreign key → Untitled.Key — NOT NULL