Movie Modeling
Tables (6)
Article
- article_id (id) — number — Primary key — NOT NULL
- user_id — number — Foreign key → User.user_id — NOT NULL
- title — varchar(200)
- content — text
- create_time (created_at) — date
- updated_time (updated_at) — date
Comment
- comment_id (id) — number — Primary key — NOT NULL
- user_id — number — Foreign key → User.user_id — NOT NULL
- article_id — number — Foreign key → Article.article_id — NOT NULL
- content — text
- create_time (created_at) — date
- update_time (updated_at) — date
Genre
- genre_id (id) — number — Primary key — NOT NULL
- movie_id (movie_genres) — number — Foreign key → Movie.movie_id — NOT NULL
- name — varchar(100)
Movie
- movie_id (id) — number — Primary key — NOT NULL
- genre_id (genres) — number — Foreign key → Genre.genre_id — NOT NULL
- title — varchar(100)
- original_title — varchar(100)
- release_date — date
- popularity — float
- vote_count — number
- vote_average — float
- adult — boolean
- overview — text
- original_language — varchar(100)
- poster_path — varchar(100)
- backdrop_path — varchar(100)
Review
- id — number — Primary key — NOT NULL
- movie_id — number — Foreign key → Movie.movie_id — NOT NULL
- user_id — number — Foreign key → User.user_id — NOT NULL
- score — number
- content — text
User
- user_id (id) — number — Primary key — NOT NULL
- username — varchar(200)
- email — varchar(200)