SchemaSpy Analysis of library - Constraints Generated by
SchemaSpy
10 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
book_author_ibfk_1 book_author.isbn book.isbn Restrict delete 
book_ibfk_1 book.publisherId publisher.publisherId Restrict delete 
book_location_ibfk_1 book_location.isbn book.isbn Restrict delete 
book_location_ibfk_2 book_location.branchId library_branch.branchId Restrict delete 
borrowed_book_ibfk_1 borrowed_book.isbn book.isbn Restrict delete 
borrowed_book_ibfk_2 borrowed_book.branchId library_branch.branchId Restrict delete 
borrowed_book_ibfk_3 borrowed_book.cardNo borrower.cardNo Restrict delete 
borrower_ibfk_1 borrower.address address.addressId Restrict delete 
library_branch_ibfk_1 library_branch.address address.addressId Restrict delete 
publisher_ibfk_1 publisher.address address.addressId Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected