ERD Exercise 6(여영규)
테이블 (5)
AUTHOR (Untitled3)
- authorID (Key) — char(20) — 기본 키 — NOT NULL
- authorName (Field) — char(20)
- authorAddress (Field2) — char(30)
- bookISBN (Key2) — char(20) — 외래 키 → BOOK.bookISBN — NOT NULL
BOOK (Untitled)
- bookISBN (Key) — char(20) — 기본 키 — NOT NULL
- bookName (Field) — char(50)
- bookPublisherdate (Field2) — date
- bookPublisher (Field3) — char(20)
CONTRACINFORMATION (Untitled5)
- contractNumberofprint (Key) — char(10) — 기본 키 — NOT NULL
- contractDeadlinedate (Field) — date
PRINTER (Untitled4)
- printerID (Key) — char(10) — 기본 키 — NOT NULL
- bookISBN (Key2) — char(20) — 외래 키 → BOOK.bookISBN — NOT NULL
- printerName (Field) — char(20)
- printerAddress (Field2) — char(30)
- printerCapacity (Field3) — char(10)
- contractNumberofprint (Key3) — char(10) — 외래 키 → CONTRACINFORMATION.contractNumberofprint — NOT NULL
- publisherID (Key4) — char(10) — 외래 키 → PUBLISHER.publisherID — NOT NULL
- bookISBN (Key22) — char(20) — 외래 키 → PUBLISHER.bookISBN — NOT NULL
PUBLISHER (Untitled2)
- publisherID (Key) — char(10) — 기본 키 — NOT NULL
- bookISBN (Key2) — char(20) — 외래 키 → BOOK.bookISBN — NOT NULL
- publisherName (Field) — char(20)
- publisherAddress (Field2) — char(30)