Music

Tables (5)

Album (앨범)

  • album_id (Key) — Bigint — Primary key — NOT NULL
  • artist_id (Key3) — Bigint — Foreign key → Artist.artist_id — NOT NULL
  • genre_id (Key2) — Bigint — Foreign key → Genre.genre_id — NOT NULL
  • album_name (Field) — varchar(30)
  • release_date (Field2) — Date

Artist (아티스트)

  • artist_id (Key) — Bigint — Primary key — NOT NULL
  • artist_name (Field) — varchar(30)

Favorite (즐겨찾기)

  • member_id (Key) — Bigint — Foreign key → Member.member_id — NOT NULL
  • genre_id (Key2) — Bigint — Foreign key → Genre.genre_id — NOT NULL

Genre (장르)

  • genre_id (Key) — Bigint — Primary key — NOT NULL
  • genre_name (Field) — varchar(30)

Member (회원)

  • member_id (Key) — Bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • email (Field2) — varchar(40)
  • phone (Field3) — varchar(30)
  • password (Field4) — varchar(30)