KKK-Triple-K
Tables (8)
actor (movies_actor)
- Key (id) — INT — Primary key — NOT NULL
- PK (movie_id) — INT — Foreign key → movie.PK — NOT NULL
- (name) — VARCHAR(100)
- (character) — VARCHAR(50)
- (profile_photo) — TEXT
comment (movies_comment)
- PK (id) — INT — Primary key — NOT NULL
- FK (movie_id) — INT — Foreign key → movie.PK — NOT NULL
- FK (user_id) — INT — Foreign key → user.PK — NOT NULL
- (content) — VARCHAR(150)
- (score) — INT
genre (movies_genre)
- Key (id) — INT — Primary key — NOT NULL
- (name) — VARCHAR(150)
movie (movies_movie)
- PK (id) — INT — Primary key — NOT NULL
- (name) — VARCHAR(150)
- (poster_url) — VARCHAR(1000)
- (description) — TEXT
- (audience_rating) — VARCHAR(100)
- (audience) — INT
- (release_date) — VARCHAR(50)
movie_genre_id (movies_movie_genre_id)
- PK (id) — INT — Primary key — NOT NULL
- FK (genre_id) — INT — Foreign key → movie.PK — NOT NULL
- FK (id2) — INT — Foreign key → genre.Key — NOT NULL
movie_like_users (movies_movie_like_users)
- PK (id) — INT — Primary key — NOT NULL
- FK (movie_id) — INT — Foreign key → movie.PK — NOT NULL
- FK (user_id) — INT — Foreign key → user.PK — NOT NULL
user (accounts_user)
- PK (id) — INT — Primary key — NOT NULL
- (email) — VARCHAR(150)
- (first_name) — VARCHAR(150)
- (last_name) — VARCHAR(150)
- (sex) — CHOICE
- (age) — INT
- (password) — VARCHAR(128)
user_followers (accounts_user_followers)
- PK (id) — INT — Primary key — NOT NULL
- FK (from_user_id) — INT — Foreign key → user.PK — NOT NULL
- FK (to_user_id) — INT — Foreign key → user.PK — NOT NULL