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