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)