LastReport
Tables (7)
Untitled (YOUNG BOOK)
- Key (yBookID) — int(10) — Primary key — NOT NULL
- Field (ISBN) — char(13)
- Field (title) — char(50)
- Field (originalTitle) — char(50)
- Field (kdc) — char(50)
- Field (pubYear) — int(4)
- Field (price) — int(10)
Untitled (AUTHOR)
- Key (authorID) — int(10) — Primary key — NOT NULL
- Field (autName) — char(30)
- Field (alternativeName) — char(50)
- Field (majorWork) — text
- Field (description) — text
Untitled (PUBLISHER)
- Key (pubID) — int(10) — Primary key — NOT NULL
- Field (pubName) — char(30)
- Field (pubAddress) — char(50)
Untitled (ILLUSTRATOR)
- Key (illustratorID) — int(10) — Primary key — NOT NULL
- Field (illuName) — char(30)
- Field (alternativeName) — char(50)
- Field (description) — text
Untitled (BOOK_ MAKER)
- Key (yBookID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (authorID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (pubID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (illustratorID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (RENT)
- Key (rentID) — int(1000) — Primary key — NOT NULL
- Field (rentdate) — date
- Field (returndate) — date
- Key (yBookID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (memberID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MEMBER)
- Key (memberID) — int(10) — Primary key — NOT NULL
- Field (memName) — char(30)
- Field (address) — char(50)
- Field (phone) — int(11)
- Field (email) — char(30)