2022913002ERD6
Tables (12)
AUTHOR
- Key — char(30) — Primary key — NOT NULL
- Field — char(30)
- Field2 — int(12)
- Field3 — char(30)
- Field4 — char(12)
- Field5 — char(30)
BOOK
- Key — char(20) — Primary key — NOT NULL
- Field — char(20)
- Field2 — date
- Field3 — char(30)
- Key (Key3) — char(20) — Foreign key → PUBLISHER.Key — NOT NULL
- Field4 — int(10)
- Field5 — int(4)
- Key (Key2) — char(12) — Foreign key → KDC.Key — NOT NULL
BOOK_AUTHOR
- Key (Key2) — char(30) — Foreign key → AUTHOR.Key — NOT NULL
- Key — char(20) — Foreign key → BOOK.Key — NOT NULL
- Field — char(20)
BOOK_EVENT
- Key — char(20) — Foreign key → BOOK.Key — NOT NULL
- Key (Key2) — char(30) — Foreign key → EVENT.Key — NOT NULL
BOOK_PERSON
- Key (Key2) — char(20) — Foreign key → BOOK.Key — NOT NULL
- Key (Key3) — char(10) — Foreign key → PERSON.Key — NOT NULL
CONTRACT (CONSTRACT)
- Key — char(20) — Primary key — NOT NULL
- Field — int
- Field2 — date
- Key (Key2) — char(20) — Foreign key → BOOK.Key — NOT NULL
- Key (Key3) — char(20) — Foreign key → PUBLICATION.Key — NOT NULL
EVENT
- Key — char(30) — Primary key — NOT NULL
- Field — char(20)
- Field2 — text
- Field3
KDC
- Key — char(12) — Primary key — NOT NULL
- Field — char(30)
- Field2 — text
PERSON
- Key — char(10) — Primary key — NOT NULL
- Field — char(30)
- Field2 — text
PUBLICATION
- Key — char(20) — Primary key — NOT NULL
- Field — char(30)
- Field2 — char(30)
- Field3 — char(12)
- Field4 — char(30)
PUBLISHER
- Key — char(20) — Primary key — NOT NULL
- Field — char(30)
- Field2 — char(30)
- Field3 — char(12)
- Field4 — char(30)
SUBJECT
- Key — char(20) — Primary key — NOT NULL
- Key (Key2) — char(20) — Foreign key → BOOK.Key — NOT NULL
- Field — text
- Field2 — char(30)