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)