movie

Tables (4)

genre (장르)

  • genre_id (장르ID) — BIGINT — Primary key — NOT NULL
  • naem (장르명) — CARCHAR(50)

member (회원)

  • member_id (회원 고유번호) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100)
  • nickname (닉네임) — VARCHAR(50)
  • created_at (가입일) — DATE

movie (영화)

  • movie_id (영화ID) — BIGINT — Primary key — NOT NULL
  • title (영화제목) — VARCHAR(255)
  • release_date (개봉일) — DATE
  • summary (줄거리) — TEXT
  • poster_url (포스터URL) — VARCHAR(2083)
  • rating (평점) — DECIMAL(3,2)

movie_genre (영화_장르)

  • movie_genre_id (매핑고유번호) — BIGINT — Primary key — NOT NULL
  • movie_id (영화ID) — INT — Foreign key → movie.movie_id — NOT NULL
  • genre_id (Key) — Foreign key → genre.genre_id — NOT NULL