32 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| investigation_audit_rev_id_fkey |
|
|
Restrict delete | ||
| attendee_review_id_fkey |
|
|
Restrict delete | ||
| referral_referral_id_fkey |
|
|
Restrict delete | ||
| referral_incident_involvement_id_fkey |
|
|
Restrict delete | ||
| referral_incident_location_id_fkey |
|
|
Restrict delete | ||
| referral_referer_area_of_work_id_fkey |
|
|
Restrict delete | ||
| referral_incident_type_id_fkey |
|
|
Restrict delete | ||
| plan_audit_rev_id_fkey |
|
|
Restrict delete | ||
| decision_and_actions_audit_rev_id_fkey |
|
|
Restrict delete | ||
| plan_plan_id_fkey |
|
|
Restrict delete | ||
| review_audit_rev_id_fkey |
|
|
Restrict delete | ||
| attendee_audit_rev_id_fkey |
|
|
Restrict delete | ||
| identified_need_audit_rev_id_fkey |
|
|
Restrict delete | ||
| decision_and_actions_outcome_id_fkey |
|
|
Restrict delete | ||
| decision_and_actions_decision_and_actions_id_fkey |
|
|
Restrict delete | ||
| decision_and_actions_signed_off_by_role_id_fkey |
|
|
Restrict delete | ||
| investigation_investigation_id_fkey |
|
|
Restrict delete | ||
| interview_audit_rev_id_fkey |
|
|
Restrict delete | ||
| safer_custody_screening_outco_safer_custody_screening_outc_fkey |
|
|
Restrict delete | ||
| safer_custody_screening_outcome_outcome_id_fkey |
|
|
Restrict delete | ||
| contributory_factor_audit_rev_id_fkey |
|
|
Restrict delete | ||
| csip_record_status_id_fkey |
|
|
Restrict delete | ||
| fk_csip_prison_number |
|
|
Restrict delete | ||
| safer_custody_screening_outcome_audit_rev_id_fkey |
|
|
Restrict delete | ||
| identified_need_plan_id_fkey |
|
|
Restrict delete | ||
| contributory_factor_contributory_factor_type_id_fkey |
|
|
Restrict delete | ||
| contributory_factor_referral_id_fkey |
|
|
Restrict delete | ||
| csip_record_audit_rev_id_fkey |
|
|
Restrict delete | ||
| interview_interviewee_role_id_fkey |
|
|
Restrict delete | ||
| interview_investigation_id_fkey |
|
|
Restrict delete | ||
| review_plan_id_fkey |
|
|
Restrict delete | ||
| referral_audit_rev_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| referral | safer_custody_team_informed_enum_check | ((safer_custody_team_informed)::text = ANY ((ARRAY['YES'::character varying, 'NO'::character varying, 'DO_NOT_KNOW'::character varying])::text[])) |
| audit_revision | affected_components_enum_check | (affected_components <@ ARRAY['RECORD'::character varying, 'REFERRAL'::character varying, 'CONTRIBUTORY_FACTOR'::character varying, 'SAFER_CUSTODY_SCREENING_OUTCOME'::character varying, 'INVESTIGATION'::character varying, 'INTERVIEW'::character varying, 'DECISION_AND_ACTIONS'::character varying, 'PLAN'::character varying, 'IDENTIFIED_NEED'::character varying, 'REVIEW'::character varying, 'ATTENDEE'::character varying]) |
| audit_revision | check_source | ((source)::text = ANY ((ARRAY['DPS'::character varying, 'NOMIS'::character varying])::text[])) |
| decision_and_actions | actions_enum_check | (actions <@ ARRAY['OPEN_CSIP_ALERT'::character varying, 'NON_ASSOCIATIONS_UPDATED'::character varying, 'OBSERVATION_BOOK'::character varying, 'UNIT_OR_CELL_MOVE'::character varying, 'CSRA_OR_RSRA_REVIEW'::character varying, 'SERVICE_REFERRAL'::character varying, 'SIM_REFERRAL'::character varying]) |
| safer_custody_screening_outcome_audit | safer_custody_screening_ou_safer_custody_screening_ou_not_null1 | safer_custody_screening_outcome_id IS NOT NULL |
| review | review_actions_enum_check | (actions <@ ARRAY['RESPONSIBLE_PEOPLE_INFORMED'::character varying, 'CSIP_UPDATED'::character varying, 'REMAIN_ON_CSIP'::character varying, 'CASE_NOTE'::character varying, 'CLOSE_CSIP'::character varying]) |
| reference_data | reference_data_domain_enum_check | ((domain)::text = ANY ((ARRAY['AREA_OF_WORK'::character varying, 'CONTRIBUTORY_FACTOR_TYPE'::character varying, 'DECISION_OUTCOME_TYPE'::character varying, 'DECISION_SIGNER_ROLE'::character varying, 'INCIDENT_INVOLVEMENT'::character varying, 'INCIDENT_LOCATION'::character varying, 'INCIDENT_TYPE'::character varying, 'INTERVIEWEE_ROLE'::character varying, 'SCREENING_OUTCOME_TYPE'::character varying, 'STATUS'::character varying])::text[])) |