authorisation_audit

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
rev_id int8 19 null
audit_revision.id authorisation_audit_rev_id_fkey R
rev_type int2 5 null
id uuid 2147483647 null
version int4 10 null
person_identifier varchar 10 null
prison_code varchar 6 null
status_id uuid 2147483647 null
absence_type_id uuid 2147483647 √ null
absence_sub_type_id uuid 2147483647 √ null
absence_reason_category_id uuid 2147483647 √ null
absence_reason_id uuid 2147483647 null
accompanied_by_id uuid 2147483647 null
transport_id uuid 2147483647 null
start date 13 null
end date 13 null
repeat bool 1 null
comments text 2147483647 √ null
reason_path jsonb 2147483647 null
schedule jsonb 2147483647 √ null
legacy_id int8 19 √ null
locations jsonb 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
pk_tap_authorisation_audit Primary key Asc/Asc id + rev_id

Relationships

Close relationships within degrees of separation