ERD exercise6_publish
Tables (6)
Untitled (BOOK)
- Key (isbn) — CHAR(13) — Primary key — NOT NULL
- Field (title) — CHAR(20)
- Field (publishDate) — DATE
- Key (publisherCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (PUBLISHER)
- Key (publisherCode) — CHAR(10) — Primary key — NOT NULL
- Field (publisherName) — CHAR(10)
- Field (publisherAddress) — CHAR(30)
Untitled (AUTHOR)
- Key (authorSsd) — CHAR(13) — Primary key — NOT NULL
- Field (authorName) — CHAR(20)
- Field (authorAddress) — CHAR(30)
Untitled (PRINTING)
- Key (printingCode) — CHAR(10) — Primary key — NOT NULL
- Field (printingName) — CHAR(10)
- Field (printingAddress) — CHAR(30)
Untitled (PRINTINGCONTRACT)
- Key (isbn) — CHAR(13) — Foreign key → Untitled.Key — NOT NULL
- Key (printingCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
- Key (numberOfBooks) — INT — NOT NULL
- Key (printingEndDate) — DATE — NOT NULL
Untitled (WRITE)
- Key (isbn) — CHAR(13) — Foreign key → Untitled.Key — NOT NULL
- Key (authorSsd) — CHAR(13) — Foreign key → Untitled.Key — NOT NULL