audit_revision

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('audit_revision_id_seq'::regclass)
allocation_audit.rev_id allocation_audit_rev_id_fkey R
prison_configuration_audit.rev_id prison_configuration_audit_rev_id_fkey R
staff_configuration_audit.rev_id staff_configuration_audit_rev_id_fkey R
staff_role_audit.rev_id staff_role_audit_rev_id_fkey R
timestamp timestamp 29,6 null
username varchar 32 null
caseload_id varchar 10 null
affected_entities _varchar 2147483647 null

Indexes

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

Relationships