1

Tables (3)

member

  • user_id — BIGINT — Primary key
  • nickname — VARCHAR(255)
  • profile_image_url — VARCHAR(255)
  • email — VARCHAR(255)
  • role — VARCHAR(50)
  • status — VARCHAR(50)

movie

  • movie_id — BIGINT — Primary key
  • title — VARCHAR(255)
  • poster_image_url — VARCHAR(255)
  • director_name — TEXT
  • casts_list — TEXT
  • nation — VARCHAR(100)
  • plot — VARCHAR(5000)
  • genre_list — TEXT
  • release_date — VARCHAR(50)
  • status — VARCHAR(50)
  • created_dt — DATETIME
  • updated_dt — DATETIME

movie_preference

  • movie_preference_id — BIGINT — Primary key
  • movie_id — BIGINT
  • member_id — BIGINT
  • liked — VARCHAR(50)
  • created_dt — DATETIME
  • updated_dt — DATETIME