lv2

Tables (3)

book (Untitled2)

  • book_id (Key) — int — Primary key — NOT NULL
  • title (Field) — String
  • author (Field2) — String
  • publisher (Field3) — String
  • book_registerdAt (Field4) — Datetime

loan (Untitled3)

  • loan_id (Key) — int — Primary key — NOT NULL
  • user_id (Field) — int
  • book_id (Field2) — int
  • isLoan (Field3) — boolean
  • loanAt (Field4) — Datetime
  • returnedAt (Field5) — Datetime

user (Untitled)

  • user_id (Key) — int — Primary key — NOT NULL
  • username (Field) — String
  • gender (Field2) — String
  • registnumber (Field3) — String
  • phonenumber (Field4) — String
  • address (Field5) — String