Constraints

330 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
borrower_files_ibfk_1
borrower_files.borrowernumber
borrowers.borrowernumber
Cascade on delete
linktracker_item_ibfk
linktracker.itemnumber
items.itemnumber
Null on delete
linktracker_biblio_ibfk
linktracker.biblionumber
biblio.biblionumber
Null on delete
linktracker_borrower_ibfk
linktracker.borrowernumber
borrowers.borrowernumber
Null on delete
marc_subfield_structure_ibfk_1
marc_subfield_structure.authorised_value
authorised_value_categories.category_name
Null on delete
creator_batches_ibfk_3
creator_batches.item_number
items.itemnumber
Cascade on delete
creator_batches_ibfk_2
creator_batches.branch_code
branches.branchcode
Cascade on delete
creator_batches_ibfk_1
creator_batches.borrower_number
borrowers.borrowernumber
Cascade on delete
old_reserves_ibfk_2
old_reserves.biblionumber
biblio.biblionumber
Null on delete
old_reserves_ibfk_1
old_reserves.borrowernumber
borrowers.borrowernumber
Null on delete
old_reserves_ibfk_4
old_reserves.itemtype
itemtypes.itemtype
Null on delete
old_reserves_ibfk_3
old_reserves.itemnumber
items.itemnumber
Null on delete
old_reserves_ibfk_ig
old_reserves.item_group_id
item_groups.item_group_id
Null on delete
import_records_ifbk_1
import_records.import_batch_id
import_batches.import_batch_id
Cascade on delete
erm_licenses_ibfk_1
erm_licenses.vendor_id
aqbooksellers.id
Null on delete
oai_sets_descriptions_ibfk_1
oai_sets_descriptions.set_id
oai_sets.id
Cascade on delete
items_search_fields_authorised_values_category
items_search_fields.authorised_values_category
authorised_value_categories.category_name
Null on delete
borrower_debarments_ibfk_1
borrower_debarments.borrowernumber
borrowers.borrowernumber
Cascade on delete
borrower_debarments_ibfk_2
borrower_debarments.type
restriction_types.code
Restrict delete
erm_agreement_periods_ibfk_1
erm_agreement_periods.agreement_id
erm_agreements.agreement_id
Cascade on delete
club_template_fields_ibfk_1
club_template_fields.club_template_id
club_templates.id
Cascade on delete
recalls_ibfk_3
recalls.item_id
items.itemnumber
Cascade on delete
recalls_ibfk_2
recalls.biblio_id
biblio.biblionumber
Cascade on delete
recalls_ibfk_1
recalls.patron_id
borrowers.borrowernumber
Cascade on delete
recalls_ibfk_4
recalls.pickup_library_id
branches.branchcode
Cascade on delete
club_enrollment_fields_ibfk_2
club_enrollment_fields.club_template_enrollment_field_id
club_template_enrollment_fields.id
Cascade on delete
club_enrollment_fields_ibfk_1
club_enrollment_fields.club_enrollment_id
club_enrollments.id
Cascade on delete
borrower_discharges_ibfk1
discharges.borrower
borrowers.borrowernumber
Cascade on delete
afv_fk
additional_field_values.field_id
additional_fields.id
Cascade on delete
matcher_matchpoints_ifbk_1
matcher_matchpoints.matcher_id
marc_matchers.matcher_id
Cascade on delete
matcher_matchpoints_ifbk_2
matcher_matchpoints.matchpoint_id
matchpoints.matchpoint_id
Cascade on delete
ticket_updates_ibfk_1
ticket_updates.ticket_id
tickets.id
Cascade on delete
ticket_updates_ibfk_2
ticket_updates.user_id
borrowers.borrowernumber
Cascade on delete
vfk_vendor_id
vendor_edi_accounts.vendor_id
aqbooksellers.id
Restrict delete
vfk_shipment_budget
vendor_edi_accounts.shipment_budget
aqbudgets.budget_id
Restrict delete
branchtransfers_ibfk_2
branchtransfers.tobranch
branches.branchcode
Cascade on delete
branchtransfers_ibfk_3
branchtransfers.itemnumber
items.itemnumber
Cascade on delete
branchtransfers_ibfk_1
branchtransfers.frombranch
branches.branchcode
Cascade on delete
class_source_ibfk_1
class_sources.class_sort_rule
class_sort_rules.class_sort_rule
Restrict delete
class_source_ibfk_2
class_sources.class_split_rule
class_split_rules.class_split_rule
Restrict delete
curbside_pickup_opening_slots_ibfk_1
curbside_pickup_opening_slots.curbside_pickup_policy_id
curbside_pickup_policy.id
Cascade on delete
borrower_macro_fk
advanced_editor_macros.borrowernumber
borrowers.borrowernumber
Cascade on delete
aqorder_users_ibfk_1
aqorder_users.ordernumber
aqorders.ordernumber
Cascade on delete
aqorder_users_ibfk_2
aqorder_users.borrowernumber
borrowers.borrowernumber
Cascade on delete
oai_sets_biblios_ibfk_2
oai_sets_biblios.set_id
oai_sets.id
Cascade on delete
clubs_holds_ibfk_3
club_holds.item_id
items.itemnumber
Cascade on delete
clubs_holds_ibfk_2
club_holds.biblio_id
biblio.biblionumber
Cascade on delete
clubs_holds_ibfk_1
club_holds.club_id
clubs.id
Cascade on delete
aqbudgets_planning_ifbk_1
aqbudgets_planning.budget_id
aqbudgets.budget_id
Cascade on delete
messages_ibfk_1
messages.manager_id
borrowers.borrowernumber
Null on delete
messages_borrowernumber
messages.borrowernumber
borrowers.borrowernumber
Cascade on delete
erm_eholdings_packages_ibfk_1
erm_eholdings_packages.vendor_id
aqbooksellers.id
Null on delete
r_guarantor
borrower_relationships.guarantor_id
borrowers.borrowernumber
Cascade on delete
r_guarantee
borrower_relationships.guarantee_id
borrowers.borrowernumber
Cascade on delete
account_offsets_ibfk_p
account_offsets.credit_id
accountlines.accountlines_id
Cascade on delete
account_offsets_ibfk_f
account_offsets.debit_id
accountlines.accountlines_id
Cascade on delete
aqinvoice_adjustments_fk_budget_id
aqinvoice_adjustments.budget_id
aqbudgets.budget_id
Null on delete
aqinvoice_adjustments_fk_invoiceid
aqinvoice_adjustments.invoiceid
aqinvoices.invoiceid
Cascade on delete
serial_ibfk_2
serial.subscriptionid
subscription.subscriptionid
Cascade on delete
serial_ibfk_1
serial.biblionumber
biblio.biblionumber
Cascade on delete
housebound_profile_bnfk
housebound_profile.borrowernumber
borrowers.borrowernumber
Cascade on delete
booksellerid_fk1
aqcontract.booksellerid
aqbooksellers.id
Cascade on delete
tags_biblionumber_fk_1
tags_all.biblionumber
biblio.biblionumber
Cascade on delete
tags_borrowers_fk_1
tags_all.borrowernumber
borrowers.borrowernumber
Null on delete
subscription_history_ibfk_2
subscriptionhistory.subscriptionid
subscription.subscriptionid
Cascade on delete
subscription_history_ibfk_1
subscriptionhistory.biblionumber
biblio.biblionumber
Cascade on delete
cash_register_actions_manager
cash_register_actions.manager_id
borrowers.borrowernumber
Cascade on delete
cash_register_actions_register
cash_register_actions.register_id
cash_registers.id
Cascade on delete
illcomments_bnfk
illcomments.borrowernumber
borrowers.borrowernumber
Cascade on delete
illcomments_ifk
illcomments.illrequest_id
illrequests.illrequest_id
Cascade on delete
old_issues_ibfk_borrowers_borrowernumber
old_issues.issuer_id
borrowers.borrowernumber
Null on delete
old_issues_ibfk_1
old_issues.borrowernumber
borrowers.borrowernumber
Null on delete
old_issues_ibfk_2
old_issues.itemnumber
items.itemnumber
Null on delete
illrequestattributes_ifk
illrequestattributes.illrequest_id
illrequests.illrequest_id
Cascade on delete
borrower_message_transport_preferences_ibfk_2
borrower_message_transport_preferences.message_transport_type
message_transport_types.message_transport_type
Cascade on delete
borrower_message_transport_preferences_ibfk_1
borrower_message_transport_preferences.borrower_message_preference_id
borrower_message_preferences.borrower_message_preference_id
Cascade on delete
erm_eholdings_packages_agreements_ibfk_2
erm_eholdings_packages_agreements.agreement_id
erm_agreements.agreement_id
Cascade on delete
erm_eholdings_packages_agreements_ibfk_1
erm_eholdings_packages_agreements.package_id
erm_eholdings_packages.package_id
Cascade on delete
identity_provider_domain_ibfk_1
identity_provider_domains.identity_provider_id
identity_providers.identity_provider_id
Cascade on delete
identity_provider_domain_ibfk_2
identity_provider_domains.default_library_id
branches.branchcode
Cascade on delete
identity_provider_domain_ibfk_3
identity_provider_domains.default_category_id
categories.categorycode
Cascade on delete
itemtypes_ibfk_1
itemtypes.parent_type
itemtypes.itemtype
Restrict delete
library_smtp_servers_smtp_servers_fk
library_smtp_servers.smtp_server_id
smtp_servers.id
Cascade on delete
library_smtp_servers_library_fk
library_smtp_servers.library_id
branches.branchcode
Cascade on delete
alert_ibfk_1
alert.borrowernumber
borrowers.borrowernumber
Cascade on delete
club_templates_ibfk_1
club_templates.branchcode
branches.branchcode
Cascade on delete
account_credit_types_branches_ibfk_1
account_credit_types_branches.credit_type_code
account_credit_types.code
Cascade on delete
account_credit_types_branches_ibfk_2
account_credit_types_branches.branchcode
branches.branchcode
Cascade on delete
item_bundles_ibfk_2
item_bundles.host
items.itemnumber
Cascade on delete
item_bundles_ibfk_1
item_bundles.item
items.itemnumber
Cascade on delete
import_auths_ibfk_1
import_auths.import_record_id
import_records.import_record_id
Cascade on delete
aqbudgetperiods_ibfk_1
aqbudgets.budget_period_id
aqbudgetperiods.budget_period_id
Cascade on delete
bn
item_editor_templates.patron_id
borrowers.borrowernumber
Null on delete
erm_agreement_relationships_ibfk_1
erm_agreement_relationships.agreement_id
erm_agreements.agreement_id
Cascade on delete
erm_agreement_relationships_ibfk_2
erm_agreement_relationships.related_agreement_id
erm_agreements.agreement_id
Cascade on delete
erm_agreement_licenses_ibfk_2
erm_agreement_licenses.license_id
erm_licenses.license_id
Cascade on delete
erm_agreement_licenses_ibfk_1
erm_agreement_licenses.agreement_id
erm_agreements.agreement_id
Cascade on delete
library_groups_ibfk_1
library_groups.parent_id
library_groups.id
Cascade on delete
library_groups_ibfk_2
library_groups.branchcode
branches.branchcode
Cascade on delete
matchpoint_component_norms_ifbk_1
matchpoint_component_norms.matchpoint_component_id
matchpoint_components.matchpoint_component_id
Cascade on delete
virtualshelfshares_ibfk_2
virtualshelfshares.borrowernumber
borrowers.borrowernumber
Null on delete
virtualshelfshares_ibfk_1
virtualshelfshares.shelfnumber
virtualshelves.shelfnumber
Cascade on delete
aqbasket_ibfk_1
aqbasket.booksellerid
aqbooksellers.id
Restrict delete
aqbasket_ibfk_2
aqbasket.contractnumber
aqcontract.contractnumber
Restrict delete
aqbasket_ibfk_3
aqbasket.basketgroupid
aqbasketgroups.id
Restrict delete
aqbasket_ibfk_4
aqbasket.branch
branches.branchcode
Null on delete
authorised_values_branches_ibfk_2
authorised_values_branches.branchcode
branches.branchcode
Cascade on delete
authorised_values_branches_ibfk_1
authorised_values_branches.av_id
authorised_values.id
Cascade on delete
patronimage_fk1
patronimage.borrowernumber
borrowers.borrowernumber
Cascade on delete
borrower_attribute_types_ibfk_1
borrower_attribute_types.category_code
categories.categorycode
Restrict delete
matcher_matchchecks_ifbk_3
matchchecks.target_matchpoint_id
matchpoints.matchpoint_id
Cascade on delete
matcher_matchchecks_ifbk_2
matchchecks.source_matchpoint_id
matchpoints.matchpoint_id
Cascade on delete
matcher_matchchecks_ifbk_1
matchchecks.matcher_id
marc_matchers.matcher_id
Cascade on delete
tags_approval_borrowers_fk_1
tags_approval.approved_by
borrowers.borrowernumber
Null on delete
itemtypes_branches_ibfk_2
itemtypes_branches.branchcode
branches.branchcode
Cascade on delete
itemtypes_branches_ibfk_1
itemtypes_branches.itemtype
itemtypes.itemtype
Cascade on delete
auth_tag_structure_ibfk_1
auth_tag_structure.authtypecode
auth_types.authtypecode
Cascade on delete
patron_consent_ibfk_1
patron_consent.borrowernumber
borrowers.borrowernumber
Cascade on delete
aqbasketusers_ibfk_1
aqbasketusers.basketno
aqbasket.basketno
Cascade on delete
aqbasketusers_ibfk_2
aqbasketusers.borrowernumber
borrowers.borrowernumber
Cascade on delete
aqbasketgroups_ibfk_1
aqbasketgroups.booksellerid
aqbooksellers.id
Cascade on delete
illrequests_bnfk
illrequests.borrowernumber
borrowers.borrowernumber
Cascade on delete
illrequests_safk
illrequests.status_alias
authorised_values.authorised_value
Null on delete
illrequests_bcfk_2
illrequests.branchcode
branches.branchcode
Cascade on delete
illrequests_bibfk
illrequests.biblio_id
biblio.biblionumber
Null on delete
aqbookseller_aliases_ibfk_1
aqbookseller_aliases.vendor_id
aqbooksellers.id
Cascade on delete
course_items_ibfk_1
course_items.itemnumber
items.itemnumber
Cascade on delete
fk_course_items_biblionumber
course_items.biblionumber
biblio.biblionumber
Cascade on delete
fk_course_items_homebranch_storage
course_items.homebranch_storage
branches.branchcode
Cascade on delete
course_items_ibfk_2
course_items.holdingbranch
branches.branchcode
Cascade on delete
fk_course_items_homebranch
course_items.homebranch
branches.branchcode
Cascade on delete
erm_documents_ibfk_1
erm_documents.agreement_id
erm_agreements.agreement_id
Cascade on delete
erm_documents_ibfk_2
erm_documents.license_id
erm_licenses.license_id
Cascade on delete
tmp_holdsqueue_ibfk_1
tmp_holdsqueue.itemnumber
items.itemnumber
Cascade on delete
tmp_holdsqueue_ibfk_2
tmp_holdsqueue.biblionumber
biblio.biblionumber
Cascade on delete
tmp_holdsqueue_ibfk_3
tmp_holdsqueue.borrowernumber
borrowers.borrowernumber
Cascade on delete
user_permissions_ibfk_1
user_permissions.borrowernumber
borrowers.borrowernumber
Cascade on delete
user_permissions_ibfk_2
user_permissions.module_bit
user_permissions.code
permissions.module_bit
permissions.code
Cascade on delete
houseboundvisit_bnfk_1
housebound_visit.chooser_brwnumber
borrowers.borrowernumber
Cascade on delete
houseboundvisit_bnfk
housebound_visit.borrowernumber
housebound_profile.borrowernumber
Cascade on delete
houseboundvisit_bnfk_2
housebound_visit.deliverer_brwnumber
borrowers.borrowernumber
Cascade on delete
record_metadata_fk_1
biblio_metadata.biblionumber
biblio.biblionumber
Cascade on delete
clubs_holds_paton_holds_ibfk_3
club_holds_to_patron_holds.hold_id
reserves.reserve_id
Cascade on delete
clubs_holds_paton_holds_ibfk_2
club_holds_to_patron_holds.patron_id
borrowers.borrowernumber
Cascade on delete
clubs_holds_paton_holds_ibfk_1
club_holds_to_patron_holds.club_hold_id
club_holds.id
Cascade on delete
tags_index_term_fk_1
tags_index.term
tags_approval.term
Cascade on delete
tags_index_biblionumber_fk_1
tags_index.biblionumber
biblio.biblionumber
Cascade on delete
subscriptionroutinglist_ibfk_1
subscriptionroutinglist.borrowernumber
borrowers.borrowernumber
Cascade on delete
subscriptionroutinglist_ibfk_2
subscriptionroutinglist.subscriptionid
subscription.subscriptionid
Cascade on delete
branches_overdrive_ibfk_1
branches_overdrive.branchcode
branches.branchcode
Cascade on delete
collectionst_ibfk_1
collections_tracking.colId
collections.colId
Cascade on delete
erm_eholdings_resources_ibfk_3
erm_eholdings_resources.vendor_id
aqbooksellers.id
Null on delete
erm_eholdings_resources_ibfk_2
erm_eholdings_resources.package_id
erm_eholdings_packages.package_id
Cascade on delete
erm_eholdings_resources_ibfk_1
erm_eholdings_resources.title_id
erm_eholdings_titles.title_id
Cascade on delete
patron_lists_ibfk_1
patron_lists.owner
borrowers.borrowernumber
Cascade on delete
course_instructors_ibfk_2
course_instructors.course_id
courses.course_id
Restrict delete
course_instructors_ibfk_1
course_instructors.borrowernumber
borrowers.borrowernumber
Cascade on delete
import_items_ibfk_1
import_items.import_record_id
import_records.import_record_id
Cascade on delete
reserves_ibfk_ig
reserves.item_group_id
item_groups.item_group_id
Cascade on delete
reserves_ibfk_2
reserves.biblionumber
biblio.biblionumber
Cascade on delete
reserves_ibfk_1
reserves.borrowernumber
borrowers.borrowernumber
Cascade on delete
reserves_ibfk_4
reserves.branchcode
branches.branchcode
Cascade on delete
reserves_ibfk_3
reserves.itemnumber
items.itemnumber
Cascade on delete
reserves_ibfk_6
reserves.desk_id
desks.desk_id
Null on delete
reserves_ibfk_5
reserves.itemtype
itemtypes.itemtype
Cascade on delete
borrower_attributes_ibfk_1
borrower_attributes.borrowernumber
borrowers.borrowernumber
Cascade on delete
borrower_attributes_ibfk_2
borrower_attributes.code
borrower_attribute_types.code
Cascade on delete
fk_desks_branchcode
desks.branchcode
branches.branchcode
Cascade on delete
categories_branches_ibfk_1
categories_branches.categorycode
categories.categorycode
Cascade on delete
categories_branches_ibfk_2
categories_branches.branchcode
branches.branchcode
Cascade on delete
special_holidays_ibfk_1
special_holidays.branchcode
branches.branchcode
Cascade on delete
pseudonymized_borrower_attributes_ibfk_1
pseudonymized_borrower_attributes.transaction_id
pseudonymized_transactions.id
Cascade on delete
anonymized_borrower_attributes_ibfk_2
pseudonymized_borrower_attributes.code
borrower_attribute_types.code
Cascade on delete
curbside_pickups_ibfk_3
curbside_pickups.staged_by
borrowers.borrowernumber
Null on delete
curbside_pickups_ibfk_2
curbside_pickups.borrowernumber
borrowers.borrowernumber
Cascade on delete
curbside_pickups_ibfk_1
curbside_pickups.branchcode
branches.branchcode
Cascade on delete
deletedrecord_metadata_fk_1
deletedbiblio_metadata.biblionumber
deletedbiblio.biblionumber
Cascade on delete
club_fields_ibfk_3
club_fields.club_template_field_id
club_template_fields.id
Cascade on delete
club_fields_ibfk_4
club_fields.club_id
clubs.id
Cascade on delete
api_keys_fk_patron_id
api_keys.patron_id
borrowers.borrowernumber
Cascade on delete
import_biblios_ibfk_1
import_biblios.import_record_id
import_records.import_record_id
Cascade on delete
authorised_values_authorised_values_category
authorised_values.category
authorised_value_categories.category_name
Cascade on delete
virtualshelves_ibfk_1
virtualshelves.owner
borrowers.borrowernumber
Null on delete
import_record_matches_ibfk_1
import_record_matches.import_record_id
import_records.import_record_id
Cascade on delete
oai_sets_mappings_ibfk_1
oai_sets_mappings.set_id
oai_sets.id
Cascade on delete
aqorders_items_ibfk_1
aqorders_items.ordernumber
aqorders.ordernumber
Cascade on delete
accountlines_ibfk_borrowers_2
accountlines.manager_id
borrowers.borrowernumber
Null on delete
accountlines_ibfk_branches
accountlines.branchcode
branches.branchcode
Null on delete
accountlines_ibfk_registers
accountlines.register_id
cash_registers.id
Null on delete
accountlines_ibfk_debit_type
accountlines.debit_type_code
account_debit_types.code
Restrict delete
accountlines_ibfk_borrowers
accountlines.borrowernumber
borrowers.borrowernumber
Null on delete
accountlines_ibfk_items
accountlines.itemnumber
items.itemnumber
Null on delete
accountlines_ibfk_credit_type
accountlines.credit_type_code
account_credit_types.code
Restrict delete
article_requests_ibfk_3
article_requests.itemnumber
items.itemnumber
Null on delete
article_requests_ibfk_4
article_requests.branchcode
branches.branchcode
Null on delete
article_requests_ibfk_5
article_requests.debit_id
accountlines.accountlines_id
Null on delete
article_requests_ibfk_1
article_requests.borrowernumber
borrowers.borrowernumber
Cascade on delete
article_requests_ibfk_2
article_requests.biblionumber
biblio.biblionumber
Cascade on delete
tickets_ibfk_3
tickets.biblio_id
biblio.biblionumber
Cascade on delete
tickets_ibfk_2
tickets.resolver_id
borrowers.borrowernumber
Cascade on delete
tickets_ibfk_1
tickets.reporter_id
borrowers.borrowernumber
Cascade on delete
auth_subfield_structure_ibfk_1
auth_subfield_structure.authtypecode
auth_types.authtypecode
Cascade on delete
matchpoint_components_ifbk_1
matchpoint_components.matchpoint_id
matchpoints.matchpoint_id
Cascade on delete
cash_registers_branch
cash_registers.branch
branches.branchcode
Cascade on delete
ratings_ibfk_2
ratings.biblionumber
biblio.biblionumber
Cascade on delete
ratings_ibfk_1
ratings.borrowernumber
borrowers.borrowernumber
Cascade on delete
item_groups_ibfk_1
item_groups.biblio_id
biblio.biblionumber
Cascade on delete
letter_fk
message_queue.letter_id
letter.id
Null on delete
messageq_ibfk_2
message_queue.message_transport_type
message_transport_types.message_transport_type
Restrict delete
messageq_ibfk_1
message_queue.borrowernumber
borrowers.borrowernumber
Cascade on delete
stockrotationitems_sifk
stockrotationitems.stage_id
stockrotationstages.stage_id
Cascade on delete
stockrotationitems_iifk
stockrotationitems.itemnumber_id
items.itemnumber
Cascade on delete
rc_items_ibfk
return_claims.itemnumber
items.itemnumber
Cascade on delete
rc_borrowers_ibfk
return_claims.borrowernumber
borrowers.borrowernumber
Cascade on delete
rc_updated_by_ibfk
return_claims.updated_by
borrowers.borrowernumber
Null on delete
rc_resolved_by_ibfk
return_claims.resolved_by
borrowers.borrowernumber
Null on delete
rc_created_by_ibfk
return_claims.created_by
borrowers.borrowernumber
Null on delete
serialitems_sfk_2
serialitems.itemnumber
items.itemnumber
Cascade on delete
serialitems_sfk_1
serialitems.serialid
serial.serialid
Cascade on delete
biblioitems_ibfk_1
biblioitems.biblionumber
biblio.biblionumber
Cascade on delete
emfk_basketno
edifact_messages.basketno
aqbasket.basketno
Cascade on delete
emfk_vendor
edifact_messages.vendor_id
aqbooksellers.id
Cascade on delete
emfk_edi_acct
edifact_messages.edi_acct
vendor_edi_accounts.id
Cascade on delete
item_group_items_gifk_1
item_group_items.item_group_id
item_groups.item_group_id
Cascade on delete
item_group_items_iifk_1
item_group_items.item_id
items.itemnumber
Cascade on delete
erm_eholdings_titles_ibfk_2
erm_eholdings_titles.biblio_id
biblio.biblionumber
Null on delete
matchpoints_ifbk_1
matchpoints.matcher_id
marc_matchers.matcher_id
Cascade on delete
erm_user_roles_ibfk_1
erm_user_roles.agreement_id
erm_agreements.agreement_id
Cascade on delete
erm_user_roles_ibfk_2
erm_user_roles.license_id
erm_licenses.license_id
Cascade on delete
erm_user_roles_ibfk_3
erm_user_roles.user_id
borrowers.borrowernumber
Cascade on delete
renewals_renewer_id
checkout_renewals.renewer_id
borrowers.borrowernumber
Null on delete
aqorders_subscriptionid
aqorders.subscriptionid
subscription.subscriptionid
Cascade on delete
aqorders_created_by
aqorders.created_by
borrowers.borrowernumber
Null on delete
aqorders_budget_id_fk
aqorders.budget_id
aqbudgets.budget_id
Cascade on delete
aqorders_ibfk_3
aqorders.invoiceid
aqinvoices.invoiceid
Null on delete
aqorders_invoice_currency
aqorders.invoice_currency
currency.currency
Null on delete
aqorders_currency
aqorders.currency
currency.currency
Null on delete
aqorders_ibfk_2
aqorders.biblionumber
biblio.biblionumber
Null on delete
aqorders_ibfk_1
aqorders.basketno
aqbasket.basketno
Cascade on delete
patron_list_patrons_ibfk_2
patron_list_patrons.borrowernumber
borrowers.borrowernumber
Cascade on delete
patron_list_patrons_ibfk_1
patron_list_patrons.patron_list_id
patron_lists.patron_list_id
Cascade on delete
club_template_enrollment_fields_ibfk_1
club_template_enrollment_fields.club_template_id
club_templates.id
Cascade on delete
subscription_ibfk_3
subscription.biblionumber
biblio.biblionumber
Cascade on delete
subscription_ibfk_1
subscription.periodicity
subscription_frequencies.id
Null on delete
subscription_ibfk_2
subscription.numberpattern
subscription_numberpatterns.id
Null on delete
problem_reports_ibfk2
problem_reports.branchcode
branches.branchcode
Cascade on delete
problem_reports_ibfk1
problem_reports.borrowernumber
borrowers.borrowernumber
Cascade on delete
aqorders_transfers_ordernumber_to
aqorders_transfers.ordernumber_to
aqorders.ordernumber
Null on delete
aqorders_transfers_ordernumber_from
aqorders_transfers.ordernumber_from
aqorders.ordernumber
Null on delete
items_last_borrower_ibfk_1
items_last_borrower.itemnumber
items.itemnumber
Cascade on delete
items_last_borrower_ibfk_2
items_last_borrower.borrowernumber
borrowers.borrowernumber
Cascade on delete
overduerules_fk
overduerules_transport_types.overduerules_id
overduerules.overduerules_id
Cascade on delete
mtt_fk
overduerules_transport_types.message_transport_type
message_transport_types.message_transport_type
Cascade on delete
borrowers_ibfk_2
borrowers.branchcode
branches.branchcode
Restrict delete
borrowers_ibfk_1
borrowers.categorycode
categories.categorycode
Restrict delete
borrowers_ibfk_3
borrowers.sms_provider_id
sms_providers.id
Null on delete
repeatable_holidays_ibfk_1
repeatable_holidays.branchcode
branches.branchcode
Cascade on delete
permissions_ibfk_1
permissions.module_bit
userflags.bit
Cascade on delete
message_transport_type_fk
letter.message_transport_type
message_transport_types.message_transport_type
Cascade on delete
borrower_attribute_types_branches_ibfk_1
borrower_attribute_types_branches.bat_code
borrower_attribute_types.code
Cascade on delete
borrower_attribute_types_branches_ibfk_2
borrower_attribute_types_branches.b_branchcode
branches.branchcode
Cascade on delete
circ_rules_ibfk_1
circulation_rules.branchcode
branches.branchcode
Cascade on delete
circ_rules_ibfk_2
circulation_rules.categorycode
categories.categorycode
Cascade on delete
circ_rules_ibfk_3
circulation_rules.itemtype
itemtypes.itemtype
Cascade on delete
items_ibfk_1
items.biblioitemnumber
biblioitems.biblioitemnumber
Cascade on delete
items_ibfk_4
items.biblionumber
biblio.biblionumber
Cascade on delete
items_ibfk_2
items.homebranch
branches.branchcode
Restrict delete
items_ibfk_3
items.holdingbranch
branches.branchcode
Restrict delete
mmta_ibfk_1
marc_modification_template_actions.template_id
marc_modification_templates.template_id
Cascade on delete
search_marc_to_field_ibfk_2
search_marc_to_field.search_field_id
search_field.id
Cascade on delete
search_marc_to_field_ibfk_1
search_marc_to_field.search_marc_map_id
search_marc_map.id
Cascade on delete
bibliocoverimage_fk1
cover_images.biblionumber
biblio.biblionumber
Cascade on delete
bibliocoverimage_fk2
cover_images.itemnumber
items.itemnumber
Cascade on delete
clubs_ibfk_1
clubs.club_template_id
club_templates.id
Cascade on delete
clubs_ibfk_2
clubs.branchcode
branches.branchcode
Restrict delete
aqbookseller_interfaces_ibfk_1
aqbookseller_interfaces.vendor_id
aqbooksellers.id
Cascade on delete
additional_contents_branchcode_ibfk
additional_contents.branchcode
branches.branchcode
Cascade on delete
borrowernumber_fk
additional_contents.borrowernumber
borrowers.borrowernumber
Null on delete
borrower_message_preferences_ibfk_3
borrower_message_preferences.categorycode
categories.categorycode
Cascade on delete
borrower_message_preferences_ibfk_1
borrower_message_preferences.borrowernumber
borrowers.borrowernumber
Cascade on delete
borrower_message_preferences_ibfk_2
borrower_message_preferences.message_attribute_id
message_attributes.message_attribute_id
Cascade on delete
aqbooksellers_ibfk_1
aqbooksellers.listprice
currency.currency
Cascade on delete
aqbooksellers_ibfk_2
aqbooksellers.invoiceprice
currency.currency
Cascade on delete
reviews_ibfk_2
reviews.biblionumber
biblio.biblionumber
Cascade on delete
reviews_ibfk_1
reviews.borrowernumber
borrowers.borrowernumber
Null on delete
booksellerid_aqcontacts_fk
aqcontacts.booksellerid
aqbooksellers.id
Cascade on delete
collections_ibfk_1
collections.colBranchcode
branches.branchcode
Cascade on delete
suggestions_ibfk_acceptedby
suggestions.acceptedby
borrowers.borrowernumber
Null on delete
suggestions_ibfk_managedby
suggestions.managedby
borrowers.borrowernumber
Null on delete
suggestions_ibfk_branchcode
suggestions.branchcode
branches.branchcode
Null on delete
suggestions_ibfk_biblionumber
suggestions.biblionumber
biblio.biblionumber
Null on delete
suggestions_ibfk_rejectedby
suggestions.rejectedby
borrowers.borrowernumber
Null on delete
suggestions_ibfk_suggestedby
suggestions.suggestedby
borrowers.borrowernumber
Null on delete
suggestions_budget_id_fk
suggestions.budgetid
aqbudgets.budget_id
Null on delete
suggestions_ibfk_lastmodificationby
suggestions.lastmodificationby
borrowers.borrowernumber
Null on delete
hold_fill_targets_ibfk_4
hold_fill_targets.source_branchcode
branches.branchcode
Cascade on delete
hold_fill_targets_ibfk_3
hold_fill_targets.itemnumber
items.itemnumber
Cascade on delete
hold_fill_targets_ibfk_2
hold_fill_targets.biblionumber
biblio.biblionumber
Cascade on delete
hold_fill_targets_ibfk_1
hold_fill_targets.borrowernumber
borrowers.borrowernumber
Cascade on delete
efk_branchcode
edifact_ean.branchcode
branches.branchcode
Restrict delete
course_reserves_ibfk_2
course_reserves.ci_id
course_items.ci_id
Cascade on delete
course_reserves_ibfk_1
course_reserves.course_id
courses.course_id
Restrict delete
club_enrollments_ibfk_1
club_enrollments.club_id
clubs.id
Cascade on delete
club_enrollments_ibfk_3
club_enrollments.branchcode
branches.branchcode
Null on delete
club_enrollments_ibfk_2
club_enrollments.borrowernumber
borrowers.borrowernumber
Cascade on delete
aqbudgetborrowers_ibfk_1
aqbudgetborrowers.budget_id
aqbudgets.budget_id
Cascade on delete
aqbudgetborrowers_ibfk_2
aqbudgetborrowers.borrowernumber
borrowers.borrowernumber
Cascade on delete
message_transports_ibfk_1
message_transports.message_attribute_id
message_attributes.message_attribute_id
Cascade on delete
message_transports_ibfk_2
message_transports.message_transport_type
message_transport_types.message_transport_type
Cascade on delete
shelfcontents_ibfk_2
virtualshelfcontents.biblionumber
biblio.biblionumber
Cascade on delete
shelfcontents_ibfk_3
virtualshelfcontents.borrowernumber
borrowers.borrowernumber
Null on delete
virtualshelfcontents_ibfk_1
virtualshelfcontents.shelfnumber
virtualshelves.shelfnumber
Cascade on delete
account_debit_types_branches_ibfk_2
account_debit_types_branches.branchcode
branches.branchcode
Cascade on delete
account_debit_types_branches_ibfk_1
account_debit_types_branches.debit_type_code
account_debit_types.code
Cascade on delete
curbside_pickup_issues_ibfk_1
curbside_pickup_issues.curbside_pickup_id
curbside_pickups.id
Cascade on delete
stockrotationstages_bifk
stockrotationstages.branchcode_id
branches.branchcode
Cascade on delete
stockrotationstages_rifk
stockrotationstages.rota_id
stockrotationrotas.rota_id
Cascade on delete
import_batches_ibfk_1
import_batches.profile_id
import_batch_profiles.id
Null on delete
aqorders_claims_ibfk_1
aqorders_claims.ordernumber
aqorders.ordernumber
Cascade on delete
transport_cost_ibfk_1
transport_cost.frombranch
branches.branchcode
Cascade on delete
transport_cost_ibfk_2
transport_cost.tobranch
branches.branchcode
Cascade on delete
issues_ibfk_2
issues.itemnumber
items.itemnumber
Restrict delete
issues_ibfk_1
issues.borrowernumber
borrowers.borrowernumber
Restrict delete
issues_ibfk_borrowers_borrowernumber
issues.issuer_id
borrowers.borrowernumber
Null on delete
houseboundrole_bnfk
housebound_role.borrowernumber_id
borrowers.borrowernumber
Cascade on delete
aqinvoices_fk_aqbooksellerid
aqinvoices.booksellerid
aqbooksellers.id
Cascade on delete
aqinvoices_fk_shipmentcost_budgetid
aqinvoices.shipmentcost_budgetid
aqbudgets.budget_id
Null on delete
edifact_msg_fk
aqinvoices.message_id
edifact_messages.id
Null on delete
curbside_pickup_policy_ibfk_1
curbside_pickup_policy.branchcode
branches.branchcode
Cascade on delete
erm_agreements_ibfk_1
erm_agreements.vendor_id
aqbooksellers.id
Null on delete

Check Constraints

Table Constraint Name Constraint