MOVIE

Tables (14)

comment_hate_users

  • user_id — integer — Foreign key → user.id — NOT NULL
  • comment_id — integer — Foreign key → community_comment.id — NOT NULL

comment_like_users

  • comment_id — integer — Foreign key → community_comment.id — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL

community_comment

  • id — integer — Primary key — NOT NULL
  • review_id — integer — Foreign key → community_review.id — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL
  • content — text

community_review

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL
  • title — varchar(100)
  • movie_title — varchar(50)
  • rank — integer
  • content — text
  • created_at — datetime
  • updated_time — datetime

favorite_movie

  • movie_id — integer — Foreign key → movie.id — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL

genre

  • id — integer — Primary key — NOT NULL
  • name — varchar(50)

movie

  • id — integer — Primary key — NOT NULL
  • title — varchar(100)
  • release_date — date
  • overview — text
  • poster_path — varchar(200)
  • popularity — real
  • vote_average — real
  • vote_count — integer

movie_genre

  • movie_id — integer — Foreign key → movie.id — NOT NULL
  • genre_id — integer — Foreign key → genre.id — NOT NULL

movie_hate_users

  • movie_id — integer — Foreign key → movie.id — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL

movie_like_users

  • movie_id — integer — Foreign key → movie.id — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL

review_hate_users

  • user_id — integer — Foreign key → user.id — NOT NULL
  • review_id — integer — Foreign key → community_review.user_id — NOT NULL

review_like_users

  • review_id — integer — Foreign key → community_review.id — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL

user

  • id — integer — Primary key — NOT NULL
  • username — varchar(150)
  • password — varchar(128)
  • email — varchar(254)

user_followers

  • id — integer — Primary key — NOT NULL
  • followers — integer — Foreign key → user.id — NOT NULL