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