기말과제-한경희
테이블 (9)
Untitled (WORK)
- workID — int(30) — 기본 키 — NOT NULL
- Field (workTitle) — char(50)
Untitled (BOOK)
- Key (ISBN) — char(13) — 기본 키 — NOT NULL
- Field (title) — char(50)
- Field (originalTitle) — char(50)
- Field (pubYear) — int(4)
- Field (manifestationType) — char(30)
- Field (description) — text
- Field (kdc_6th) — char(20)
- Field (originalPubYear) — int(4)
- workID — int(30) — 외래 키 → Untitled.workID — NOT NULL
Untitled (PUBLISHER)
- Key (pubID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field
Untitled (MOVIE)
- Key (movieID) — char(30) — 기본 키 — NOT NULL
- Field (title) — char(50)
- Field (originalTitle) — char(50)
- Field (releasedYear) — int(4)
- Field (language) — char(30)
- Field (description) — text
- Field (runTime) — int(3)
- workID — int(30) — 외래 키 → Untitled.workID — NOT NULL
Untitled (PERSON)
- Key (personID) — char(100) — 기본 키 — NOT NULL
- Field (name) — char(50)
- Field (description) — text
- Field (nationality) — char(30)
- Field (majorWorks) — text
- Field (repRole) — char(20)
- Field (alternativeName) — char(50)
Untitled (MOVIE_PERSON)
- Key (role) — char(20) — 기본 키 — NOT NULL
- Key (movieID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (personID) — char(100) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOK_PERSON)
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (personID) — char(100) — 외래 키 → Untitled.Key — NOT NULL
- Field (role) — char(20)
Untitled (BOOK_PUBLISHER)
- Key (pubID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
Untitled (WORK_PERSON)
- workID — int(30) — 외래 키 → Untitled.workID — NOT NULL