model
Tables (4)
comment (movies_comment)
- PK (id) — INT — Primary key — NOT NULL
- FK (movie_id) — INT — Primary key — NOT NULL
- FK (user_id) — INT — Primary key — NOT NULL
- (comment) — 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
- FK (genre_id) — INT — Foreign key → movie_genre_id.FK — NOT NULL
- (title) — VARCHAR(150)
- (poster_url) — VARCHAR(150)
- (summery) — VARCHAR(150)
- (audience) — INT
- (director) — VARCHAR(150)
- (start_data) — VARCHAR(150)
- (teaser) — VARCHAR(150)
movie_genre_id (movies_movie_genre_id)
- PK (id) — INT — Primary key — NOT NULL
- FK (genre_id) — INT — Primary key — NOT NULL
- Key (id2) — INT — Foreign key → genre.Key — NOT NULL