Book 2024-Library
Tables (12)
BOOK
- Key (ISBN) — char(13) — Primary key — NOT NULL
- Field (title) — char(50)
- Field (pubDate) — date
- Field (pageNumber) — int(4)
- Field (edition) — int(3)
- Field (listPrice) — int(10)
- Field (type)
- Key (code) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (pubID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (KDC)
- Key (code) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
- Field
Untitled (PUBLISHER)
- Key (pubID) — char(10) — Primary key — NOT NULL
- Field (pubName) — char(30)
- Field (adress) — char(50)
- Field (email) — email
- Field (phone) — char(11)
- Field (fax) — char(11)
- Field (homepage)
Untitled (BOOK_AUTHOR)
- Key (authorID) — char(!0) — Foreign key → Untitled.Key — NOT NULL
- Key (ISBN) — char(13) — Foreign key → BOOK.Key — NOT NULL
- Field (role) — char(30)
Untitled (AUTHOR)
- Key (authorID) — char(!0) — Primary key — NOT NULL
Untitled (SUBJECT_HEADING)
- Key (shID) — bigInt — Primary key — NOT NULL
- Field (shName) — char(30)
- Field (alternativeName) — text
Untitled (BOOK_HEADING)
- Key (shID) — bigInt — Foreign key → Untitled.Key — NOT NULL
- Key (ISBN) — char(13) — Foreign key → BOOK.Key — NOT NULL
Untitled (EVENT)
- Key (eventID) — int — Primary key — NOT NULL
- Field (eventTitle) — char(30)
- Field (description) — text
Untitled (BOOK_EVENT)
- Key (ISBN) — char(13) — Foreign key → BOOK.Key — NOT NULL
- Key (eventID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (ITEM)
- Key (itemID) — bigInt — Primary key — NOT NULL
- Key (ISBN) — char(13) — Foreign key → BOOK.Key — NOT NULL
- Field (purDate) — date
- Field (realPrice) — int(6)
Untitled (CUSTOMER)
- Key (cusID) — int — Primary key — NOT NULL
- Field (name) — char(20)
- Field (phone) — char(11)
- Field (email) — mail
- Field (address) — char(50)
Untitled (RENT)
- Key (itemID) — bigInt — Foreign key → Untitled.Key — NOT NULL
- Key (cusID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (ISBN) — char(13) — Foreign key → Untitled.Key — NOT NULL