Constraints

222 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
borrower_files_ibfk_1
borrower_files.borrowernumber
borrowers.borrowernumber
Cascade 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
import_records_ifbk_1
import_records.import_batch_id
import_batches.import_batch_id
Cascade 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
club_template_fields_ibfk_1
club_template_fields.club_template_id
club_templates.id
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
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
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
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
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
account_offsets_ibfk_t
account_offsets.type
account_offset_types.type
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
branch_item_rules_ibfk_1
branch_item_rules.itemtype
itemtypes.itemtype
Cascade on delete
branch_item_rules_ibfk_2
branch_item_rules.branchcode
branches.branchcode
Cascade on delete
booksellerid_fk1
aqcontract.booksellerid
aqbooksellers.id
Cascade on delete
default_branch_item_rules_ibfk_1
default_branch_item_rules.itemtype
itemtypes.itemtype
Cascade on delete
housebound_profile_bnfk
housebound_profile.borrowernumber
borrowers.borrowernumber
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
opac_news_branchcode_ibfk
opac_news.branchcode
branches.branchcode
Cascade on delete
borrowernumber_fk
opac_news.borrowernumber
borrowers.borrowernumber
Null 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_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
club_templates_ibfk_1
club_templates.branchcode
branches.branchcode
Cascade on delete
import_auths_ibfk_1
import_auths.import_record_id
import_records.import_record_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
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
auth_tag_structure_ibfk_1
auth_tag_structure.authtypecode
auth_types.authtypecode
Cascade on delete
default_branch_circ_rules_ibfk_1
default_branch_circ_rules.branchcode
branches.branchcode
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
course_items_ibfk_1
course_items.itemnumber
items.itemnumber
Cascade on delete
course_items_ibfk_2
course_items.holdingbranch
branches.branchcode
Cascade on delete
tmp_holdsqueue_ibfk_1
tmp_holdsqueue.itemnumber
items.itemnumber
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
record_metadata_fk_1
biblio_metadata.biblionumber
biblio.biblionumber
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
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
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_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_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
categories_branches_ibfk_1
categories_branches.categorycode
categories.categorycode
Cascade on delete
categories_branches_ibfk_2
categories_branches.branchcode
branches.branchcode
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
deletedrecord_metadata_fk_1
deletedbiblio_metadata.biblionumber
deletedbiblio.biblionumber
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_borrowers
accountlines.borrowernumber
borrowers.borrowernumber
Null on delete
accountlines_ibfk_items
accountlines.itemnumber
items.itemnumber
Null on 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_1
article_requests.borrowernumber
borrowers.borrowernumber
Cascade on delete
article_requests_ibfk_2
article_requests.biblionumber
biblio.biblionumber
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
ratings_ibfk_2
ratings.biblionumber
biblio.biblionumber
Cascade on delete
ratings_ibfk_1
ratings.borrowernumber
borrowers.borrowernumber
Cascade 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
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
matchpoints_ifbk_1
matchpoints.matcher_id
marc_matchers.matcher_id
Cascade 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_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_1
subscription.periodicity
subscription_frequencies.id
Null on delete
subscription_ibfk_2
subscription.numberpattern
subscription_numberpatterns.id
Null 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
message_transport_type_fk
letter.message_transport_type
message_transport_types.message_transport_type
Cascade on delete
permissions_ibfk_1
permissions.module_bit
userflags.bit
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
clubs_ibfk_1
clubs.club_template_id
club_templates.id
Cascade on delete
clubs_ibfk_2
clubs.branchcode
branches.branchcode
Restrict delete
bibliocoverimage_fk1
biblioimages.biblionumber
biblio.biblionumber
Cascade 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
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
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
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
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
stockrotationstages_bifk
stockrotationstages.branchcode_id
branches.branchcode
Cascade on delete
stockrotationstages_rifk
stockrotationstages.rota_id
stockrotationrotas.rota_id
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
houseboundrole_bnfk
housebound_role.borrowernumber_id
borrowers.borrowernumber
Cascade on delete
issues_ibfk_2
issues.itemnumber
items.itemnumber
Restrict delete
issues_ibfk_1
issues.borrowernumber
borrowers.borrowernumber
Restrict 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

Check Constraints

Table Constraint Name Constraint
None detected