finalERD
Tables (10)
AUTHOR (저자)
- authorID (Key) — char(10) — Primary key — NOT NULL
- authorName (Field) — char(10)
- authorAddress (Field2) — char(30)
- showpieceISBN (Key2) — char(13) — Foreign key → BOOK.ISBN — NOT NULL
BOOK (책)
- ISBN (Key) — char(13) — Primary key — NOT NULL
- bookName (Field) — char()
- publishedDate (Field2) — date()
- pbID (Key2) — char(10) — Foreign key → PUBLISHER.pbID — NOT NULL
- KDC (Field3) — char()
BOOK-RELATED (관련됨)
- relatedID (Key) — char(30) — Foreign key → RELATED.relatedID — NOT NULL
- ISBN (Key2) — char(13) — Foreign key → BOOK.ISBN — NOT NULL
BOOK-SUBJECT (주제로 함)
- ISBN (Key) — char(13) — Foreign key → BOOK.ISBN — NOT NULL
- subjID (Key2) — char(10) — Foreign key → SUBJECT.subjID — NOT NULL
CONTRACT (인쇄 계약)
- pressID (Key) — char(10) — Foreign key → PRESS.pressID — NOT NULL
- ISBN (Key2) — char(13) — Foreign key → BOOK.ISBN — NOT NULL
- copies (Field) — int(7)
- deadline (Field2) — date()
PRESS (인쇄소)
- pressID (Key) — char(10) — Primary key — NOT NULL
- pressName (Field) — char(10)
- pressAddress (Field2) — char(30)
PUBLISHER (출판사)
- pbID (Key) — char(10) — Primary key — NOT NULL
- pbName (Field) — char(10)
- pbAddress (Field2) — char(30)
RELATED (관련주기)
- relatedID (Key) — char(30) — Primary key — NOT NULL
- type (Field) — char(2)
- description (Field2) — char(100)
SUBJECT (주제)
- subjID (Key) — char(10) — Primary key — NOT NULL
- keyword (Field) — char(5)
WROTE (저작함)
- authorID (Key) — char(10) — Foreign key → AUTHOR.authorID — NOT NULL
- ISBN (Key2) — char(13) — Foreign key → BOOK.ISBN — NOT NULL