erd 예제6
테이블 (6)
BOOK
- Key (bookID) — char(200) — 기본 키 — NOT NULL
- Field (ISBN) — num.
- Key (ISBN2) — num — 외래 키 → Untitled.Key — NOT NULL
Untitled (PUBLICHER)
- Key (publsherID) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(20)
- Field (phone) — char(20)
- Key (bookID) — char(200) — 외래 키 → BOOK.Key — NOT NULL
Untitled (BOOK_INFO)
- Key (ISBN) — num — 기본 키 — NOT NULL
- Field (bookID) — char(200)
- Field (publisher) — char(20)
- Field (author) — char(120)
- Field (pub_date) — time
- Field (booktitle) — char(200)
- Field
Untitled (AUTHOR)
- Key (authorID) — char(120) — 기본 키 — NOT NULL
- Field (name) — char(120)
- Field (address) — char(100)
- Field (phone) — char(80)
- Key (publsherID) — 외래 키 → Untitled.Key — NOT NULL
- Key (bookID) — char(200) — 외래 키 → BOOK.Key — NOT NULL
Untitled (PRINTER)
- Key (printerID) — char(5) — 기본 키 — NOT NULL
- Field (name) — char(5)
- Field (address) — char(5)
- Field (phone) — char(5)
- Field (email) — char(5)
Untitled (CONTRACT)
- Key (contractID) — char(20) — 기본 키 — NOT NULL
- Field (number_of_book) — char
- Field (deadline) — time