mapbackend_ERD

Tables (4)

genre (Untitled)

  • id — INT — Primary key — NOT NULL
  • 장르이름 (name) — VARCHAR(50)

member

  • id — INT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR(255)
  • 닉네임 (name) — VARCHAR(255)
  • 가입일 (join_date) — DATETIME

movie

  • id — INT — Primary key — NOT NULL
  • 제목 (title) — VARCHAR(255)
  • 개봉일 (release_year) — INT
  • 줄거리 (summary) — DATE
  • 포스터 URL (poster_url) — VARCHAR(255)
  • 평점 (rating) — DOUBLE

movie_genre (Untitled2)

  • id (movie_id) — INT — Foreign key → movie.id — NOT NULL
  • id (genre_id) — INT — Foreign key → genre.id — NOT NULL