Movie

Tables (4)

genre (장르)

  • genre_id (장르ID) — BIGIMT — Primary key
  • name (장르명) — VARCHAR(50)

member (회원)

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

movie (영화)

  • movie_id (영화ID) — BIGINT — Primary key
  • overview (줄거리) — TEXT
  • poster_url (포그터URL) — VARCHAR(1000)
  • title (영화 제목) — VARCHAR(200
  • rating (평점) — DECIMAL(3,1)
  • release_date (개봉일) — DATE

movie_genre (영화_장르)

  • movie_genre_id (매핑고유번호) — BIGINT — Primary key
  • genre_id (장르ID) — BIGIMT — Foreign key → genre.genre_id
  • movie_id (영화ID2) — BIGINT — Foreign key → movie.movie_id