movie 4안(장르테이블추가)

테이블 (5)

Genre

  • genre_id — INT — 기본 키
  • genre_name — VARCHAR(100) — NOT NULL

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
  • release_date — DATE
  • director — VARCHAR(255)
  • duration — INT

Movie_Genre

  • movie_genre_id — INT — 기본 키
  • movie_id — INT — 외래 키 → Movie.movie_id
  • genre_id — INT — 외래 키 → Genre.genre_id

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