book

Tables (4)

book (Book)

  • id — int — Primary key — NOT NULL
  • name — String

borrowbooks (BorrowBooks)

  • id — int — Primary key — NOT NULL
  • userid — int — Foreign key → user.id — NOT NULL
  • innerbookid — int — Foreign key → innerbook.id — NOT NULL
  • borrow_date — date
  • return_date — date
  • isreturn — int

innerbook (InnerBook)

  • id — int — Primary key — NOT NULL
  • bookid — int — Foreign key → book.id — NOT NULL
  • iskeep — int
  • bookcode — String

user (User)

  • id — int — Primary key — NOT NULL
  • username (Field) — String
  • useremail — String
  • password — String