BOOK
Tables (5)
BOOK (BOOK 책)
- BOOK ISBN (ISBN) — INT (13) — Primary key — NOT NULL
- Key (저자 ID) — INT (30) — Foreign key → Untitled3.Key — NOT NULL
- Publication DATE (출판일) — INT (8)
- Signature (서명) — CHAR(30)
- Key (출판사 ID) — INT (30) — Foreign key → Untitled2.Key — NOT NULL
Untitled2 (출판사)
- Key (출판사 ID) — INT (30) — Primary key — NOT NULL
- Field (출판사 NAME) — CHAR (30)
- Field (출판사 ADDRESS) — CHAR (40)
Untitled3 (저자)
- Key (저자 ID) — INT (30) — Primary key — NOT NULL
- Field (저자 SSN) — INT (13)
- Field (저자 NAME) — CHAR (30)
- Field (저자 ADDRESS) — CHAR (40)
Untitled4 (계약서)
- Key (BOOK ISBN) — INT (13) — Primary key — NOT NULL
- Field (인쇄 량) — INT (40)
- Field (인쇄 마감일) — INT (14)
- BOOK ISBN (ISBN2) — INT (13) — Foreign key → BOOK.BOOK ISBN — NOT NULL
- Key (저자 ID) — INT (30) — Foreign key → BOOK.Key — NOT NULL
Untitled5 (인쇄소)
- Key (인쇄소 ID) — INT (30) — Primary key — NOT NULL
- Field (인쇄소 NAME) — CHAR (40)
- Field (인쇄소 ADDRESS) — CHAR (40)
- Field (인쇄량) — INT (6)
- Key (BOOK ISBN) — INT (13) — Foreign key → Untitled4.Key — NOT NULL