library-api

Tables (3)

Book (Untitled2)

  • BookId (Key) — Primary key — NOT NULL
  • bookImage (Field)
  • title (Field2)
  • author (Field3)
  • publisher (Field4)

Loan (Untitled3)

  • BookId (Key3) — Foreign key → Book.BookId — NOT NULL
  • userId (Key22) — Foreign key → User.userId — NOT NULL
  • Field
  • Field2

User (Untitled)

  • userId (Key2) — Primary key — NOT NULL
  • username (Field)
  • phonenumber (Field2)
  • password (Field3)