Constraints

79 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

usr_setting_usr_fkey

usr_setting.usr

usr.id

Cascade on delete

usr_setting_name_fkey

usr_setting.name

usr_setting_type.name

Cascade on delete

usr_activity_etype_fkey

usr_activity.etype

usr_activity_type.id

Restrict delete

usr_activity_usr_fkey

usr_activity.usr

usr.id

Null on delete

actor_stat_cat_owner_fkey

Cascade on delete

stat_cat_sip_field_fkey

stat_cat.sip_field

stat_cat_sip_fields.field

Null on delete

search_filter_group_entry_grp_fkey

search_filter_group_entry.grp

search_filter_group.id

Cascade on delete

search_filter_group_entry_query_fkey

search_filter_group_entry.query

search_query.id

Cascade on delete

actor_sceum_tu_fkey

stat_cat_entry_usr_map.target_usr

usr.id

Cascade on delete

actor_sceum_sc_fkey

stat_cat_entry_usr_map.stat_cat

Restrict delete

toolbar_ws_fkey

Cascade on delete

toolbar_org_fkey

Cascade on delete

toolbar_usr_fkey

usr.id

Cascade on delete

card_usr_fkey

card.usr

usr.id

Restrict delete

usr_standing_penalty_org_unit_fkey

usr_standing_penalty.org_unit

Cascade on delete

usr_standing_penalty_standing_penalty_fkey

usr_standing_penalty.standing_penalty

standing_penalty.id

Cascade on delete

usr_standing_penalty_usr_message_fkey

usr_standing_penalty.usr_message

Restrict delete

usr_standing_penalty_usr_fkey

usr_standing_penalty.usr

usr.id

Cascade on delete

usr_standing_penalty_staff_fkey

usr_standing_penalty.staff

usr.id

Null on delete

org_lasso_map_lasso_fkey

org_lasso_map.lasso

Cascade on delete

org_lasso_map_org_unit_fkey

org_lasso_map.org_unit

Cascade on delete

copy_alert_suppress_alert_type_fkey

copy_alert_suppress.alert_type

copy_alert_type.id

Cascade on delete

copy_alert_suppress_org_fkey

copy_alert_suppress.org

Cascade on delete

usr_address_usr_fkey

usr_address.usr

usr.id

Restrict delete

usr_address_replaces_fkey

usr_address.replaces

Restrict delete

usr_org_unit_opt_in_usr_fkey

usr_org_unit_opt_in.usr

usr.id

Restrict delete

usr_org_unit_opt_in_staff_fkey

usr_org_unit_opt_in.staff

usr.id

Restrict delete

usr_org_unit_opt_in_opt_in_ws_fkey

usr_org_unit_opt_in.opt_in_ws

Restrict delete

usr_org_unit_opt_in_org_unit_fkey

usr_org_unit_opt_in.org_unit

Restrict delete

actor_org_unit_ill_address_fkey

org_unit.ill_address

Restrict delete

actor_org_unit_mailing_address_fkey

org_unit.mailing_address

Restrict delete

org_unit_fiscal_calendar_fkey

org_unit.fiscal_calendar

fiscal_calendar.id

Restrict delete

org_unit_parent_ou_fkey

org_unit.parent_ou

Restrict delete

org_unit_ou_type_fkey

org_unit.ou_type

org_unit_type.id

Restrict delete

actor_org_unit_holds_address_fkey

org_unit.holds_address

Restrict delete

actor_org_unit_billing_address_fkey

org_unit.billing_address

Restrict delete

usr_privacy_waiver_usr_fkey

usr_privacy_waiver.usr

usr.id

Cascade on delete

org_unit_closed_emergency_closing_fkey

org_unit_closed.emergency_closing

emergency_closing.id

Restrict delete

org_unit_closed_org_unit_fkey

org_unit_closed.org_unit

Restrict delete

workstation_owning_lib_fkey

workstation.owning_lib

Restrict delete

org_address_org_unit_fkey

org_address.org_unit

Restrict delete

passwd_usr_fkey

usr.id

Cascade on delete

passwd_passwd_type_fkey

passwd.passwd_type

passwd_type.code

Restrict delete

usr_password_reset_usr_fkey

usr_password_reset.usr

usr.id

Restrict delete

org_unit_proximity_adjustment_hold_request_lib_fkey

org_unit_proximity_adjustment.hold_request_lib

Restrict delete

actor_org_unit_proximity_copy_location_fkey

org_unit_proximity_adjustment.copy_location

copy_location.id

Restrict delete

org_unit_proximity_adjustment_item_owning_lib_fkey

org_unit_proximity_adjustment.item_owning_lib

Restrict delete

actor_org_unit_proximity_adjustment_circ_mod_fkey

org_unit_proximity_adjustment.circ_mod

circ_modifier.code

Restrict delete

org_unit_proximity_adjustment_hold_pickup_lib_fkey

org_unit_proximity_adjustment.hold_pickup_lib

Restrict delete

org_unit_proximity_adjustment_item_circ_lib_fkey

org_unit_proximity_adjustment.item_circ_lib

Restrict delete

org_unit_type_parent_fkey

org_unit_type.parent

org_unit_type.id

Restrict delete

actor_stat_cat_entry_stat_cat_fkey

stat_cat_entry.stat_cat

Cascade on delete

actor_stat_cat_entry_owner_fkey

stat_cat_entry.owner

Cascade on delete

org_unit_setting_name_fkey

org_unit_setting.name

org_unit_setting_type.name

Restrict delete

org_unit_setting_org_unit_fkey

org_unit_setting.org_unit

Cascade on delete

workstation_setting_name_fkey

workstation_setting.name

workstation_setting_type.name

Cascade on delete

workstation_setting_workstation_fkey

workstation_setting.workstation

Cascade on delete

usr_message_sending_lib_fkey

usr_message.sending_lib

Restrict delete

usr_message_usr_fkey

usr_message.usr

usr.id

Restrict delete

usr_message_editor_fkey

usr_message.editor

usr.id

Restrict delete

hours_of_operation_id_fkey

hours_of_operation.id

Cascade on delete

search_filter_group_owner_fkey

search_filter_group.owner

Cascade on delete

stat_cat_entry_default_stat_cat_entry_fkey

stat_cat_entry_default.stat_cat_entry

stat_cat_entry.id

Cascade on delete

stat_cat_entry_default_owner_fkey

stat_cat_entry_default.owner

Cascade on delete

stat_cat_entry_default_stat_cat_fkey

stat_cat_entry_default.stat_cat

Cascade on delete

actor_usr_mailing_address_fkey

usr.mailing_address

Restrict delete

actor_usr_home_ou_fkey

usr.home_ou

Restrict delete

usr_net_access_level_fkey

usr.net_access_level

net_access_level.id

Restrict delete

usr_standing_fkey

usr.standing

Restrict delete

usr_locale_fkey

usr.locale

i18n_locale.code

Restrict delete

usr_ident_type2_fkey

usr.ident_type2

identification_type.id

Restrict delete

actor_usr_profile_fkey

usr.profile

Restrict delete

actor_usr_billing_address_fkey

usr.billing_address

Restrict delete

usr_ident_type_fkey

usr.ident_type

identification_type.id

Restrict delete

address_alert_owner_fkey

address_alert.owner

Restrict delete

usr_saved_search_owner_fkey

usr_saved_search.owner

usr.id

Cascade on delete

org_unit_custom_tree_node_org_unit_fkey

org_unit_custom_tree_node.org_unit

Restrict delete

org_unit_custom_tree_node_parent_node_fkey

org_unit_custom_tree_node.parent_node

org_unit_custom_tree_node.id

Cascade on delete

org_unit_custom_tree_node_tree_fkey

org_unit_custom_tree_node.tree

org_unit_custom_tree.id

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
passwd_type	passwd_type_iter_count_check	(((iter_count IS NULL) OR (iter_count > 0)))
toolbar	layout_must_be_json	(is_json(layout))
toolbar	only_one_type	((((ws IS NOT NULL) AND (COALESCE(org, usr) IS NULL)) OR ((org IS NOT NULL) AND (COALESCE(ws, usr) IS NULL)) OR ((usr IS NOT NULL) AND (COALESCE(org, ws) IS NULL))))
org_unit_proximity_adjustment	prox_adj_criterium	((COALESCE((item_circ_lib)::text, (item_owning_lib)::text, (copy_location)::text, (hold_pickup_lib)::text, (hold_request_lib)::text, circ_mod) IS NOT NULL))
org_unit_setting	aous_must_be_json	(is_json(value))
usr_saved_search	valid_query_text	((query_type = 'URL'::text))
usr_saved_search	valid_target	((target = ANY (ARRAY['record'::text, 'metarecord'::text, 'callnumber'::text])))