minyeonghwa
Tables (9)
Account (User)
- user_id (Key) — Primary key — NOT NULL
- user_name (Field)
- user_password (Field2)
Account (User_Movie)
- id (Key3) — Primary key — NOT NULL
- user_id (Key) — Foreign key → Account.user_id — NOT NULL
- movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL
- rank (Field)
Account (User_Review_like)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → Account.user_id — NOT NULL
- review_id (Key3) — Foreign key → Community.review_id — NOT NULL
Account (User_Comment_like)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → Account.user_id — NOT NULL
- comment_id (Key3) — Foreign key → Community.comment_id — NOT NULL
Community (Review)
- review_id (Key) — Primary key — NOT NULL
- movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL
- user_id (Key3) — Foreign key → Account.user_id — NOT NULL
- review_title (Field)
- review_content (Field2)
- review_created (Field3)
- review_updated (Field4)
- review_rank (Field5)
Community (Comment)
- comment_id (Key) — Primary key — NOT NULL
- review_id (Key2) — Foreign key → Community.review_id — NOT NULL
- user_id (Key4) — Foreign key → Account.user_id — NOT NULL
- comment_content (Field)
- comment_created (Field2)
- comment_updated (Field3)
Movie (Genre)
- genre_id (Key) — Primary key — NOT NULL
- genre_name (Field)
Movie
- movie_id (Key) — Primary key — NOT NULL
- movie_title (Field)
- movie_original_title (Field6)
- movie_overview (Field2)
- movie_revenue (Field7)
- movie_popularity (Field5)
- movie_poster_path (Field3)
- movie_backdrop_path (Field8)
- movie_vote_average (Field4)
- movie_release_date (Field9)
Movie (Movie_Genre)
- id (Key) — Primary key — NOT NULL
- movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL
- genre_id (Key3) — Foreign key → Movie.genre_id — NOT NULL