audit_revision

-1 rows


Description

Hibernate Envers audit revision records. A revision is created for every set of changes to the CSIP entity graph and the history of every mutable property change is tracked. Full audit history starts from the 15th of November 2024

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('audit_revision_id_seq'::regclass)
attendee.legacy_id Implied Constraint R
attendee_audit.legacy_id Implied Constraint R
attendee_audit.rev_id attendee_audit_rev_id_fkey R
contributory_factor.legacy_id Implied Constraint R
contributory_factor_audit.contributory_factor_type_id Implied Constraint R
contributory_factor_audit.legacy_id Implied Constraint R
contributory_factor_audit.rev_id contributory_factor_audit_rev_id_fkey R
csip_record.legacy_id Implied Constraint R
csip_record_audit.legacy_id Implied Constraint R
csip_record_audit.rev_id csip_record_audit_rev_id_fkey R
decision_and_actions_audit.outcome_id Implied Constraint R
decision_and_actions_audit.rev_id decision_and_actions_audit_rev_id_fkey R
decision_and_actions_audit.signed_off_by_role_id Implied Constraint R
identified_need.legacy_id Implied Constraint R
identified_need_audit.legacy_id Implied Constraint R
identified_need_audit.rev_id identified_need_audit_rev_id_fkey R
interview.legacy_id Implied Constraint R
interview_audit.interviewee_role_id Implied Constraint R
interview_audit.legacy_id Implied Constraint R
interview_audit.rev_id interview_audit_rev_id_fkey R
investigation_audit.rev_id investigation_audit_rev_id_fkey R
plan_audit.rev_id plan_audit_rev_id_fkey R
referral_audit.incident_involvement_id Implied Constraint R
referral_audit.incident_location_id Implied Constraint R
referral_audit.incident_type_id Implied Constraint R
referral_audit.referer_area_of_work_id Implied Constraint R
referral_audit.rev_id referral_audit_rev_id_fkey R
review.legacy_id Implied Constraint R
review_audit.legacy_id Implied Constraint R
review_audit.rev_id review_audit_rev_id_fkey R
safer_custody_screening_outcome_audit.outcome_id Implied Constraint R
safer_custody_screening_outcome_audit.rev_id safer_custody_screening_outcome_audit_rev_id_fkey R

Internal primary key
timestamp timestamp 29,6 null

The date and time the change happened
username varchar 64 null

The username of the user who made the change
caseload_id varchar 10 √ null

The active caseload of the user at the time of the change
source varchar 6 √ null

The system used to make the change. Either DPS or NOMIS
affected_components _varchar 2147483647 √ null

The table or tables that had values affected by the change

Indexes

Constraint Name Type Sort Column(s)
audit_revision_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
check_source (((source)::text = ANY ((ARRAY['DPS'::character varying, 'NOMIS'::character varying])::text[])))
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]))

Relationships

Close relationships within degrees of separation