prac
Tables (11)
Untitled (BOOK)
- Key (ISBN) — int(13) — Primary key — NOT NULL
- Field (title) — char(50)
- Field (publishDate) — date
- Key (publisherID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (kdc) — int(3) — Foreign key → Untitled.Key — NOT NULL
Untitled (PUBLISHER)
- Key (publisherID) — char(10) — Primary key — NOT NULL
- Field (publisherName) — char(50)
- Field (publisherAddress) — char(100)
Untitled (AUTHOR)
- Key (authorSsn) — char(14) — Primary key — NOT NULL
- Field (authorName) — char(40)
- Field (authorAddress) — char(100)
Untitled (WRITTEN_BY)
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (authorSsn) — int(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (KDC)
- Key (kdc) — int(3) — Primary key — NOT NULL
- Field (description) — char(30)
Untitled (KEYWORD)
- Key (keywordCode) — char(20) — Primary key — NOT NULL
- Field (keywordName) — char(50)
- Field (keywordDescription) — char(200)
Untitled (BOOK_KEYWORD)
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (keywordCode) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (PERSON)
- Key (personSsn) — char(14) — Primary key — NOT NULL
- Field (personName) — char(50)
- Field (role) — char(20)
Untitled (EVENT)
- Key (eventCode) — char(20) — Primary key — NOT NULL
- Field (eventName) — char(50)
- Field (eventDescription) — char(200)
Untitled (BOOK_PERSON)
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (personSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (BOOK_EVENT)
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (eventCode) — char(20) — Foreign key → Untitled.Key — NOT NULL