239 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fkfile_attachment_upload_person_oid |
|
|
Restrict delete | ||
| resource_type_certification_person_oid_fkey |
|
|
Cascade on delete | ||
| resource_type_certification_resource_type_oid_fkey |
|
|
Cascade on delete | ||
| fkcapability_authorization_authorization_oid |
|
|
Cascade on delete | ||
| fkcapability_authorization_capability_oid |
|
|
Cascade on delete | ||
| patron_custom_data_organization_oid_fkey |
|
|
Cascade on delete | ||
| patron_custom_data_checkout_center_oid_fkey |
|
|
Cascade on delete | ||
| patron_custom_data_person_oid_fkey |
|
|
Cascade on delete | ||
| fkallocation_original_agent_oid |
|
|
Null on delete | ||
| fkcalloc_patron_oid |
|
|
Restrict delete | ||
| fkcalloc_agent_oid |
|
|
|||
| fkcaccount_oid |
|
|
Restrict delete | ||
| fkcalloc_deliver_to_oid |
|
|
Null on delete | ||
| fkcalloc_contact_person |
|
|
Null on delete | ||
| allocation_copy_of_fkey |
|
|
Null on delete | ||
| fkcpatron_class_oid |
|
|
Restrict delete | ||
| fkcalloc_checkout_center_oid |
|
|
Cascade on delete | ||
| custom_property_strings_custom_property_oid_fkey |
|
|
Cascade on delete | ||
| custom_property_money_custom_property_oid_fkey |
|
|
Cascade on delete | ||
| allocation_repeat_rule_allocation_oid_fkey |
|
|
Cascade on delete | ||
| task_type_organization_oid_fkey |
|
|
Cascade on delete | ||
| fkdefault_ticket_resolution_oid |
|
|
Restrict delete | ||
| fkdefault_ticket_remedy_type_oid |
|
|
Restrict delete | ||
| fkapp_default_org_oid |
|
|
Restrict delete | ||
| fkdefault_ticket_severity_oid |
|
|
Restrict delete | ||
| fkdefault_ticket_problem_type_oid |
|
|
Restrict delete | ||
| fkdefault_ticket_priority_oid |
|
|
Restrict delete | ||
| fkapp_default_loc_oid |
|
|
Restrict delete | ||
| fkdefault_ticket_type_oid |
|
|
Restrict delete | ||
| sched_staffed_location_org_oid_fkey |
|
|
Cascade on delete | ||
| fkcpatron_class_oid |
|
|
Restrict delete | ||
| fkcdepartment_billing_contact_oid |
|
|
Null on delete | ||
| sched_employee_person_oid_fkey |
|
|
Cascade on delete | ||
| sched_employee_organization_oid_fkey |
|
|
Cascade on delete | ||
| fkscheduled_message_type_message_type_oid |
|
|
Cascade on delete | ||
| sched_staff_availability_person_oid_fkey |
|
|
Cascade on delete | ||
| allocation_group_allocation_oid_fkey |
|
|
Cascade on delete | ||
| fkcalloc_group_src_alloc_oid |
|
|
Cascade on delete | ||
| fkcalloc_group_rule_oid |
|
|
Cascade on delete | ||
| fkcdepartment_code_department_oid |
|
|
Cascade on delete | ||
| fkcresource_type_org_oid |
|
|
Cascade on delete | ||
| turndown_patron_oid_fkey |
|
|
Null on delete | ||
| turndown_checkout_center_oid_fkey |
|
|
Null on delete | ||
| turndown_allocation_oid_fkey |
|
|
Null on delete | ||
| fkacct_deb_org |
|
|
Cascade on delete | ||
| fkacct_deb_acct |
|
|
Cascade on delete | ||
| fkacct_deb_created_by |
|
|
|||
| fkacct_deb_inv_line |
|
|
Cascade on delete | ||
| allocation_item_building_pass_allocation_oid_fkey |
|
|
Cascade on delete | ||
| inventory_selector_home_location_oid_fkey |
|
|
Null on delete | ||
| inventory_selector_checkout_center_oid_fkey |
|
|
Null on delete | ||
| inventory_selector_resource_type_oid_fkey |
|
|
Null on delete | ||
| inventory_selector_resource_oid_fkey |
|
|
Cascade on delete | ||
| inventory_selector_inventory_oid_fkey |
|
|
Cascade on delete | ||
| fkmaintsched_ticket_type_oid |
|
|
Null on delete | ||
| fkmaintsched_priority_oid |
|
|
Null on delete | ||
| fkmaintsched_problem_type_oid |
|
|
Null on delete | ||
| fkmaintsched_vendor_oid |
|
|
Null on delete | ||
| kmaintsched_rtype_oid |
|
|
Restrict delete | ||
| kmaintsched_mtype_oid |
|
|
Restrict delete | ||
| fkmaintsched_severity_oid |
|
|
Null on delete | ||
| fkmaintsched_person_oid |
|
|
Null on delete | ||
| fkmaintsched_remedy_type_oid |
|
|
Null on delete | ||
| fklocation_parent_oid |
|
|
Null on delete | ||
| fklocation_rsrc_oid |
|
|
Cascade on delete | ||
| fklocation_org_oid |
|
|
Cascade on delete | ||
| sched_scheduling_group_member_staff_oid_fkey |
|
|
Cascade on delete | ||
| sched_scheduling_group_member_scheduling_group_oid_fkey |
|
|
Cascade on delete | ||
| fkpatron_class_oid |
|
|
Cascade on delete | ||
| email_template_message_type_oid_fkey |
|
|
Cascade on delete | ||
| email_template_organization_oid_fkey |
|
|
Cascade on delete | ||
| agreement_form_config_checkout_center_oid |
|
|
Cascade on delete | ||
| fkcwco_group_contact_oid |
|
|
Null on delete | ||
| fkcwco_group_organization_oid |
|
|
Cascade on delete | ||
| task_profile_task_type_task_type_oid_fkey |
|
|
Cascade on delete | ||
| task_profile_task_type_task_profile_oid_fkey |
|
|
Cascade on delete | ||
| kmaintevent_msched_oid |
|
|
Restrict delete | ||
| kmaintevent_ticket_oid |
|
|
Restrict delete | ||
| kmaintevent_resource_oid |
|
|
Restrict delete | ||
| kmaintevent_offline_oid |
|
|
Restrict delete | ||
| fkcorg_admin_id |
|
|
Null on delete | ||
| organization_email_template_set_oid_fkey |
|
|
Null on delete | ||
| allocation_accompanying_person_person_oid_fkey |
|
|
Cascade on delete | ||
| allocation_accompanying_person_allocation_oid_fkey |
|
|
Cascade on delete | ||
| fkcmodel_schedule_node_sched_oid |
|
|
Cascade on delete | ||
| fkinv_line_modified_by |
|
|
|||
| fkinv_line_created_by |
|
|
|||
| fkinv_line_res |
|
|
Null on delete | ||
| invoice_line_invoice_oid_fkey |
|
|
Cascade on delete | ||
| tar_problem_type_oid |
|
|
Cascade on delete | ||
| tar_sched_group_oid |
|
|
Cascade on delete | ||
| tar_role_oid |
|
|
Cascade on delete | ||
| tar_person_oid |
|
|
Cascade on delete | ||
| tar_rtype_oid |
|
|
Cascade on delete | ||
| tar_org_oid |
|
|
Cascade on delete | ||
| sched_staff_staffed_location_oid_fkey |
|
|
Cascade on delete | ||
| sched_staff_person_oid_fkey |
|
|
Cascade on delete | ||
| fkacct_cred_org |
|
|
Cascade on delete | ||
| fkacct_cred_acct |
|
|
Cascade on delete | ||
| fkacct_cred_created_by |
|
|
|||
| resource_rtype_oid_fkey |
|
|
Restrict delete | ||
| fkcres_loc_res |
|
|
Null on delete | ||
| fkcres_person |
|
|
Null on delete | ||
| fkcres_department |
|
|
Null on delete | ||
| resource_checkout_center_oid_fkey |
|
|
Cascade on delete | ||
| fkres_cont_res |
|
|
Null on delete | ||
| email_template_set_organization_oid_fkey |
|
|
Cascade on delete | ||
| fkcalendar_layer_calendar_oid |
|
|
Cascade on delete | ||
| fkapp_default_loc_oid |
|
|
Restrict delete | ||
| patron_portal_property_custom_property_oid_fkey |
|
|
Restrict delete | ||
| fkcresource_schedule_alloc_oid |
|
|
Cascade on delete | ||
| fkcresource_schedule_checkout_center |
|
|
Cascade on delete | ||
| fkcresource_schedule_proposed_resource_oid |
|
|
Cascade on delete | ||
| fkcresource_schedule_return_agent_oid |
|
|
|||
| fkcresource_schedule_scheduled_resource_oid |
|
|
Cascade on delete | ||
| fkc_section_member_section_oid |
|
|
Cascade on delete | ||
| fkc_section_member_member_oid |
|
|
Cascade on delete | ||
| fksubscription_person_oid |
|
|
Cascade on delete | ||
| custom_property_timestamps_custom_property_oid_fkey |
|
|
Cascade on delete | ||
| fkmainttype_problem_type_oid |
|
|
Null on delete | ||
| fkmainttype_ticket_type_oid |
|
|
Null on delete | ||
| fkmainttype_org_oid |
|
|
Restrict delete | ||
| fkmainttype_vendor_oid |
|
|
Null on delete | ||
| fkmainttype_person_oid |
|
|
Null on delete | ||
| fkmainttype_remedy_type_oid |
|
|
Null on delete | ||
| fkmainttype_priority_oid |
|
|
Null on delete | ||
| fkmainttype_severity_oid |
|
|
Null on delete | ||
| person_checkout_center_signature_checkout_center_oid_fkey |
|
|
Cascade on delete | ||
| person_checkout_center_signature_person_oid_fkey |
|
|
Cascade on delete | ||
| system_role_cap_auth |
|
|
Restrict delete | ||
| system_role_cap_role |
|
|
Cascade on delete | ||
| fkticket_priority_oid |
|
|
Restrict delete | ||
| fkticket_problem_type_oid |
|
|
Restrict delete | ||
| fkticket_vendor_oid |
|
|
Null on delete | ||
| fkticket_org_oid |
|
|
Restrict delete | ||
| fkticket_agent |
|
|
|||
| fkticket_remedy_type_oid |
|
|
Restrict delete | ||
| fkticket_res |
|
|
Null on delete | ||
| fkticket_severity_oid |
|
|
Restrict delete | ||
| fkticket_location |
|
|
Null on delete | ||
| fkticket_responsible_op |
|
|
|||
| fkticket_resolution_oid |
|
|
Restrict delete | ||
| fkticket_type_oid |
|
|
Restrict delete | ||
| fkticket_patron |
|
|
Null on delete | ||
| calendar_allocation_fields_checkout_center_oid_fkey |
|
|
Cascade on delete | ||
| fkholding_bibliographic_record |
|
|
Cascade on delete | ||
| fkholding_resource |
|
|
Cascade on delete | ||
| fkccirc_record_resource_oid |
|
|
Cascade on delete | ||
| fkauthset_path_tail_oid |
|
|
Restrict delete | ||
| fkauthset_path_head_oid |
|
|
Restrict delete | ||
| sched_scheduling_group_staffed_location_oid_fkey |
|
|
Cascade on delete | ||
| fkccheckout_center_schedule_checkout_center |
|
|
Cascade on delete | ||
| fkccheckout_center_schedule_parent |
|
|
Null on delete | ||
| fkcwco_station_checkout_center_oid |
|
|
Cascade on delete | ||
| fkcchekout_center_schedule_node_checkout_center_schedule |
|
|
Cascade on delete | ||
| fkperson_oid |
|
|
Cascade on delete | ||
| fkcdepartment_oid |
|
|
Cascade on delete | ||
| inventory_organization_oid_fkey |
|
|
Cascade on delete | ||
| fkcapability_organization_oid |
|
|
Cascade on delete | ||
| fkcapability_person_oid |
|
|
Cascade on delete | ||
| fkcapability_role_oid |
|
|
Cascade on delete | ||
| email_template_set_template_email_template_set_oid_fkey |
|
|
Cascade on delete | ||
| email_template_set_template_email_template_oid_fkey |
|
|
Cascade on delete | ||
| email_template_set_template_message_type_oid_fkey |
|
|
Cascade on delete | ||
| fkchold_person_oid |
|
|
Cascade on delete | ||
| fkchold_organization_oid |
|
|
Cascade on delete | ||
| fkchold_cc_oid |
|
|
Cascade on delete | ||
| fkchold_invoice_oid |
|
|
Cascade on delete | ||
| fkcapability_checkout_center_checkout_center_oid |
|
|
Cascade on delete | ||
| fkcapability_checkout_center_capability_oid |
|
|
Cascade on delete | ||
| task_organization_oid_fkey |
|
|
Cascade on delete | ||
| task_location_oid_fkey |
|
|
Null on delete | ||
| task_task_type_oid_fkey |
|
|
Cascade on delete | ||
| task_allocation_oid_fkey |
|
|
Cascade on delete | ||
| fksubscription_notification_subscription |
|
|
Cascade on delete | ||
| fkcalloc_log_alloc_oid |
|
|
Cascade on delete | ||
| fkcinvoice_org_oid |
|
|
Cascade on delete | ||
| fkcinvoice_alloc_oid |
|
|
Cascade on delete | ||
| fkcinvoice_modified_by |
|
|
Null on delete | ||
| fkcinvoice_created_by |
|
|
|||
| fkcaccount_oid |
|
|
Restrict delete | ||
| fkcinvoice_cc_oid |
|
|
Cascade on delete | ||
| custom_property_integers_custom_property_oid_fkey |
|
|
Cascade on delete | ||
| fkauto_email_message_type_oid |
|
|
Cascade on delete | ||
| fkcheckout_center_auto_email_auto_email_oid |
|
|
Cascade on delete | ||
| invoice_line_tax_rate_invoice_tax_rate_oid_fkey |
|
|
Cascade on delete | ||
| invoice_line_tax_rate_invoice_line_oid_fkey |
|
|
Cascade on delete | ||
| staff_assignment_sched_group_oid |
|
|
Null on delete | ||
| staff_assignment_staff_oid |
|
|
Null on delete | ||
| staff_assignment_unppublished_sched_group_oid |
|
|
Null on delete | ||
| staff_assignment_shift_oid |
|
|
Cascade on delete | ||
| staff_assignment_unpub_staff_oid |
|
|
Null on delete | ||
| fkcauthset_delegation_org_oid |
|
|
Cascade on delete | ||
| fkcauthset_delegation_authset_oid |
|
|
Cascade on delete | ||
| type_allocation_usage_data_cc_oid_fkey |
|
|
Cascade on delete | ||
| type_allocation_usage_data_allocation_oid_fkey |
|
|
Cascade on delete | ||
| type_allocation_usage_data_resource_type_oid_fkey |
|
|
Cascade on delete | ||
| fkcauthentication_obj_oid |
|
|
Cascade on delete | ||
| sched_staffing_limit_staff_oid_fkey |
|
|
Cascade on delete | ||
| resource_type_fallback_fallback_oid_fkey |
|
|
Cascade on delete | ||
| resource_type_fallback_type_oid_fkey |
|
|
Cascade on delete | ||
| custom_property_booleans_custom_property_oid_fkey |
|
|
Cascade on delete | ||
| inventory_note_inventory_oid_fkey |
|
|
Cascade on delete | ||
| inventory_note_resource_oid_fkey |
|
|
Null on delete | ||
| inventory_note_agent_oid_fkey |
|
|
Null on delete | ||
| inventory_note_parent_note_oid_fkey |
|
|
Null on delete | ||
| ldap_rule_ldap_profile_oid_fkey |
|
|
Cascade on delete | ||
| ldap_rule_patron_class_oid_fkey |
|
|
Cascade on delete | ||
| task_profile_organization_oid_fkey |
|
|
Cascade on delete | ||
| task_person_person_oid_fkey |
|
|
Cascade on delete | ||
| task_person_task_oid_fkey |
|
|
Cascade on delete | ||
| fkcwco_log_cc_oid |
|
|
|||
| fkcwco_log_reps_agent_oid |
|
|
|||
| fkcwco_log_agent_oid |
|
|
|||
| fkcwco_log_org_oid |
|
|
|||
| checkout_center_pir_pickup_option_checkout_center_oid_fkey |
|
|
Cascade on delete | ||
| checkout_center_custom_agreement_form_oid_fkey |
|
|
Restrict delete | ||
| checkout_center_email_template_set_oid_fkey |
|
|
Null on delete | ||
| checkout_center_org_oid_fkey |
|
|
Cascade on delete | ||
| fk_taxrates_organization_oid |
|
|
Cascade on delete | ||
| fksubscription_notification_subscription |
|
|
Cascade on delete | ||
| fkcticket_log_work_type_oid |
|
|
Null on delete | ||
| fkcticket_log_ticket_oid |
|
|
Cascade on delete | ||
| fkcticket_log_expense_type_oid |
|
|
Null on delete | ||
| fkcticket_log_agent_oid |
|
|
|||
| fkcalendar_period_layer_oid |
|
|
Cascade on delete | ||
| fkcalendar_period_model_schedule_oid |
|
|
Null on delete | ||
| fkcalendar_period_calendar_oid |
|
|
Cascade on delete | ||
| fkmainttype_org_oid |
|
|
Restrict delete | ||
| checkout_center_default_task_profile_checkout_center_oid_fkey |
|
|
Cascade on delete | ||
| checkout_center_default_task_profile_task_profile_oid_fkey |
|
|
Cascade on delete | ||
| invoice_tax_rate_invoice_oid_fkey |
|
|
Cascade on delete | ||
| sched_shift_staffed_location_oid_fkey |
|
|
Cascade on delete | ||
| inventory_item_inventoried_assigned_department_oid_fkey |
|
|
Null on delete | ||
| inventory_item_inventoried_assigned_person_oid_fkey |
|
|
Null on delete | ||
| inventory_item_resource_oid_fkey |
|
|
Cascade on delete | ||
| inventory_item_scanning_agent_oid_fkey |
|
|
Null on delete | ||
| inventory_item_inventoried_home_location_oid_fkey |
|
|
Null on delete | ||
| inventory_item_inventory_oid_fkey |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| authset_entry | authset_entry_scope | ((NOT ((entry_class = ROW('CHECKOUT-CENTER'::character varying, 'WCOF'::character varying)::cl_class) AND (scope IS NULL)))) |
| authset_entry | authset_entry_self_containment | ((NOT ((authset_oid = entry_oid) AND (entry_class = ROW('AUTHSET'::character varying, 'WCOF'::character varying)::cl_class)))) |
| inventory_selector | inventory_selector_circulation_status_check | (((circulation_status)::text = ANY ((ARRAY['CIRCULATING'::character varying, 'NON-CIRCULATING'::character varying])::text[]))) |
| inventory_selector | inventory_selector_metaclass_check | ((metaclass = ANY (ARRAY['EQUIPMENT'::wcof_tag, 'MEDIA'::wcof_tag, 'LOCATION'::wcof_tag]))) |
| inventory_selector | inventory_selector_online_status_check | (((online_status)::text = ANY ((ARRAY['ONLINE'::character varying, 'OFFLINE'::character varying])::text[]))) |
| resource | resource_location_capacity | ((NOT ((metaclass <> 'LOCATION'::wcof_tag) AND (capacity IS NOT NULL)))) |
| resource | resource_media_equipment_manufacturer | ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (manufacturer IS NOT NULL)))) |
| resource | resource_media_equipment_model | ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (model IS NOT NULL)))) |
| resource | resource_media_equipment_purchase_date | ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (purchase_date IS NOT NULL)))) |
| resource | resource_media_equipment_purchase_order | ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (purchase_order IS NOT NULL)))) |
| resource | resource_media_equipment_serial_number | ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (serial_number IS NOT NULL)))) |
| resource | resource_media_equipment_vendor | ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (vendor IS NOT NULL)))) |
| resource | resource_media_equipment_warranty_labor | ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (warranty_labor IS NOT NULL)))) |
| resource | resource_media_equipment_warranty_parts | ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (warranty_parts IS NOT NULL)))) |
| resource | resource_metaclass_check | ((metaclass = ANY (ARRAY['EQUIPMENT'::wcof_tag, 'MEDIA'::wcof_tag, 'LOCATION'::wcof_tag]))) |
| resource | resource_not_own_location | ((location_resource_oid <> obj_oid)) |
| resource_schedule | ck_proposed_or_resource_null | (((proposed_resource_oid IS NULL) OR (scheduled_resource_oid IS NULL))) |
| authset_path | authset_path_check | ((tail_oid <> head_oid)) |
| inventory | inventory_allow_manual_check | (((allow_manual)::text = ANY ((ARRAY['NO-BARCODE'::character varying, 'ALWAYS'::character varying, 'NEVER'::character varying])::text[]))) |
| checkout_center | check_agreement_form_grouping | ((agreement_form_grouping = ANY (ARRAY['UNSERIALIZED'::wcof_tag, 'NONE'::wcof_tag]))) |
| checkout_center | check_agreement_form_sorting | ((agreement_form_sorting = ANY (ARRAY['ROOT-RESOURCE-TYPE'::wcof_tag, 'RESOURCE-TYPE'::wcof_tag, 'NAME'::wcof_tag]))) |
| checkout_center | check_delivery_defaults | ((default_delivery_type = ANY (ARRAY['NORMAL'::wcof_tag, 'FULL-DAY'::wcof_tag]))) |
| checkout_center | check_form_date_time_format | ((form_date_time_format = ANY (ARRAY['DAYTIME'::wcof_tag, 'ISO+TIME'::wcof_tag, 'DAYTIME+WEEKDAY'::wcof_tag]))) |
| inventory_item | inventory_item_scan_type_check | (((scan_type)::text = ANY ((ARRAY['PICKUP'::character varying, 'RETURN'::character varying, 'BARCODE'::character varying, 'ID'::character varying, 'MANUAL'::character varying])::text[]))) |