SchemaSpy Analysis of library - Constraints | Generated by SchemaSpy |
10 Foreign Key Constraints: |
|
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 |