중간고사
테이블 (7)
Untitled (book)
- Key (isbn) — int(10) — 기본 키 — NOT NULL
- Key (company id) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — char(30)
- Field (pubdate) — date
- Field (editor name) — char(10)
- Field (related person) — char(10)
- Field (related case) — char(10)
- Key (kdc number) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (publishing company)
- Key (company id) — int(10) — 기본 키 — NOT NULL
- Field (company name) — char(10)
- Field (adress) — char(10)
- Field (phone) — int(11)
Untitled (writer)
- Key (writer name) — char(10) — 기본 키 — NOT NULL
- Field (birthdate) — int(10)
- Field (adress) — char(10)
- Field (phone) — int(10)
- Field (famous work) — char(20)
Untitled (book-wirter)
- Key (isbn) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (company id) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (writer name) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (book title) — char(30)
Untitled (printing factory)
- Key (factory id) — int(10) — 기본 키 — NOT NULL
- Field (factory name) — char(10)
- Field (adress) — char(30)
- Field (phone) — int(11)
- Field
Untitled (printing contract)
- Key (printing number) — char(10) — 기본 키 — NOT NULL
- Field (deadline) — date
- Key (isbn) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (company id) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (factory id) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (kdc)
- Key (kdc number) — int(10) — 기본 키 — NOT NULL
- Field (주류(fist keyword)) — char(10)
- Field (강목(second keyword) — char(10)
- Field (요목(third keyword) — char(10)