library
Tables (9)
Untitled (BOOK)
- Key (ISBN) — int(13) — Primary key — NOT NULL
- Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Field (pubdate) — date
- Field (bookname) — char(40)
- Field (price) — int(10)
- Field (buyingdate) — date
Untitled (TOPIC NAME)
- Key (Keyword) — char(40) — Primary key — NOT NULL
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Field (kdc class number) — int(20)
- Field (description) — tex
Untitled (PUBLISHER)
- Key (pubID) — int(20) — Primary key — NOT NULL
- Field (pubname) — char(30)
- Field (pubaddress) — char(50)
Untitled (AUTHOR)
- Key (authorcode) — int(20) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
Untitled (BOOK-AUTHOR)
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (authorcode) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (USER)
- Key (userID) — int(100) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(40)
- Field (phone) — int(14)
- Field (email) — char(30)
Untitled (RENT)
- Key (rentID) — int(100) — Primary key — NOT NULL
- Field (rentdate) — date
- Field (returndate) — date
- Field
- Key (userID) — int(100) — Foreign key → Untitled.Key — NOT NULL
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (REALATD-PERSON)
- Key (personID) — char(20) — Primary key — NOT NULL
- Field (realated) — text
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (REALATE-EVENT)
- Key (eventcode) — char(100) — Primary key — NOT NULL
- Field (eventdate)
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (pubID) — int(20) — Foreign key → Untitled.Key — NOT NULL