spring_library

Tables (4)

Loan (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • loanDate (Field)
  • dueDate (Field2)
  • renewalCount (Field3)
  • isReturned (Field4)
  • memberId (Key2) — Foreign key → member.id — NOT NULL
  • bookId (Key3) — Foreign key → book.id — NOT NULL

book (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • author (Field2)
  • publisher (Field3)
  • publicationYear (Field4)
  • classification (Field5)
  • status (Field6)
  • amount (Field7)

member (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • idNumber (Field2)
  • feature (Field3)
  • email (Field4)
  • phoneNumber (Field5)

purchaseRequest (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • purchaseRequestCount (Field)
  • requestDate (Field2)
  • dateOfProcess (Field3)
  • processResult (Field4)
  • bookId (Key2) — Foreign key → book.id — NOT NULL
  • memberId (Key3) — Foreign key → member.id — NOT NULL