| SchemaSpy Analysis of library - ConstraintsA simple schema to show how SchemaSpy works. Use -desc to specify your own description. | Generated by SchemaSpy |
| 10 Foreign Key Constraints: |
|
| Constraint Name | Child Column | Parent Column |
|---|---|---|
| book_author_ibfk_1 | book_author.isbn | book.isbn |
| book_ibfk_1 | book.publisherId | publisher.publisherId |
| book_location_ibfk_1 | book_location.isbn | book.isbn |
| book_location_ibfk_2 | book_location.branchId | library_branch.branchId |
| borrowed_book_ibfk_1 | borrowed_book.isbn | book.isbn |
| borrowed_book_ibfk_2 | borrowed_book.branchId | library_branch.branchId |
| borrowed_book_ibfk_3 | borrowed_book.cardNo | borrower.cardNo |
| borrower_ibfk_1 | borrower.address | address.addressId |
| library_branch_ibfk_1 | library_branch.address | address.addressId |
| publisher_ibfk_1 | publisher.address | address.addressId |
| Table | Constraint Name | Constraint |
|---|---|---|
| None detected | ||