2024년5월21일
테이블 (8)
Untitled (work)
- Key (workID) — char(11) — 기본 키 — NOT NULL
- Field (workTitle) — char(50)
- Field (description) — text
Untitled (manifestaion)
- Key (maniID) — char(13) — 기본 키 — NOT NULL
- Key (workID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
- Field (bookTittle) — char(50)
- Field (author) — char(50)
- Field (pubyear) — int(4)
- Field (size) — int(2)
- Field (page) — int(4)
- Field (listprice) — int(8)
- Field (language) — char(3)
- Key (pubID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
Untitled (item)
- Key (itemID) — char — 기본 키 — NOT NULL
- Key (maniID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (workID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
- Field (buyDate) — date
- Field (price) — int(8)
Untitled (author)
- Key (authID) — char(11) — 기본 키 — NOT NULL
- Field (ahthName) — char(50)
- Field (alterName) — char(100)
- Field (description) — text
- Field (majorWork) — char(100)
Untitled (publisher)
- Key (pubID) — char(11) — 기본 키 — NOT NULL
- Field (pubName) — char(20)
- Field (address) — char(50)
- Field (description) — text
Untitled (word_auth)
- Key — 기본 키 — NOT NULL
- Key (workID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
- Key (authID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
- Field (role)
Untitled (subject)
- Key (subID) — char(11) — 기본 키 — NOT NULL
- Field (subTitle) — char(20)
- Field (description) — text
Untitled (work_subject)
- Key — 기본 키 — NOT NULL
- Key (workID) — char(11) — 외래 키 → Untitled.Key — NOT NULL
- Key (subID) — char(11) — 외래 키 → Untitled.Key — NOT NULL