Constraints

6 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
alert_code_privileged_user_alert_code_id_fkey
alert_code_privileged_user.alert_code_id
alert_code.alert_code_id
Restrict delete
alert_id_fk
audit_event.alert_id
alert.id
Restrict delete
alert_code_alert_type_id_fkey
alert_code.alert_type_id
alert_type.alert_type_id
Restrict delete
alert_alert_code_fk
alert.alert_code_id
alert_code.alert_code_id
Restrict delete
fk_plan_id
plan_person.plan_id
bulk_plan.id
Restrict delete
fk_prison_number
plan_person.prison_number
person_summary.prison_number
Restrict delete

Check Constraints

Table Constraint Name Constraint
bulk_plan ch_bulk_plan_cleanup_mode (((cleanup_mode)::text = ANY ((ARRAY['KEEP_ALL'::character varying, 'EXPIRE_FOR_PRISON_NUMBERS_NOT_SPECIFIED'::character varying])::text[])))