temporary_absence_occurrence_audit

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
rev_id int8 19 null
audit_revision.id temporary_absence_occurrence_audit_rev_id_fkey R
rev_type int2 5 null
id uuid 2147483647 null
person_identifier varchar 10 null
authorisation_id uuid 2147483647 null
release_at timestamp 29,6 null
return_by timestamp 29,6 null
accompanied_by_id int8 19 null
transport_id int8 19 null
contact_information text 2147483647 √ null
notes text 2147483647 √ null
added_at timestamp 29,6 null
added_by varchar 64 null
cancelled_at timestamp 29,6 √ null
cancelled_by varchar 64 √ null
legacy_id int8 19 √ null
location jsonb 2147483647 null
schedule_reference jsonb 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation