Constraints

97 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

config_remote_account_owner_fkey

remote_account.owner

Cascade on delete

config_marc_subfield_owner_fkey

marc_subfield.owner

Restrict delete

marc_subfield_marc_format_fkey

marc_subfield.marc_format

Restrict delete

marc_subfield_value_ctype_fkey

marc_subfield.value_ctype

record_attr_definition.name

Restrict delete

circ_matrix_limit_set_map_matchpoint_fkey

circ_matrix_limit_set_map.matchpoint

circ_matrix_matchpoint.id

Cascade on delete

circ_matrix_limit_set_map_limit_set_fkey

circ_matrix_limit_set_map.limit_set

circ_limit_set.id

Cascade on delete

copy_tag_type_owner_fkey

copy_tag_type.owner

Restrict delete

cpt_owner_fkey

print_template.owner

Restrict delete

print_template_locale_fkey

print_template.locale

i18n_locale.code

Restrict delete

config_barcode_completion_org_unit_fkey

barcode_completion.org_unit

Cascade on delete

workstation_setting_type_grp_fkey

workstation_setting_type.grp

settings_group.name

Restrict delete

marc_field_marc_format_fkey

marc_field.marc_format

Restrict delete

config_marc_field_owner_fkey

marc_field.owner

Restrict delete

coded_value_map_ctype_fkey

coded_value_map.ctype

record_attr_definition.name

Cascade on delete

hold_matrix_matchpoint_item_owning_ou_fkey

hold_matrix_matchpoint.item_owning_ou

Restrict delete

hold_matrix_matchpoint_requestor_grp_fkey

hold_matrix_matchpoint.requestor_grp

Restrict delete

hold_matrix_matchpoint_usr_grp_fkey

hold_matrix_matchpoint.usr_grp

Restrict delete

hold_matrix_matchpoint_pickup_ou_fkey

hold_matrix_matchpoint.pickup_ou

Restrict delete

hold_matrix_matchpoint_user_home_ou_fkey

hold_matrix_matchpoint.user_home_ou

Restrict delete

hold_matrix_matchpoint_age_hold_protect_rule_fkey

hold_matrix_matchpoint.age_hold_protect_rule

rule_age_hold_protect.id

Restrict delete

hold_matrix_matchpoint_item_circ_ou_fkey

hold_matrix_matchpoint.item_circ_ou

Restrict delete

hold_matrix_matchpoint_request_ou_fkey

hold_matrix_matchpoint.request_ou

Restrict delete

hold_matrix_matchpoint_transit_range_fkey

hold_matrix_matchpoint.transit_range

org_unit_type.id

Restrict delete

hold_matrix_matchpoint_circ_modifier_fkey

hold_matrix_matchpoint.circ_modifier

circ_modifier.code

Restrict delete

circ_limit_set_circ_mod_map_circ_mod_fkey

circ_limit_set_circ_mod_map.circ_mod

circ_modifier.code

Cascade on delete

circ_limit_set_circ_mod_map_limit_set_fkey

circ_limit_set_circ_mod_map.limit_set

circ_limit_set.id

Cascade on delete

config_billing_type_owner_fkey

billing_type.owner

Cascade on delete

marc21_physical_characteristic_value_map_ptype_subfield_fkey

marc21_physical_characteristic_value_map.ptype_subfield

marc21_physical_characteristic_subfield_map.id

Restrict delete

metabib_field_ts_map_ts_config_fkey

metabib_field_ts_map.ts_config

ts_config_list.id

Restrict delete

metabib_field_ts_map_metabib_field_fkey

metabib_field_ts_map.metabib_field

metabib_field.id

Restrict delete

metabib_search_alias_field_class_fkey

metabib_search_alias.field_class

metabib_class.name

Restrict delete

metabib_search_alias_field_fkey

metabib_search_alias.field

metabib_field.id

Restrict delete

z3950_source_creds_owner_fkey

z3950_source_credentials.owner

Cascade on delete

z3950_source_credentials_source_fkey

z3950_source_credentials.source

z3950_source.name

Cascade on delete

circ_matrix_matchpoint_duration_rule_fkey

circ_matrix_matchpoint.duration_rule

rule_circ_duration.id

Restrict delete

circ_matrix_matchpoint_grp_fkey

circ_matrix_matchpoint.grp

Restrict delete

circ_matrix_matchpoint_org_unit_fkey

circ_matrix_matchpoint.org_unit

Restrict delete

circ_matrix_matchpoint_circ_modifier_fkey

circ_matrix_matchpoint.circ_modifier

circ_modifier.code

Restrict delete

circ_matrix_matchpoint_copy_owning_lib_fkey

circ_matrix_matchpoint.copy_owning_lib

Restrict delete

circ_matrix_matchpoint_user_home_ou_fkey

circ_matrix_matchpoint.user_home_ou

Restrict delete

circ_matrix_matchpoint_recurring_fine_rule_fkey

circ_matrix_matchpoint.recurring_fine_rule

rule_recurring_fine.id

Restrict delete

circ_matrix_matchpoint_hard_due_date_fkey

circ_matrix_matchpoint.hard_due_date

hard_due_date.id

Restrict delete

circ_matrix_matchpoint_copy_circ_lib_fkey

circ_matrix_matchpoint.copy_circ_lib

Restrict delete

circ_matrix_matchpoint_max_fine_rule_fkey

circ_matrix_matchpoint.max_fine_rule

rule_max_fine.id

Restrict delete

circ_matrix_matchpoint_copy_location_fkey

circ_matrix_matchpoint.copy_location

copy_location.id

Restrict delete

use_perm_fkey

z3950_source.use_perm

Restrict delete

usr_setting_type_grp_fkey

usr_setting_type.grp

settings_group.name

Restrict delete

marc21_physical_characteristic_subfield_map_ptype_key_fkey

marc21_physical_characteristic_subfield_map.ptype_key

marc21_physical_characteristic_type_map.ptype_key

Cascade on delete

idl_field_doc_owner_fkey

idl_field_doc.owner

Cascade on delete

remoteauth_profile_usr_activity_type_fkey

remoteauth_profile.usr_activity_type

usr_activity_type.id

Restrict delete

remoteauth_profile_perm_fkey

remoteauth_profile.perm

Restrict delete

remoteauth_profile_context_org_fkey

remoteauth_profile.context_org

Cascade on delete

record_attr_index_norm_map_norm_fkey

record_attr_index_norm_map.norm

index_normalizer.id

Cascade on delete

record_attr_index_norm_map_attr_fkey

record_attr_index_norm_map.attr

record_attr_definition.name

Cascade on delete

filter_dialog_filter_set_interface_fkey

filter_dialog_filter_set.interface

filter_dialog_interface.key

Restrict delete

config_filter_dialog_filter_set_creator_fkey

filter_dialog_filter_set.creator

usr.id

Cascade on delete

config_filter_dialog_filter_set_owning_lib_fkey

filter_dialog_filter_set.owning_lib

Cascade on delete

circ_limit_set_group_map_limit_group_fkey

circ_limit_set_group_map.limit_group

circ_limit_group.id

Cascade on delete

circ_limit_set_group_map_limit_set_fkey

circ_limit_set_group_map.limit_set

circ_limit_set.id

Cascade on delete

floating_group_member_org_unit_fkey

floating_group_member.org_unit

Restrict delete

floating_group_member_floating_group_fkey

floating_group_member.floating_group

floating_group.id

Restrict delete

weight_assoc_hold_weights_fkey

weight_assoc.hold_weights

hold_matrix_weights.id

Null on delete

weight_assoc_org_unit_fkey

weight_assoc.org_unit

Cascade on delete

weight_assoc_circ_weights_fkey

weight_assoc.circ_weights

circ_matrix_weights.id

Null on delete

cgs_owner_fkey

geolocation_service.owner

Restrict delete

hard_due_date_values_hard_due_date_fkey

hard_due_date_values.hard_due_date

hard_due_date.id

Restrict delete

z3950_index_field_map_metabib_field_fkey

z3950_index_field_map.metabib_field

metabib_field.id

Restrict delete

z3950_index_field_map_z3950_attr_fkey

z3950_index_field_map.z3950_attr

Restrict delete

z3950_index_field_map_record_attr_fkey

z3950_index_field_map.record_attr

record_attr_definition.name

Restrict delete

i18n_core_translation_fkey

i18n_core.translation

i18n_locale.code

Cascade on delete

circ_limit_set_copy_loc_map_limit_set_fkey

circ_limit_set_copy_loc_map.limit_set

circ_limit_set.id

Cascade on delete

circ_limit_set_copy_loc_map_copy_loc_fkey

circ_limit_set_copy_loc_map.copy_loc

copy_location.id

Cascade on delete

z3950_attr_source_fkey

z3950_attr.source

z3950_source.name

Cascade on delete

metabib_field_field_class_fkey

metabib_field.field_class

metabib_class.name

Restrict delete

metabib_field_format_fkey

metabib_field.format

xml_transform.name

Restrict delete

cusppe_owner_fkey

ui_staff_portal_page_entry.owner

Cascade on delete

cusppe_entry_type_fkey

ui_staff_portal_page_entry.entry_type

ui_staff_portal_page_entry_type.code

Cascade on delete

record_attr_definition_format_fkey

record_attr_definition.format

xml_transform.name

Cascade on delete

record_attr_definition_phys_char_sf_fkey

record_attr_definition.phys_char_sf

marc21_physical_characteristic_subfield_map.id

Restrict delete

metabib_field_index_norm_map_norm_fkey

metabib_field_index_norm_map.norm

index_normalizer.id

Cascade on delete

metabib_field_index_norm_map_field_fkey

metabib_field_index_norm_map.field

metabib_field.id

Cascade on delete

metabib_field_virtual_map_virtual_fkey

metabib_field_virtual_map.virtual

metabib_field.id

Restrict delete

metabib_field_virtual_map_real_fkey

metabib_field_virtual_map.real

metabib_field.id

Restrict delete

org_unit_setting_type_grp_fkey

org_unit_setting_type.grp

settings_group.name

Restrict delete

update_perm_fkey

org_unit_setting_type.update_perm

Restrict delete

view_perm_fkey

org_unit_setting_type.view_perm

Restrict delete

openathens_identity_unique_identifier_fkey

openathens_identity.unique_identifier

openathens_uid_field.id

Restrict delete

config_openathens_identity_ou_fkey

openathens_identity.org_unit

Cascade on delete

openathens_identity_display_name_fkey

openathens_identity.display_name

openathens_name_field.id

Restrict delete

copy_alert_type_scope_org_fkey

copy_alert_type.scope_org

Cascade on delete

display_field_map_field_fkey

display_field_map.field

metabib_field.id

Restrict delete

config_org_unit_setting_type_log_fkey

org_unit_setting_type_log.org

Cascade on delete

org_unit_setting_type_log_field_name_fkey

org_unit_setting_type_log.field_name

org_unit_setting_type.name

Restrict delete

circ_limit_set_owning_lib_fkey

circ_limit_set.owning_lib

Restrict delete

composite_attr_entry_definition_coded_value_fkey

composite_attr_entry_definition.coded_value

coded_value_map.id

Cascade on delete

metabib_class_ts_map_field_class_fkey

metabib_class_ts_map.field_class

metabib_class.name

Restrict delete

metabib_class_ts_map_ts_config_fkey

metabib_class_ts_map.ts_config

ts_config_list.id

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
marc_subfield	config_standard_marc_subfields_are_fully_specified	(((owner IS NOT NULL) OR ((owner IS NULL) AND (repeatable IS NOT NULL) AND (mandatory IS NOT NULL) AND (hidden IS NOT NULL))))
rule_max_fine	rule_max_fine_name_check	((name ~ '^\w+$'::text))
workstation_setting_type	cwst_no_empty_link	((((datatype = 'link'::text) AND (fm_class IS NOT NULL)) OR ((datatype <> 'link'::text) AND (fm_class IS NULL))))
workstation_setting_type	cwst_valid_datatype	((datatype = ANY (ARRAY['bool'::text, 'integer'::text, 'float'::text, 'currency'::text, 'interval'::text, 'date'::text, 'string'::text, 'object'::text, 'array'::text, 'link'::text])))
marc_field	config_standard_marc_tags_are_fully_specified	(((owner IS NOT NULL) OR ((owner IS NULL) AND (repeatable IS NOT NULL) AND (mandatory IS NOT NULL) AND (hidden IS NOT NULL))))
rule_age_hold_protect	rule_age_hold_protect_name_check	((name ~ '^\w+$'::text))
metabib_field_ts_map	metabib_field_ts_map_index_weight_check	((index_weight = ANY (ARRAY['A'::bpchar, 'B'::bpchar, 'C'::bpchar, 'D'::bpchar])))
rule_circ_duration	rule_circ_duration_name_check	((name ~ '^\w+$'::text))
best_hold_order	best_hold_order_check	(((pprox IS NOT NULL) OR (hprox IS NOT NULL) OR (owning_lib_to_home_lib_prox IS NOT NULL) OR (aprox IS NOT NULL) OR (priority IS NOT NULL) OR (cut IS NOT NULL) OR (depth IS NOT NULL) OR (htime IS NOT NULL) OR (rtime IS NOT NULL)))
usr_setting_type	coust_no_empty_link	((((datatype = 'link'::text) AND (fm_class IS NOT NULL)) OR ((datatype <> 'link'::text) AND (fm_class IS NULL))))
usr_setting_type	coust_valid_datatype	((datatype = ANY (ARRAY['bool'::text, 'integer'::text, 'float'::text, 'currency'::text, 'interval'::text, 'date'::text, 'string'::text, 'object'::text, 'array'::text, 'link'::text])))
filter_dialog_filter_set	config_filter_dialog_filter_set_filters_check	(is_json(filters))
z3950_index_field_map	attr_or_attr_type	(((z3950_attr IS NOT NULL) OR (z3950_attr_type IS NOT NULL)))
z3950_index_field_map	metabib_field_or_record_attr	(((metabib_field IS NOT NULL) OR (record_attr IS NOT NULL)))
rule_recurring_fine	rule_recurring_fine_name_check	((name ~ '^\w+$'::text))
usr_activity_type	one_of_wwh	((COALESCE(ewho, ewhat, ehow) IS NOT NULL))
org_unit_setting_type	coust_no_empty_link	((((datatype = 'link'::text) AND (fm_class IS NOT NULL)) OR ((datatype <> 'link'::text) AND (fm_class IS NULL))))
org_unit_setting_type	coust_valid_datatype	((datatype = ANY (ARRAY['bool'::text, 'integer'::text, 'float'::text, 'currency'::text, 'interval'::text, 'date'::text, 'string'::text, 'object'::text, 'array'::text, 'link'::text])))
bib_source	bib_source_quality_check	(((quality >= 0) AND (quality <= 100)))
metabib_class_ts_map	metabib_class_ts_map_index_weight_check	((index_weight = ANY (ARRAY['A'::bpchar, 'B'::bpchar, 'C'::bpchar, 'D'::bpchar])))