audit_revision

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('audit_revision_id_seq'::regclass)
hmpps_domain_event_audit.rev_id hmpps_domain_event_audit_rev_id_fkey R
temporary_absence_authorisation_audit.rev_id temporary_absence_authorisation_audit_rev_id_fkey R
temporary_absence_movement_audit.rev_id temporary_absence_movement_audit_rev_id_fkey R
temporary_absence_occurrence_audit.rev_id temporary_absence_occurrence_audit_rev_id_fkey R
timestamp timestamp 29,6 null
username varchar 64 null
source varchar 6 null
affected_entities _varchar 2147483647 null

Indexes

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

Check Constraints

Constraint Name Constraint
ch_audit_revision_source ((source)::text = ANY ((ARRAY['DPS'::character varying, 'NOMIS'::character varying])::text[]))

Relationships

Close relationships within degrees of separation