temporary_absence_authorisation_audit

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
rev_id int8 19 null
audit_revision.id temporary_absence_authorisation_audit_rev_id_fkey R
rev_type int2 5 null
id uuid 2147483647 null
person_identifier varchar 10 null
prison_code varchar 6 null
absence_type_id int8 19 √ null
absence_sub_type_id int8 19 √ null
absence_reason_id int8 19 √ null
repeat bool 1 null
status_id int8 19 null
notes text 2147483647 √ null
application_date date 13 null
submitted_at timestamp 29,6 null
submitted_by varchar 64 null
approved_at timestamp 29,6 √ null
approved_by varchar 64 √ null
legacy_id int8 19 √ null
from_date date 13 null
to_date date 13 null
schedule jsonb 2147483647 √ null
absence_reason_category_id int8 19 √ null
reason_path jsonb 2147483647 null

Indexes

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

Relationships

Close relationships within degrees of separation