Movie Modeling

Tables (6)

Article

  • article_id (id) — number — Primary key — NOT NULL
  • user_id — number — Foreign key → User.user_id — NOT NULL
  • title — varchar(200)
  • content — text
  • create_time (created_at) — date
  • updated_time (updated_at) — date

Comment

  • comment_id (id) — number — Primary key — NOT NULL
  • user_id — number — Foreign key → User.user_id — NOT NULL
  • article_id — number — Foreign key → Article.article_id — NOT NULL
  • content — text
  • create_time (created_at) — date
  • update_time (updated_at) — date

Genre

  • genre_id (id) — number — Primary key — NOT NULL
  • movie_id (movie_genres) — number — Foreign key → Movie.movie_id — NOT NULL
  • name — varchar(100)

Movie

  • movie_id (id) — number — Primary key — NOT NULL
  • genre_id (genres) — number — Foreign key → Genre.genre_id — NOT NULL
  • title — varchar(100)
  • original_title — varchar(100)
  • release_date — date
  • popularity — float
  • vote_count — number
  • vote_average — float
  • adult — boolean
  • overview — text
  • original_language — varchar(100)
  • poster_path — varchar(100)
  • backdrop_path — varchar(100)

Review

  • id — number — Primary key — NOT NULL
  • movie_id — number — Foreign key → Movie.movie_id — NOT NULL
  • user_id — number — Foreign key → User.user_id — NOT NULL
  • score — number
  • content — text

User

  • user_id (id) — number — Primary key — NOT NULL
  • username — varchar(200)
  • email — varchar(200)