ex_2024
Tables (4)
BOOK
- Key (bookID) — char(10) — Primary key — NOT NULL
- Field (ISBN) — char(13)
- Field (title) — char(50)
- Field (origlnalTitle) — char(50)
- Field (kdc_6th) — char(50)
- Field (pubYear) — int(4)
- Field (illustrator) — char(30)
- Field (publisher) — char(50)
- Field (price) — int(6)
- Key (userID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (AUTHOR)
- Key (authorID) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (alternativeName) — char(30)
- Field (nationality) — char(3)
- Field (majorWork) — char(50)
Untitled (BOOK_AUTHOR)
- Key (bookID) — char(10) — Foreign key → BOOK.Key — NOT NULL
- Key (authorID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (USER)
- Key (userID) — char(10) — Primary key — NOT NULL
- Field (name) — char(50)
- Field (address) — char(30)
- Field (email) — char(30)