282 Foreign Key Constraints
Constraint Name | Child Column | Parent Column | Delete Rule | ||||
---|---|---|---|---|---|---|---|
borrower_files_ibfk_1 |
|
|
Cascade on delete | ||||
marc_subfield_structure_ibfk_1 |
|
|
Null on delete | ||||
linktracker_item_ibfk |
|
|
Null on delete | ||||
linktracker_biblio_ibfk |
|
|
Null on delete | ||||
linktracker_borrower_ibfk |
|
|
Null on delete | ||||
creator_batches_ibfk_3 |
|
|
Cascade on delete | ||||
creator_batches_ibfk_2 |
|
|
Cascade on delete | ||||
creator_batches_ibfk_1 |
|
|
Cascade on delete | ||||
old_reserves_ibfk_2 |
|
|
Null on delete | ||||
old_reserves_ibfk_1 |
|
|
Null on delete | ||||
old_reserves_ibfk_4 |
|
|
Null on delete | ||||
old_reserves_ibfk_3 |
|
|
Null on delete | ||||
import_records_ifbk_1 |
|
|
Cascade on delete | ||||
oai_sets_descriptions_ibfk_1 |
|
|
Cascade on delete | ||||
items_search_fields_authorised_values_category |
|
|
Null on delete | ||||
borrower_debarments_ibfk_1 |
|
|
Cascade on delete | ||||
club_template_fields_ibfk_1 |
|
|
Cascade on delete | ||||
club_enrollment_fields_ibfk_2 |
|
|
Cascade on delete | ||||
club_enrollment_fields_ibfk_1 |
|
|
Cascade on delete | ||||
borrower_discharges_ibfk1 |
|
|
Cascade on delete | ||||
recalls_ibfk_3 |
|
|
Cascade on delete | ||||
recalls_ibfk_2 |
|
|
Cascade on delete | ||||
recalls_ibfk_1 |
|
|
Cascade on delete | ||||
recalls_ibfk_4 |
|
|
Cascade on delete | ||||
afv_fk |
|
|
Cascade on delete | ||||
matcher_matchpoints_ifbk_1 |
|
|
Cascade on delete | ||||
matcher_matchpoints_ifbk_2 |
|
|
Cascade on delete | ||||
vfk_vendor_id |
|
|
Restrict delete | ||||
vfk_shipment_budget |
|
|
Restrict delete | ||||
branchtransfers_ibfk_2 |
|
|
Cascade on delete | ||||
branchtransfers_ibfk_3 |
|
|
Cascade on delete | ||||
branchtransfers_ibfk_1 |
|
|
Cascade on delete | ||||
borrower_macro_fk |
|
|
Cascade on delete | ||||
class_source_ibfk_1 |
|
|
Restrict delete | ||||
class_source_ibfk_2 |
|
|
Restrict delete | ||||
aqorder_users_ibfk_1 |
|
|
Cascade on delete | ||||
aqorder_users_ibfk_2 |
|
|
Cascade on delete | ||||
oai_sets_biblios_ibfk_2 |
|
|
Cascade on delete | ||||
clubs_holds_ibfk_3 |
|
|
Cascade on delete | ||||
clubs_holds_ibfk_2 |
|
|
Cascade on delete | ||||
clubs_holds_ibfk_1 |
|
|
Cascade on delete | ||||
aqbudgets_planning_ifbk_1 |
|
|
Cascade on delete | ||||
messages_ibfk_1 |
|
|
Null on delete | ||||
messages_borrowernumber |
|
|
Cascade on delete | ||||
r_guarantor |
|
|
Cascade on delete | ||||
r_guarantee |
|
|
Cascade on delete | ||||
account_offsets_ibfk_p |
|
|
Cascade on delete | ||||
account_offsets_ibfk_f |
|
|
Cascade on delete | ||||
aqinvoice_adjustments_fk_budget_id |
|
|
Null on delete | ||||
aqinvoice_adjustments_fk_invoiceid |
|
|
Cascade on delete | ||||
serial_ibfk_2 |
|
|
Cascade on delete | ||||
serial_ibfk_1 |
|
|
Cascade on delete | ||||
booksellerid_fk1 |
|
|
Cascade on delete | ||||
housebound_profile_bnfk |
|
|
Cascade on delete | ||||
tags_biblionumber_fk_1 |
|
|
Cascade on delete | ||||
tags_borrowers_fk_1 |
|
|
Null on delete | ||||
subscription_history_ibfk_2 |
|
|
Cascade on delete | ||||
subscription_history_ibfk_1 |
|
|
Cascade on delete | ||||
cash_register_actions_manager |
|
|
Cascade on delete | ||||
cash_register_actions_register |
|
|
Cascade on delete | ||||
illcomments_bnfk |
|
|
Cascade on delete | ||||
illcomments_ifk |
|
|
Cascade on delete | ||||
old_issues_ibfk_borrowers_borrowernumber |
|
|
Null on delete | ||||
old_issues_ibfk_1 |
|
|
Null on delete | ||||
old_issues_ibfk_2 |
|
|
Null on delete | ||||
illrequestattributes_ifk |
|
|
Cascade on delete | ||||
borrower_message_transport_preferences_ibfk_2 |
|
|
Cascade on delete | ||||
borrower_message_transport_preferences_ibfk_1 |
|
|
Cascade on delete | ||||
itemtypes_ibfk_1 |
|
|
Cascade on delete | ||||
library_smtp_servers_smtp_servers_fk |
|
|
Cascade on delete | ||||
library_smtp_servers_library_fk |
|
|
Cascade on delete | ||||
alert_ibfk_1 |
|
|
Cascade on delete | ||||
club_templates_ibfk_1 |
|
|
Cascade on delete | ||||
account_credit_types_branches_ibfk_1 |
|
|
Cascade on delete | ||||
account_credit_types_branches_ibfk_2 |
|
|
Cascade on delete | ||||
import_auths_ibfk_1 |
|
|
Cascade on delete | ||||
aqbudgetperiods_ibfk_1 |
|
|
Cascade on delete | ||||
library_groups_ibfk_1 |
|
|
Cascade on delete | ||||
library_groups_ibfk_2 |
|
|
Cascade on delete | ||||
matchpoint_component_norms_ifbk_1 |
|
|
Cascade on delete | ||||
virtualshelfshares_ibfk_2 |
|
|
Null on delete | ||||
virtualshelfshares_ibfk_1 |
|
|
Cascade on delete | ||||
aqbasket_ibfk_1 |
|
|
Restrict delete | ||||
aqbasket_ibfk_2 |
|
|
Restrict delete | ||||
aqbasket_ibfk_3 |
|
|
Restrict delete | ||||
aqbasket_ibfk_4 |
|
|
Null on delete | ||||
authorised_values_branches_ibfk_2 |
|
|
Cascade on delete | ||||
authorised_values_branches_ibfk_1 |
|
|
Cascade on delete | ||||
patronimage_fk1 |
|
|
Cascade on delete | ||||
borrower_attribute_types_ibfk_1 |
|
|
Restrict delete | ||||
matcher_matchchecks_ifbk_3 |
|
|
Cascade on delete | ||||
matcher_matchchecks_ifbk_2 |
|
|
Cascade on delete | ||||
matcher_matchchecks_ifbk_1 |
|
|
Cascade on delete | ||||
tags_approval_borrowers_fk_1 |
|
|
Null on delete | ||||
itemtypes_branches_ibfk_2 |
|
|
Cascade on delete | ||||
itemtypes_branches_ibfk_1 |
|
|
Cascade on delete | ||||
auth_tag_structure_ibfk_1 |
|
|
Cascade on delete | ||||
patron_consent_ibfk_1 |
|
|
Cascade on delete | ||||
aqbasketusers_ibfk_1 |
|
|
Cascade on delete | ||||
aqbasketusers_ibfk_2 |
|
|
Cascade on delete | ||||
aqbasketgroups_ibfk_1 |
|
|
Cascade on delete | ||||
illrequests_bnfk |
|
|
Cascade on delete | ||||
illrequests_safk |
|
|
Null on delete | ||||
illrequests_bcfk_2 |
|
|
Cascade on delete | ||||
course_items_ibfk_1 |
|
|
Cascade on delete | ||||
fk_course_items_biblionumber |
|
|
Cascade on delete | ||||
fk_course_items_homebranch_storage |
|
|
Cascade on delete | ||||
course_items_ibfk_2 |
|
|
Cascade on delete | ||||
fk_course_items_homebranch |
|
|
Cascade on delete | ||||
tmp_holdsqueue_ibfk_1 |
|
|
Cascade on delete | ||||
tmp_holdsqueue_ibfk_2 |
|
|
Cascade on delete | ||||
tmp_holdsqueue_ibfk_3 |
|
|
Cascade on delete | ||||
user_permissions_ibfk_1 |
|
|
Cascade on delete | ||||
user_permissions_ibfk_2 |
|
|
Cascade on delete | ||||
record_metadata_fk_1 |
|
|
Cascade on delete | ||||
houseboundvisit_bnfk_1 |
|
|
Cascade on delete | ||||
houseboundvisit_bnfk |
|
|
Cascade on delete | ||||
houseboundvisit_bnfk_2 |
|
|
Cascade on delete | ||||
clubs_holds_paton_holds_ibfk_3 |
|
|
Cascade on delete | ||||
clubs_holds_paton_holds_ibfk_2 |
|
|
Cascade on delete | ||||
clubs_holds_paton_holds_ibfk_1 |
|
|
Cascade on delete | ||||
tags_index_term_fk_1 |
|
|
Cascade on delete | ||||
tags_index_biblionumber_fk_1 |
|
|
Cascade on delete | ||||
subscriptionroutinglist_ibfk_1 |
|
|
Cascade on delete | ||||
subscriptionroutinglist_ibfk_2 |
|
|
Cascade on delete | ||||
branches_overdrive_ibfk_1 |
|
|
Cascade on delete | ||||
collectionst_ibfk_1 |
|
|
Cascade on delete | ||||
patron_lists_ibfk_1 |
|
|
Cascade on delete | ||||
course_instructors_ibfk_2 |
|
|
Restrict delete | ||||
course_instructors_ibfk_1 |
|
|
Cascade on delete | ||||
import_items_ibfk_1 |
|
|
Cascade on delete | ||||
reserves_ibfk_2 |
|
|
Cascade on delete | ||||
reserves_ibfk_1 |
|
|
Cascade on delete | ||||
reserves_ibfk_4 |
|
|
Cascade on delete | ||||
reserves_ibfk_3 |
|
|
Cascade on delete | ||||
reserves_ibfk_6 |
|
|
Null on delete | ||||
reserves_ibfk_5 |
|
|
Cascade on delete | ||||
borrower_attributes_ibfk_1 |
|
|
Cascade on delete | ||||
borrower_attributes_ibfk_2 |
|
|
Cascade on delete | ||||
fk_desks_branchcode |
|
|
Cascade on delete | ||||
categories_branches_ibfk_1 |
|
|
Cascade on delete | ||||
categories_branches_ibfk_2 |
|
|
Cascade on delete | ||||
pseudonymized_borrower_attributes_ibfk_1 |
|
|
Cascade on delete | ||||
anonymized_borrower_attributes_ibfk_2 |
|
|
Cascade on delete | ||||
special_holidays_ibfk_1 |
|
|
Cascade on delete | ||||
club_fields_ibfk_3 |
|
|
Cascade on delete | ||||
club_fields_ibfk_4 |
|
|
Cascade on delete | ||||
deletedrecord_metadata_fk_1 |
|
|
Cascade on delete | ||||
api_keys_fk_patron_id |
|
|
Cascade on delete | ||||
import_biblios_ibfk_1 |
|
|
Cascade on delete | ||||
authorised_values_authorised_values_category |
|
|
Cascade on delete | ||||
virtualshelves_ibfk_1 |
|
|
Null on delete | ||||
import_record_matches_ibfk_1 |
|
|
Cascade on delete | ||||
oai_sets_mappings_ibfk_1 |
|
|
Cascade on delete | ||||
aqorders_items_ibfk_1 |
|
|
Cascade on delete | ||||
accountlines_ibfk_borrowers_2 |
|
|
Null on delete | ||||
accountlines_ibfk_branches |
|
|
Null on delete | ||||
accountlines_ibfk_registers |
|
|
Null on delete | ||||
accountlines_ibfk_debit_type |
|
|
Restrict delete | ||||
accountlines_ibfk_borrowers |
|
|
Null on delete | ||||
accountlines_ibfk_items |
|
|
Null on delete | ||||
accountlines_ibfk_credit_type |
|
|
Restrict delete | ||||
article_requests_ibfk_3 |
|
|
Null on delete | ||||
article_requests_ibfk_4 |
|
|
Null on delete | ||||
article_requests_ibfk_5 |
|
|
Null on delete | ||||
article_requests_ibfk_1 |
|
|
Cascade on delete | ||||
article_requests_ibfk_2 |
|
|
Cascade on delete | ||||
auth_subfield_structure_ibfk_1 |
|
|
Cascade on delete | ||||
matchpoint_components_ifbk_1 |
|
|
Cascade on delete | ||||
cash_registers_branch |
|
|
Cascade on delete | ||||
ratings_ibfk_2 |
|
|
Cascade on delete | ||||
ratings_ibfk_1 |
|
|
Cascade on delete | ||||
messageq_ibfk_2 |
|
|
Restrict delete | ||||
messageq_ibfk_1 |
|
|
Cascade on delete | ||||
rc_items_ibfk |
|
|
Cascade on delete | ||||
rc_borrowers_ibfk |
|
|
Cascade on delete | ||||
rc_updated_by_ibfk |
|
|
Null on delete | ||||
rc_resolved_by_ibfk |
|
|
Null on delete | ||||
rc_created_by_ibfk |
|
|
Null on delete | ||||
stockrotationitems_sifk |
|
|
Cascade on delete | ||||
stockrotationitems_iifk |
|
|
Cascade on delete | ||||
serialitems_sfk_2 |
|
|
Cascade on delete | ||||
serialitems_sfk_1 |
|
|
Cascade on delete | ||||
biblioitems_ibfk_1 |
|
|
Cascade on delete | ||||
emfk_basketno |
|
|
Cascade on delete | ||||
emfk_vendor |
|
|
Cascade on delete | ||||
emfk_edi_acct |
|
|
Cascade on delete | ||||
matchpoints_ifbk_1 |
|
|
Cascade on delete | ||||
aqorders_subscriptionid |
|
|
Cascade on delete | ||||
aqorders_created_by |
|
|
Null on delete | ||||
aqorders_budget_id_fk |
|
|
Cascade on delete | ||||
aqorders_ibfk_3 |
|
|
Null on delete | ||||
aqorders_currency |
|
|
Null on delete | ||||
aqorders_ibfk_2 |
|
|
Null on delete | ||||
aqorders_ibfk_1 |
|
|
Cascade on delete | ||||
patron_list_patrons_ibfk_2 |
|
|
Cascade on delete | ||||
patron_list_patrons_ibfk_1 |
|
|
Cascade on delete | ||||
club_template_enrollment_fields_ibfk_1 |
|
|
Cascade on delete | ||||
subscription_ibfk_3 |
|
|
Cascade on delete | ||||
subscription_ibfk_1 |
|
|
Null on delete | ||||
subscription_ibfk_2 |
|
|
Null on delete | ||||
problem_reports_ibfk2 |
|
|
Cascade on delete | ||||
problem_reports_ibfk1 |
|
|
Cascade on delete | ||||
aqorders_transfers_ordernumber_to |
|
|
Null on delete | ||||
aqorders_transfers_ordernumber_from |
|
|
Null on delete | ||||
items_last_borrower_ibfk_1 |
|
|
Cascade on delete | ||||
items_last_borrower_ibfk_2 |
|
|
Cascade on delete | ||||
overduerules_fk |
|
|
Cascade on delete | ||||
mtt_fk |
|
|
Cascade on delete | ||||
borrowers_ibfk_2 |
|
|
Restrict delete | ||||
borrowers_ibfk_1 |
|
|
Restrict delete | ||||
borrowers_ibfk_3 |
|
|
Null on delete | ||||
repeatable_holidays_ibfk_1 |
|
|
Cascade on delete | ||||
message_transport_type_fk |
|
|
Cascade on delete | ||||
permissions_ibfk_1 |
|
|
Cascade on delete | ||||
borrower_attribute_types_branches_ibfk_1 |
|
|
Cascade on delete | ||||
borrower_attribute_types_branches_ibfk_2 |
|
|
Cascade on delete | ||||
circ_rules_ibfk_1 |
|
|
Cascade on delete | ||||
circ_rules_ibfk_2 |
|
|
Cascade on delete | ||||
circ_rules_ibfk_3 |
|
|
Cascade on delete | ||||
items_ibfk_1 |
|
|
Cascade on delete | ||||
items_ibfk_4 |
|
|
Cascade on delete | ||||
items_ibfk_2 |
|
|
Restrict delete | ||||
items_ibfk_3 |
|
|
Restrict delete | ||||
mmta_ibfk_1 |
|
|
Cascade on delete | ||||
bibliocoverimage_fk1 |
|
|
Cascade on delete | ||||
bibliocoverimage_fk2 |
|
|
Cascade on delete | ||||
search_marc_to_field_ibfk_2 |
|
|
Cascade on delete | ||||
search_marc_to_field_ibfk_1 |
|
|
Cascade on delete | ||||
clubs_ibfk_1 |
|
|
Cascade on delete | ||||
clubs_ibfk_2 |
|
|
Restrict delete | ||||
additional_contents_branchcode_ibfk |
|
|
Cascade on delete | ||||
borrowernumber_fk |
|
|
Null on delete | ||||
borrower_message_preferences_ibfk_3 |
|
|
Cascade on delete | ||||
borrower_message_preferences_ibfk_1 |
|
|
Cascade on delete | ||||
borrower_message_preferences_ibfk_2 |
|
|
Cascade on delete | ||||
aqbooksellers_ibfk_1 |
|
|
Cascade on delete | ||||
aqbooksellers_ibfk_2 |
|
|
Cascade on delete | ||||
reviews_ibfk_2 |
|
|
Cascade on delete | ||||
reviews_ibfk_1 |
|
|
Null on delete | ||||
booksellerid_aqcontacts_fk |
|
|
Cascade on delete | ||||
collections_ibfk_1 |
|
|
Cascade on delete | ||||
suggestions_ibfk_acceptedby |
|
|
Null on delete | ||||
suggestions_ibfk_managedby |
|
|
Null on delete | ||||
suggestions_ibfk_branchcode |
|
|
Null on delete | ||||
suggestions_ibfk_biblionumber |
|
|
Null on delete | ||||
suggestions_ibfk_rejectedby |
|
|
Null on delete | ||||
suggestions_ibfk_suggestedby |
|
|
Null on delete | ||||
suggestions_budget_id_fk |
|
|
Null on delete | ||||
suggestions_ibfk_lastmodificationby |
|
|
Null on delete | ||||
hold_fill_targets_ibfk_4 |
|
|
Cascade on delete | ||||
hold_fill_targets_ibfk_3 |
|
|
Cascade on delete | ||||
hold_fill_targets_ibfk_2 |
|
|
Cascade on delete | ||||
hold_fill_targets_ibfk_1 |
|
|
Cascade on delete | ||||
efk_branchcode |
|
|
Restrict delete | ||||
club_enrollments_ibfk_1 |
|
|
Cascade on delete | ||||
club_enrollments_ibfk_3 |
|
|
Null on delete | ||||
club_enrollments_ibfk_2 |
|
|
Cascade on delete | ||||
course_reserves_ibfk_2 |
|
|
Cascade on delete | ||||
course_reserves_ibfk_1 |
|
|
Restrict delete | ||||
aqbudgetborrowers_ibfk_1 |
|
|
Cascade on delete | ||||
aqbudgetborrowers_ibfk_2 |
|
|
Cascade on delete | ||||
message_transports_ibfk_1 |
|
|
Cascade on delete | ||||
message_transports_ibfk_2 |
|
|
Cascade on delete | ||||
shelfcontents_ibfk_2 |
|
|
Cascade on delete | ||||
shelfcontents_ibfk_3 |
|
|
Null on delete | ||||
virtualshelfcontents_ibfk_1 |
|
|
Cascade on delete | ||||
account_debit_types_branches_ibfk_2 |
|
|
Cascade on delete | ||||
account_debit_types_branches_ibfk_1 |
|
|
Cascade on delete | ||||
stockrotationstages_bifk |
|
|
Cascade on delete | ||||
stockrotationstages_rifk |
|
|
Cascade on delete | ||||
import_batches_ibfk_1 |
|
|
Null on delete | ||||
aqorders_claims_ibfk_1 |
|
|
Cascade on delete | ||||
transport_cost_ibfk_1 |
|
|
Cascade on delete | ||||
transport_cost_ibfk_2 |
|
|
Cascade on delete | ||||
houseboundrole_bnfk |
|
|
Cascade on delete | ||||
issues_ibfk_2 |
|
|
Restrict delete | ||||
issues_ibfk_1 |
|
|
Restrict delete | ||||
issues_ibfk_borrowers_borrowernumber |
|
|
Null on delete | ||||
aqinvoices_fk_aqbooksellerid |
|
|
Cascade on delete | ||||
aqinvoices_fk_shipmentcost_budgetid |
|
|
Null on delete | ||||
edifact_msg_fk |
|
|
Null on delete |
Check Constraints
Table | Constraint Name | Constraint |
---|