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