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)