testsql_comments.testsql

378 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_branchcode

old_reserves.branchcode

branches.branchcode

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_usage_yus_ibfk_5

erm_usage_yus.item_id

erm_usage_items.item_id

Cascade on delete

erm_usage_yus_ibfk_4

erm_usage_yus.database_id

erm_usage_databases.database_id

Cascade on delete

erm_usage_yus_ibfk_1

erm_usage_yus.title_id

erm_usage_titles.title_id

Cascade on delete

erm_usage_yus_ibfk_3

erm_usage_yus.platform_id

erm_usage_platforms.platform_id

Cascade on delete

erm_usage_yus_ibfk_2

erm_usage_yus.usage_data_provider_id

erm_usage_data_providers.erm_usage_data_provider_id

Cascade on 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_3

ticket_updates.assignee_id

borrowers.borrowernumber

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

aqbookseller_issues_ibfk_1

aqbookseller_issues.vendor_id

aqbooksellers.id

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

erm_counter_files_ibfk_1

erm_counter_files.usage_data_provider_id

erm_usage_data_providers.erm_usage_data_provider_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

erm_usage_databases_ibfk_1

erm_usage_databases.usage_data_provider_id

erm_usage_data_providers.erm_usage_data_provider_id

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

library_hours_ibfk_1

library_hours.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

erm_usage_items_ibfk_1

erm_usage_items.usage_data_provider_id

erm_usage_data_providers.erm_usage_data_provider_id

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

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

preservation_processing_attributes_ibfk_1

preservation_processing_attributes.processing_id

preservation_processings.processing_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

preservation_processing_attributes_items_ibfk_2

preservation_processing_attributes_items.train_item_id

preservation_trains_items.train_item_id

Cascade on delete

preservation_processing_attributes_items_ibfk_1

preservation_processing_attributes_items.processing_attribute_id

preservation_processing_attributes.processing_attribute_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

FK_import_oai_biblios_1

import_oai_biblios.biblionumber

biblio.biblionumber

Cascade 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

illbatches_sfk

illbatches.status_code

illbatch_statuses.code

Null on delete

illbatches_bcfk

illbatches.library_id

branches.branchcode

Null on delete

illbatches_bnfk

illbatches.patron_id

borrowers.borrowernumber

Null 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_ibfk

illrequests.batch_id

illbatches.ill_batch_id

Null 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_2

biblio_metadata.record_source_id

record_sources.record_source_id

Restrict 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

Null 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

bookings_ibfk_1

bookings.patron_id

borrowers.borrowernumber

Cascade on delete

bookings_ibfk_3

bookings.item_id

items.itemnumber

Cascade on delete

bookings_ibfk_2

bookings.biblio_id

biblio.biblionumber

Cascade on delete

bookings_ibfk_4

bookings.pickup_library_id

branches.branchcode

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_2

deletedbiblio_metadata.record_source_id

record_sources.record_source_id

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

erm_usage_platforms_ibfk_1

erm_usage_platforms.usage_data_provider_id

erm_usage_data_providers.erm_usage_data_provider_id

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

marc_ordering_account_ibfk_2

marc_order_accounts.budget_id

aqbudgets.budget_id

Cascade on delete

marc_ordering_account_ibfk_1

marc_order_accounts.vendor_id

aqbooksellers.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_old_issues

accountlines.old_issue_id

old_issues.issue_id

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_issues

accountlines.issue_id

issues.issue_id

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_4

tickets.assignee_id

borrowers.borrowernumber

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

erm_usage_mus_ibfk_3

erm_usage_mus.platform_id

erm_usage_platforms.platform_id

Cascade on delete

erm_usage_mus_ibfk_2

erm_usage_mus.usage_data_provider_id

erm_usage_data_providers.erm_usage_data_provider_id

Cascade on delete

erm_usage_mus_ibfk_1

erm_usage_mus.title_id

erm_usage_titles.title_id

Cascade on delete

erm_usage_mus_ibfk_5

erm_usage_mus.item_id

erm_usage_items.item_id

Cascade on delete

erm_usage_mus_ibfk_4

erm_usage_mus.database_id

erm_usage_databases.database_id

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

FK_import_oai_authorities_1

import_oai_authorities.authid

auth_header.authid

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

Null 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_4

subscription.aqbooksellerid

aqbooksellers.id

Null 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

erm_usage_titles_ibfk_1

erm_usage_titles.usage_data_provider_id

erm_usage_data_providers.erm_usage_data_provider_id

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

additional_contents_localizations_ibfk1

additional_contents_localizations.additional_content_id

additional_contents.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

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

erm_counter_log_ibfk_1

erm_counter_logs.borrowernumber

borrowers.borrowernumber

Cascade on delete

erm_counter_log_ibfk_2

erm_counter_logs.counter_files_id

erm_counter_files.erm_counter_files_id

Cascade on delete

erm_counter_log_ibfk_3

erm_counter_logs.usage_data_provider_id

erm_usage_data_providers.erm_usage_data_provider_id

Cascade 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

preservation_trains_ibfk_1

preservation_trains.default_processing_id

preservation_processings.processing_id

Null 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

preservation_item_ibfk_1

preservation_trains_items.train_id

preservation_trains.train_id

Cascade on delete

preservation_item_ibfk_3

preservation_trains_items.processing_id

preservation_processings.processing_id

Null on delete

preservation_item_ibfk_2

preservation_trains_items.item_id

items.itemnumber

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