MOVIE
Tables (14)
comment_hate_users
- user_id — integer — Foreign key → user.id — NOT NULL
- comment_id — integer — Foreign key → community_comment.id — NOT NULL
comment_like_users
- comment_id — integer — Foreign key → community_comment.id — NOT NULL
- user_id — integer — Foreign key → user.id — NOT NULL
community_comment
- id — integer — Primary key — NOT NULL
- review_id — integer — Foreign key → community_review.id — NOT NULL
- user_id — integer — Foreign key → user.id — NOT NULL
- content — text
community_review
- id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → user.id — NOT NULL
- title — varchar(100)
- movie_title — varchar(50)
- rank — integer
- content — text
- created_at — datetime
- updated_time — datetime
favorite_movie
- movie_id — integer — Foreign key → movie.id — NOT NULL
- user_id — integer — Foreign key → user.id — NOT NULL
genre
- id — integer — Primary key — NOT NULL
- name — varchar(50)
movie
- id — integer — Primary key — NOT NULL
- title — varchar(100)
- release_date — date
- overview — text
- poster_path — varchar(200)
- popularity — real
- vote_average — real
- vote_count — integer
movie_genre
- movie_id — integer — Foreign key → movie.id — NOT NULL
- genre_id — integer — Foreign key → genre.id — NOT NULL
movie_hate_users
- movie_id — integer — Foreign key → movie.id — NOT NULL
- user_id — integer — Foreign key → user.id — NOT NULL
movie_like_users
- movie_id — integer — Foreign key → movie.id — NOT NULL
- user_id — integer — Foreign key → user.id — NOT NULL
review_hate_users
- user_id — integer — Foreign key → user.id — NOT NULL
- review_id — integer — Foreign key → community_review.user_id — NOT NULL
review_like_users
- review_id — integer — Foreign key → community_review.id — NOT NULL
- user_id — integer — Foreign key → user.id — NOT NULL
user
- id — integer — Primary key — NOT NULL
- username — varchar(150)
- password — varchar(128)
- email — varchar(254)
user_followers
- id — integer — Primary key — NOT NULL
- followers — integer — Foreign key → user.id — NOT NULL