기말과제
테이블 (17)
Copy Of Copy Of Copy Of Copy Of Untitled22 (supply_drama)
- Key (dramaID) — int(30) — 외래 키 → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
- Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Copy Of Copy Of Copy Of Untitled2 (drama)
- Key (dramaID) — int(30) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (genre) — char(30)
- Field (ageLimit) — int(3)
- Field (capacity) — int(3)
- Field (releaseYear) — int(4)
- Field (purchasePrice) — int(10)
- Field (runTime) — int(3)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Copy Of Copy Of Copy Of Untitled22 (supply_movie)
- Key (movieID) — int(30) — 외래 키 → Copy Of Copy Of Untitled2.Key — NOT NULL
- Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Copy Of Copy Of Untitled2 (movie)
- Key (movieID) — int(30) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (genre) — char(30)
- Field (ageLimit) — int(3)
- Field (runTime) — int(3)
- Field (capacity) — int(3)
- Field (releaseYear) — int(4)
- Field (purchasePrice) — int(10)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Copy Of Copy Of Untitled22 (supply_book)
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Copy Of Untitled (webnovel)
- Key (wnID) — int(30) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (genre) — char(30)
- Field (ageLimit) — int(3)
- Field (capacity) — int(3)
- Field (openYear) — int(4)
- Field (finishYear) — int(4)
- Field (contractPeriod) — int(4)
- Field (purchasePrice) — int(10)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Copy Of Untitled2 (supply_webnovel)
- Key (wnID) — int(30) — 외래 키 → Copy Of Untitled.Key — NOT NULL
- Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (multimedia_person)
- Key (dramaID) — int(30) — 외래 키 → Copy Of Copy Of Untitled2.Key — NOT NULL
- Key (personID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (dramaID2) — int(30) — 외래 키 → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
Untitled (supply_webtoon)
- Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (wtID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (person)
- Key (personID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (role) — char(20)
- Field (birthYear) — int(4)
- Field (deathYear) — int(4)
- Field (gender) — char(10)
- Field (nationality) — char(30)
Untitled (work)
- Key (workID) — int(30) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (description) — char(100)
Untitled (specialization)
- Key (spID) — int(30) — 기본 키 — NOT NULL
- Field (title) — int(20)
- Field (discription) — text
Untitled (work_author)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (authorID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (supplier)
- Key (supplierID) — int(30) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (department) — char(10)
- Field (depPhone) — int(11)
- Field (grade) — int(3)
- Key (spID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (author)
- Key (authorID) — int(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (alternativeName) — char(30)
- Field (nationality) — char(30)
- Field (biography) — text
Untitled (book)
- Key (ISBN) — char(13) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (subject) — char(50)
- Field (kdc) — char(20)
- Field (ageLimit) — int(3)
- Field (capacity) — int(3)
- Field (pubYear) — int(4)
- Field (type) — char(10)
- Field (purchasePrice) — int(10)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (webtoon)
- Key (wtID) — int(30) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (genre) — char(30)
- Field (ageLimit) — int(3)
- Field (capacityy) — int(3)
- Field (openYear) — int(4)
- Field (finishYear) — int(4)
- Field (contractPeriod) — int(4)
- Field (purchasePrice) — int(10)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL