기말과제
테이블 (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