2023_05_17_개인과제
테이블 (7)
Untitled (MUSICAL)
- Key (musicalID) — int(30) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (pubYear) — int(4)
- Field (nationality) — char(10)
- Field (runtime) — int(3)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOK)
- Key (bookID) — int(30) — 기본 키 — NOT NULL
- Field (title) — char(50)
- Field (originalTitle) — char(50)
- Field (pubYear) — int(4)
- Field (expression) — char(3)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (WORK)
- Key (workID) — int(30) — 기본 키 — NOT NULL
- Field (workTitle) — char(50)
Untitled (WORK_AUTHOR)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (authorID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (roll) — char(20)
Untitled (AUTHOR)
- Key (authorID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (alternativeName) — char(50)
- Field (description) — text
Untitled (MUSICAL_PERSON)
- Key (role) — char(10) — 기본 키 — NOT NULL
- Key (personID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (musicalID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PERSON)
- Key (personID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (description) — text
- Field (reprole) — char(10)
- Field (award) — text