77 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| reservation_transit_copy_reservation_fkey |
|
|
Null on delete | ||
| artc_tc_fkey |
|
|
Cascade on delete | ||
| emergency_closing_reservation_emergency_closing_fkey |
|
|
Cascade on delete | ||
| emergency_closing_reservation_reservation_fkey |
|
|
Cascade on delete | ||
| hold_request_acq_request_fkey |
|
|
Restrict delete | ||
| hold_request_current_shelf_lib_fkey |
|
|
Restrict delete | ||
| hold_request_usr_fkey |
|
|
Restrict delete | ||
| hold_request_fulfillment_staff_fkey |
|
|
Restrict delete | ||
| hold_request_requestor_fkey |
|
|
Restrict delete | ||
| hold_request_request_lib_fkey |
|
|
Restrict delete | ||
| hold_request_sms_carrier_fkey |
|
|
Restrict delete | ||
| hold_request_hold_type_fkey |
|
|
Restrict delete | ||
| hold_request_pickup_lib_fkey |
|
|
Restrict delete | ||
| hold_request_fulfillment_lib_fkey |
|
|
Restrict delete | ||
| hold_request_cancel_cause_fkey |
|
|
Null on delete | ||
| hold_request_selection_ou_fkey |
|
|
Restrict delete | ||
| hold_request_note_hold_fkey |
|
|
Cascade on delete | ||
| non_cat_in_house_use_staff_fkey |
|
|
Restrict delete | ||
| non_cat_in_house_use_workstation_fkey |
|
|
Restrict delete | ||
| non_cat_in_house_use_item_type_fkey |
|
|
Restrict delete | ||
| non_cat_in_house_use_org_unit_fkey |
|
|
Restrict delete | ||
| emergency_closing_hold_hold_fkey |
|
|
Cascade on delete | ||
| emergency_closing_hold_emergency_closing_fkey |
|
|
Cascade on delete | ||
| emergency_closing_creator_fkey |
|
|
Cascade on delete | ||
| usr_circ_history_source_circ_fkey |
|
|
Null on delete | ||
| usr_circ_history_usr_fkey |
|
|
Restrict delete | ||
| survey_question_survey_fkey |
|
|
Restrict delete | ||
| circulation_limit_group_map_circ_fkey |
|
|
Cascade on delete | ||
| circulation_limit_group_map_limit_group_fkey |
|
|
Cascade on delete | ||
| hold_transit_copy_hold_fkey |
|
|
Null on delete | ||
| survey_response_question_fkey |
|
|
Restrict delete | ||
| survey_response_answer_fkey |
|
|
Restrict delete | ||
| survey_response_survey_fkey |
|
|
Restrict delete | ||
| emergency_closing_circulation_emergency_closing_fkey |
|
|
Cascade on delete | ||
| emergency_closing_circulation_circulation_fkey |
|
|
Cascade on delete | ||
| action_circulation_usr_fkey |
|
|
Restrict delete | ||
| action_circulation_circ_lib_fkey |
|
|
Null on delete | ||
| circulation_parent_circ_fkey |
|
|
Restrict delete | ||
| circulation_copy_location_fkey |
|
|
Restrict delete | ||
| circulation_checkin_workstation_fkey |
|
|
Null on delete | ||
| circulation_workstation_fkey |
|
|
Null on delete | ||
| hold_notification_hold_fkey |
|
|
Cascade on delete | ||
| hold_notification_notify_staff_fkey |
|
|
Restrict delete | ||
| transit_copy_source_fkey |
|
|
Restrict delete | ||
| transit_copy_copy_status_fkey |
|
|
Restrict delete | ||
| transit_copy_prev_hop_fkey |
|
|
Restrict delete | ||
| transit_copy_dest_fkey |
|
|
Restrict delete | ||
| transit_copy_prev_dest_fkey |
|
|
Restrict delete | ||
| batch_hold_event_map_hold_fkey |
|
|
Cascade on delete | ||
| batch_hold_event_map_batch_hold_event_fkey |
|
|
Cascade on delete | ||
| survey_answer_question_fkey |
|
|
Restrict delete | ||
| fieldset_group_creator_fkey |
|
|
Cascade on delete | ||
| fieldset_group_rollback_group_fkey |
|
|
Cascade on delete | ||
| fieldset_group_owning_lib_fkey |
|
|
Cascade on delete | ||
| survey_owner_fkey |
|
|
Restrict delete | ||
| fieldset_owner_fkey |
|
|
Restrict delete | ||
| fieldset_fieldset_group_fkey |
|
|
Cascade on delete | ||
| fieldset_owning_lib_fkey |
|
|
Restrict delete | ||
| fieldset_stored_query_fkey |
|
|
Restrict delete | ||
| in_house_use_staff_fkey |
|
|
Restrict delete | ||
| in_house_use_org_unit_fkey |
|
|
Restrict delete | ||
| in_house_use_workstation_fkey |
|
|
Restrict delete | ||
| curbside_org_fkey |
|
|
Cascade on delete | ||
| curbside_delivery_staff_fkey |
|
|
Cascade on delete | ||
| curbside_stage_staff_fkey |
|
|
Cascade on delete | ||
| curbside_patron_fkey |
|
|
Cascade on delete | ||
| batch_hold_event_bucket_fkey |
|
|
Cascade on delete | ||
| batch_hold_event_staff_fkey |
|
|
Cascade on delete | ||
| fieldset_col_val_fieldset_fkey |
|
|
Cascade on delete | ||
| hold_copy_map_hold_fkey |
|
|
Cascade on delete | ||
| ingest_queue_who_fkey |
|
|
Null on delete | ||
| non_cataloged_circulation_patron_fkey |
|
|
Restrict delete | ||
| non_cataloged_circulation_staff_fkey |
|
|
Restrict delete | ||
| non_cataloged_circulation_circ_lib_fkey |
|
|
Restrict delete | ||
| non_cataloged_circulation_item_type_fkey |
|
|
Restrict delete | ||
| ingest_queue_entry_queue_fkey |
|
|
Cascade on delete | ||
| ingest_queue_entry_override_by_fkey |
|
|
Null on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| hold_request | sms_check | (((sms_notify IS NULL) OR (sms_carrier IS NOT NULL))) |
| circulation | circulation_stop_fines_check | ((stop_fines = ANY (ARRAY['CHECKIN'::text, 'CLAIMSRETURNED'::text, 'LOST'::text, 'MAXFINES'::text, 'RENEW'::text, 'LONGOVERDUE'::text, 'CLAIMSNEVERCHECKEDOUT'::text]))) |
| fieldset | fieldset_one_or_the_other | ((((stored_query IS NOT NULL) AND (pkey_value IS NULL)) OR ((pkey_value IS NOT NULL) AND (stored_query IS NULL)))) |
| fieldset | valid_status | ((status = ANY (ARRAY['PENDING'::text, 'APPLIED'::text, 'ERROR'::text]))) |