Constraints

19 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_reference_data_domain_link_domain
reference_data_domain_link.domain
reference_data_domain.code
Restrict delete
fk_reference_data_domain_link_reference_data
reference_data_domain_link.id
reference_data.id
Restrict delete
temporary_absence_authorisation_audit_rev_id_fkey
temporary_absence_authorisation_audit.rev_id
audit_revision.id
Restrict delete
temporary_absence_movement_audit_rev_id_fkey
temporary_absence_movement_audit.rev_id
audit_revision.id
Restrict delete
temporary_absence_occurrence_audit_rev_id_fkey
temporary_absence_occurrence_audit.rev_id
audit_revision.id
Restrict delete
fk_reference_data_two
reference_data_link.reference_data_id_2
reference_data.id
Restrict delete
fk_reference_data_one
reference_data_link.reference_data_id_1
reference_data.id
Restrict delete
fk_temporary_absence_movement_absence_reason_id
temporary_absence_movement.absence_reason_id
reference_data.id
Restrict delete
fk_temporary_absence_movement_accompanied_by_id
temporary_absence_movement.accompanied_by_id
reference_data.id
Restrict delete
fk_temporary_absence_authorisation_absence_type_id
temporary_absence_authorisation.absence_type_id
reference_data.id
Restrict delete
fk_temporary_absence_authorisation_absence_reason_category_id
temporary_absence_authorisation.absence_reason_category_id
reference_data.id
Restrict delete
fk_temporary_absence_authorisation_status_id
temporary_absence_authorisation.status_id
reference_data.id
Restrict delete
fk_temporary_absence_authorisation_absence_sub_type_id
temporary_absence_authorisation.absence_sub_type_id
reference_data.id
Restrict delete
fk_temporary_absence_authorisation_absence_reason_id
temporary_absence_authorisation.absence_reason_id
reference_data.id
Restrict delete
hmpps_domain_event_audit_rev_id_fkey
hmpps_domain_event_audit.rev_id
audit_revision.id
Restrict delete
fk_temporary_absence_occurrence_accompanied_by_id
temporary_absence_occurrence.accompanied_by_id
reference_data.id
Restrict delete
fk_temporary_absence_occurrence_transport_id
temporary_absence_occurrence.transport_id
reference_data.id
Restrict delete
fk_temporary_absence_occurrence_authorisation
temporary_absence_occurrence.authorisation_id
temporary_absence_authorisation.id
Restrict delete
fk_reference_data_domain
reference_data.domain
reference_data_domain.code
Restrict delete

Check Constraints

Table Constraint Name Constraint
audit_revision ch_audit_revision_source ((source)::text = ANY ((ARRAY['DPS'::character varying, 'NOMIS'::character varying])::text[]))
temporary_absence_authorisation ch_taa_approved_at_approved_by (((approved_at IS NULL) AND (approved_by IS NULL)) OR ((approved_at IS NOT NULL) AND (approved_by IS NOT NULL)))
temporary_absence_occurrence ch_tao_cancelled_at_cancelled_by (((cancelled_at IS NULL) AND (cancelled_by IS NULL)) OR ((cancelled_at IS NOT NULL) AND (cancelled_by IS NOT NULL)))