Movie Recommend
Tables (17)
Article (article)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- title (Field)
- content (Field2)
- created_at (Field3)
- updated_at (Field4)
- img_path (Field5)
Article_Comment (article_comment)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- article_id (Key3) — Foreign key → Article.id — NOT NULL
- comment (Field)
Article_Like (article_like)
- id (Key) — Primary key — NOT NULL
- article_id (Key2) — Foreign key → Article.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
Followed_Following (followed_following)
- Key — Primary key — NOT NULL
- follower_id (Key2) — Foreign key → User.id — NOT NULL
- following_id (Key3) — Foreign key → User.id — NOT NULL
Genre (genre)
- id (Key) — Primary key — NOT NULL
- name (Field)
- name_kr (Field2)
Keyword (Untitled)
- id (Key) — Primary key — NOT NULL
- name (Field)
Movie (movie)
- id (Key) — Primary key — NOT NULL
- adult (Field)
- backdrop_path (Field2)
- budget (Field3)
- imdb_id (Field4)
- origin_country (Field5)
- original_language (Field6)
- original_title (Field7)
- overview (Field8)
- popularity (Field9)
- poster_path (Field10)
- release_date (Field11)
- revenue (Field12)
- runtime (Field13)
- status (Field14)
- tagline (Field15)
- title (Field16)
- video (Field17)
- vote_average (Field18)
- vote_count (Field19)
- detail_count (Field20)
- name_kr (Field21)
- overview_kr (Field22)
Movie_Genre (movie_genre)
- id (Key) — Primary key — NOT NULL
- movie_id (Key2) — Foreign key → Movie.id — NOT NULL
- genre_id (Key3) — Foreign key → Genre.id — NOT NULL
Movie_Keyword (movie_keyword)
- id (Key) — Primary key — NOT NULL
- movie_id (Key2) — Foreign key → Movie.id — NOT NULL
- keword_id (Key3) — Foreign key → Keyword.id — NOT NULL
Movie_Like (movie_like)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- movie_id (Key3) — Foreign key → Movie.id — NOT NULL
People (people)
- id (Key) — Primary key — NOT NULL
- adult (Field)
- biography (Field2)
- birthday (Field3)
- deathday (Field4)
- gender (Field5)
- imdb_id (Field7)
- known_for_department (Field6)
- name (Field8)
- place_of_birth (Field9)
- popularity (Field10)
- profile_path (Field11)
People_Like (people_like)
- Key — Primary key — NOT NULL
- people_id (Key2) — Foreign key → People.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
People_Movie (people_movie)
- id (Key) — Primary key — NOT NULL
- id (people_id) — Foreign key → People.id — NOT NULL
- id (movie_id) — Foreign key → Movie.id — NOT NULL
Review (review)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- movie_id (Key3) — Foreign key → Movie.id — NOT NULL
- content (Field2)
- create_at (Field3)
- updated_at (Field4)
- rating (Field5)
Review_Like (review_like)
- id (Key) — Primary key — NOT NULL
- review_id (Key2) — Foreign key → Review.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
User (user)
- id (Key) — Primary key — NOT NULL
- nickname (Field)
- gender (Field2)
- age (Field3)
- mbti (Field4)
- view_count (Field5)
- profile_path (Field6)
- profile_view_count (Field7)
UserGenre (usergenre)
- Key — Primary key — NOT NULL
- id (Key2) — Foreign key → User.id — NOT NULL
- id (Key3) — Foreign key → Genre.id — NOT NULL
- user_id (Field)
- genre_id (Field2)