REA_MOVIE

Tables (5)

Comment (comment)

  • comment_id — int — Primary key — NOT NULL
  • content — text
  • created_at — datetime
  • updated_at — datetime
  • community_id — User — Foreign key → Community.community_id — NOT NULL
  • user_id — int — Foreign key → User.user_id — NOT NULL

Community (community)

  • community_id — User — Primary key — NOT NULL
  • title — text
  • movie_title — text
  • rank — int
  • content — text
  • created_at — datetime
  • updated_at — datetime
  • user_id — int — Foreign key → User.user_id — NOT NULL

Movie (movie)

  • movie_id — int — Primary key — NOT NULL
  • title — text
  • overview — text
  • poster_path — text
  • genre — int
  • vote — float

Rating (rating)

  • rating_id — int — Primary key — NOT NULL
  • rate — float
  • movie_id — int — Foreign key → Movie.movie_id — NOT NULL
  • user_id — int — Foreign key → User.user_id — NOT NULL

User (user)

  • user_id — int — Primary key — NOT NULL
  • password (Field2) — password
  • Field7