기말과제

테이블 (6)

album (Untitled4)

  • albumID (Key) — int(15) — 기본 키 — NOT NULL
  • albumName (Field) — char(70)
  • publishYear (Field2) — int(10)
  • publisher (Field3) — char(30)

composer (Untitled)

  • composerID (Key) — int(15) — 기본 키 — NOT NULL
  • composerName (Field3) — char(50)
  • alternativeName (Field2) — char(50)
  • nationality (Field) — char(20)
  • description (Field4) — text

music (Untitled2)

  • musicID (Key) — int(15) — 기본 키 — NOT NULL
  • composerID (Key2) — int(15) — 외래 키 → composer.composerID — NOT NULL
  • playerID (Key3) — int(15) — 외래 키 → player.playerID — NOT NULL
  • orchID (Key4) — int(15) — 외래 키 → orchestra.orchID — NOT NULL
  • musicName (Field) — char(70)
  • compositionYear (Field2) — int(10)

orchestra (Untitled5)

  • orchID (Key) — int(15) — 기본 키 — NOT NULL
  • orchName (Field) — char(50)
  • nationality (Field2) — char(20)
  • description (Field3) — text

player (Untitled3)

  • playerID (Key) — int(15) — 기본 키 — NOT NULL
  • playerName (Field) — char(50)
  • alternativeName (Field2) — char(50)
  • nationality (Field3) — char(20)
  • description (Field4) — text

relation (Untitled7)

  • musicID (Key) — int(15) — 외래 키 → music.musicID — NOT NULL
  • albumID (Key2) — int(15) — 외래 키 → album.albumID — NOT NULL