Constraints

23 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
authorisation_audit_rev_id_fkey
authorisation_audit.rev_id
audit_revision.id
Restrict delete
occurrence_audit_rev_id_fkey
occurrence_audit.rev_id
audit_revision.id
Restrict delete
movement_audit_rev_id_fkey
movement_audit.rev_id
audit_revision.id
Restrict delete
fk_occurrence_person
occurrence.person_identifier
person_summary.person_identifier
Restrict delete
fk_tap_occurrence_absence_reason
occurrence.absence_reason_id
absence_reason.id
Restrict delete
fk_tap_occurrence_absence_sub_type
occurrence.absence_sub_type_id
absence_sub_type.id
Restrict delete
fk_tap_occurrence_absence_type
occurrence.absence_type_id
absence_type.id
Restrict delete
fk_tap_occurrence_absence_reason_category
occurrence.absence_reason_category_id
absence_reason_category.id
Restrict delete
fk_tap_occurrence_accompanied_by
occurrence.accompanied_by_id
accompanied_by.id
Restrict delete
fk_tap_occurrence_transport
occurrence.transport_id
transport.id
Restrict delete
fk_tap_occurrence_status
occurrence.status_id
occurrence_status.id
Restrict delete
fk_tap_authorisation_accompanied_by
authorisation.accompanied_by_id
accompanied_by.id
Restrict delete
fk_tap_authorisation_absence_sub_type
authorisation.absence_sub_type_id
absence_sub_type.id
Restrict delete
fk_tap_authorisation_transport
authorisation.transport_id
transport.id
Restrict delete
fk_authorisation_person
authorisation.person_identifier
person_summary.person_identifier
Restrict delete
fk_tap_authorisation_status
authorisation.status_id
authorisation_status.id
Restrict delete
fk_tap_authorisation_absence_reason_category
authorisation.absence_reason_category_id
absence_reason_category.id
Restrict delete
fk_tap_authorisation_absence_type
authorisation.absence_type_id
absence_type.id
Restrict delete
fk_tap_authorisation_absence_reason
authorisation.absence_reason_id
absence_reason.id
Restrict delete
fk_tap_movement_absence_reason
movement.absence_reason_id
absence_reason.id
Restrict delete
fk_tap_movement_occurrence
movement.occurrence_id
occurrence.id
Restrict delete
fk_movement_person
movement.person_identifier
person_summary.person_identifier
Restrict delete
fk_tap_movement_accompanied_by
movement.accompanied_by_id
accompanied_by.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
occurrence occurrence_status_id_not_null1 status_id IS NOT NULL
authorisation authorisation_status_id_not_null1 status_id IS NOT NULL