REA_MOVIE
Tables (5)
Comment (comment)
- comment_id — int — Primary key — NOT NULL
- content — text
- created_at — datetime
- updated_at — datetime
- community_id — User — Foreign key → Community.community_id — NOT NULL
- user_id — int — Foreign key → User.user_id — NOT NULL
Community (community)
- community_id — User — Primary key — NOT NULL
- title — text
- movie_title — text
- rank — int
- content — text
- created_at — datetime
- updated_at — datetime
- user_id — int — Foreign key → User.user_id — NOT NULL
Movie (movie)
- movie_id — int — Primary key — NOT NULL
- title — text
- overview — text
- poster_path — text
- genre — int
- vote — float
Rating (rating)
- rating_id — int — Primary key — NOT NULL
- rate — float
- movie_id — int — Foreign key → Movie.movie_id — NOT NULL
- user_id — int — Foreign key → User.user_id — NOT NULL
User (user)
- user_id — int — Primary key — NOT NULL
- password (Field2) — password
- Field7