Constraints

64 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

course_module_course_owning_lib_fkey

course_module_course.owning_lib

Restrict delete

course_module_course_users_usr_role_fkey

course_module_course_users.usr_role

course_module_role.id

Cascade on delete

course_module_course_users_usr_fkey

course_module_course_users.usr

usr.id

Restrict delete

course_module_course_users_course_fkey

course_module_course_users.course

course_module_course.id

Restrict delete

call_number_suffix_owning_lib_fkey

call_number_suffix.owning_lib

Restrict delete

a_sc_sc_fkey

stat_cat_entry_copy_map.stat_cat

Cascade on delete

a_sc_sce_fkey

stat_cat_entry_copy_map.stat_cat_entry

stat_cat_entry.id

Cascade on delete

course_module_course_materials_item_fkey

course_module_course_materials.item

Restrict delete

course_module_course_materials_course_fkey

course_module_course_materials.course

course_module_course.id

Restrict delete

course_module_course_materials_record_fkey

course_module_course_materials.record

record_entry.id

Restrict delete

course_module_course_materials_original_status_fkey

course_module_course_materials.original_status

Restrict delete

course_module_course_materials_original_circ_lib_fkey

course_module_course_materials.original_circ_lib

Restrict delete

course_module_course_materials_original_callnumber_fkey

course_module_course_materials.original_callnumber

Restrict delete

course_module_course_materials_original_location_fkey

course_module_course_materials.original_location

copy_location.id

Restrict delete

original_circ_mod_fkey

course_module_course_materials.original_circ_modifier

circ_modifier.code

Null on delete

copy_location_owning_lib_fkey

copy_location.owning_lib

Restrict delete

stat_cat_sip_field_fkey

stat_cat.sip_field

stat_cat_sip_fields.field

Null on delete

a_sc_owner_fkey

Cascade on delete

copy_location_group_owner_fkey

copy_location_group.owner

Cascade on delete

call_number_suffix_fkey

call_number.suffix

call_number_suffix.id

Restrict delete

asset_call_number_record_fkey

call_number.record

record_entry.id

Restrict delete

asset_call_number_creator_fkey

call_number.creator

usr.id

Restrict delete

call_number_prefix_fkey

call_number.prefix

call_number_prefix.id

Restrict delete

asset_call_number_editor_fkey

call_number.editor

usr.id

Restrict delete

asset_call_number_owning_lib_fkey

call_number.owning_lib

Restrict delete

call_number_label_class_fkey

call_number.label_class

call_number_class.id

Restrict delete

copy_location_group_map_location_fkey

copy_location_group_map.location

copy_location.id

Cascade on delete

copy_location_group_map_lgroup_fkey

copy_location_group_map.lgroup

copy_location_group.id

Cascade on delete

copy_tag_copy_map_tag_fkey

copy_tag_copy_map.tag

Cascade on delete

copy_inventory_inventory_workstation_fkey

copy_inventory.inventory_workstation

Restrict delete

asset_call_number_note_record_fkey

call_number_note.call_number

Cascade on delete

asset_call_number_note_creator_fkey

call_number_note.creator

usr.id

Null on delete

copy_alert_ack_staff_fkey

copy_alert.ack_staff

usr.id

Null on delete

copy_alert_create_staff_fkey

copy_alert.create_staff

usr.id

Null on delete

copy_alert_alert_type_fkey

copy_alert.alert_type

copy_alert_type.id

Cascade on delete

copy_tag_owner_fkey

Restrict delete

copy_tag_tag_type_fkey

copy_tag.tag_type

copy_tag_type.code

Cascade on delete

a_sce_sc_fkey

stat_cat_entry.stat_cat

Cascade on delete

a_sce_owner_fkey

stat_cat_entry.owner

Cascade on delete

copy_template_owning_lib_fkey

copy_template.owning_lib

Restrict delete

copy_template_location_fkey

copy_template.location

copy_location.id

Restrict delete

asset_copy_template_floating_fkey

copy_template.floating

floating_group.id

Restrict delete

copy_template_circ_lib_fkey

copy_template.circ_lib

Restrict delete

copy_template_editor_fkey

copy_template.editor

usr.id

Restrict delete

copy_template_creator_fkey

copy_template.creator

usr.id

Restrict delete

copy_template_status_fkey

copy_template.status

Restrict delete

copy_location_order_org_fkey

copy_location_order.org

Cascade on delete

copy_location_order_location_fkey

copy_location_order.location

copy_location.id

Cascade on delete

copy_location_fkey

copy.location

copy_location.id

Restrict delete

copy_status_fkey

copy.status

Restrict delete

asset_copy_floating_fkey

copy.floating

floating_group.id

Restrict delete

copy_circ_lib_fkey

copy.circ_lib

Restrict delete

circ_mod_fkey

copy.circ_modifier

circ_modifier.code

Null on delete

asset_copy_editor_fkey

copy.editor

usr.id

Null on delete

asset_copy_creator_fkey

copy.creator

usr.id

Null on delete

asset_copy_call_number_fkey

copy.call_number

Restrict delete

asset_copy_note_creator_fkey

copy_note.creator

usr.id

Null on delete

uri_call_number_map_call_number_fkey

uri_call_number_map.call_number

Restrict delete

uri_call_number_map_uri_fkey

uri_call_number_map.uri

uri.id

Restrict delete

course_module_term_owning_lib_fkey

course_module_term.owning_lib

Restrict delete

copy_part_map_part_fkey

copy_part_map.part

monograph_part.id

Cascade on delete

call_number_prefix_owning_lib_fkey

call_number_prefix.owning_lib

Restrict delete

course_module_term_course_map_term_fkey

course_module_term_course_map.term

course_module_term.id

Cascade on delete

course_module_term_course_map_course_fkey

course_module_term_course_map.course

course_module_course.id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
copy_template	valid_fine_level	(((fine_level IS NULL) OR (fine_level = ANY (ARRAY[1, 2, 3]))))
copy_template	valid_loan_duration	(((loan_duration IS NULL) OR (loan_duration = ANY (ARRAY[1, 2, 3]))))
copy	copy_fine_level_check	((fine_level = ANY (ARRAY[1, 2, 3])))
copy	copy_loan_duration_check	((loan_duration = ANY (ARRAY[1, 2, 3])))