기말과제

테이블 (4)

Album (Untitled3)

  • albumID (Key) — int(30) — 기본 키 — NOT NULL
  • albumTitle (Field) — char(45)
  • genre (Field2) — text
  • registedDate (Field3) — date
  • albumScore (Field4) — char(5)

Album_Artist (Untitled4)

  • participatingTrack (Key) — char(45) — 기본 키 — NOT NULL
  • albumID (Key2) — int(30) — 외래 키 → Album.albumID — NOT NULL
  • artistID (Key3) — int(10) — 외래 키 → Artist.artistID — NOT NULL

Artist (Untitled)

  • artistID (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • gender (Field2) — char(1)
  • age (Field3) — int(3)
  • country (Field4) — char(45)

Track (Untitled2)

  • trackID (Key) — int(30) — 기본 키 — NOT NULL
  • trackTitle (Field) — char(45)
  • registedDate (Field3) — date
  • genre (Field4) — text
  • playtime (Field5) — time
  • albumID (Key2) — int(30) — 외래 키 → Album.albumID — NOT NULL