[다시]ERD 연습문제 6
테이블 (6)
Untitled (publisher)
- Key (pcode) — char(20) — 기본 키 — NOT NULL
- Field (pname) — char(30)
- Field (paddress) — char(30)
- Field (pphone) — int(15)
Untitled (author)
- Key (assn) — char(20) — 기본 키 — NOT NULL
- Field (aname) — char(20)
- Field (aaddress) — char(30)
Untitled (book_author)
- Key (assn) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (isbn) — char(20) — 외래 키 → book.Key — NOT NULL
Untitled (print)
- Key (prcode) — char(20) — 기본 키 — NOT NULL
- Field (prname) — char(20)
- Field (praddress) — char(30)
- Field (prphone) — int(15)
Untitled (contract)
- Key (ccode) — char(20) — 기본 키 — NOT NULL
- Field (cdate) — date
- Field (pamount) — int(10)
- Field (plimitdate) — date
- Key (isbn) — char(20) — 외래 키 → book.Key — NOT NULL
- Key (prcode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (pcode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
book
- Key (isbn) — char(20) — 기본 키 — NOT NULL
- Field (bname) — char(30)
- Field (bpdate) — date
- Field (bprice) — int(10)
- Key (pcode) — char(20) — 외래 키 → Untitled.Key — NOT NULL