기말고사
테이블 (9)
AUTHOR
- athorID (authorID) — int(30) — 기본 키 — NOT NULL
- name — char(30)
- Field2 (altertivename) — char(40)
- Field (description) — text
- Field (majorWork) — text
BOOK
- ISBN — char(13) — 기본 키 — NOT NULL
- title — char(30)
- kd_6th (kdc_6th) — char(20)
- pubYer (pubYear) — int(4)
- type — char(10)
BOOK_AUTHOR
- ISBN — char(13) — 외래 키 → BOOK.ISBN — NOT NULL
- athorID (authorID) — int(30) — 외래 키 → AUTHOR.athorID — NOT NULL
- role — char10)
Untitled (MOVIE)
- Key (movieID) — int(10) — 기본 키 — NOT NULL
- Field (title) — char(20)
- Field (originalTitle) — char(30)
- Field (releasedYear) — int(4)
- Field (expression) — char(3)
- Field (description) — text
- Field (runtime) — int(3)
- ISBN — char(13) — 외래 키 → BOOK.ISBN — NOT NULL
Untitled (MOVIE_PERSON)
- Key (role) — char(20) — 기본 키 — NOT NULL
- Key (personID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (movieID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PERSON)
- Key (personID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (description) — text
- Field (repRole) — char(10)
- Field (majorWork) — text
Untitled (MUSICAL)
- Key (musicalID) — int(30) — 기본 키 — NOT NULL
- Field (title) — char(20)
- Field (originalTile) — char(30)
- Field (releasedYear) — int(4)
- Field2 (expression) — char(3)
- Field (description) — text
- Field (runtime) — int(3)
- ISBN — char(13) — 외래 키 → BOOK.ISBN — NOT NULL
Untitled (MUSICAL_PERSON)
- Key (role) — char(20) — 기본 키 — NOT NULL
- Key (musicalID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (personID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (person)
- Key (personID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (description) — text
- Field (repRole) — char(10)
- Field (majorWork) — text