movie 3안(시청여부삭제)

테이블 (3)

Member

  • user_id — INT — 기본 키
  • username — VARCHAR(100) — NOT NULL
  • role — VARCHAR(50)
  • created_at — TIMESTAMP
  • last_login — TIMESTAMP
  • email — VARCHAR(255)

Movie

  • movie_id — INT — 기본 키
  • title — VARCHAR(255) — NOT NULL
  • genre — VARCHAR(100)
  • release_date — DATE
  • director — VARCHAR(255)
  • duration — INT

Review

  • review_id — INT — 기본 키
  • movie_id — INT — 외래 키 → Movie.movie_id
  • user_id — INT — 외래 키 → Member.user_id
  • rating — DECIMAL(2, 1)
  • comment — TEXT — EX
  • review_date — TIMESTAMP