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