allocation_audit

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
rev_id int8 19 null
audit_revision.id allocation_audit_rev_id_fkey R
rev_type int2 5 null
id uuid 2147483647 null
prison_code varchar 6 null
prison_migration_date_history.prison_code Implied Constraint R
staff_id int8 19 null
person_identifier varchar 10 null
allocated_at timestamp 29,6 null
allocation_type bpchar 1 null
allocated_by varchar 64 null
allocation_reason_id int8 19 null
deallocated_at timestamp 29,6 null
deallocation_reason_id int8 19 null
deallocated_by varchar 64 null
is_active bool 1 null
policy_code varchar 16 null
policy.code Implied Constraint R
person_identifier_modified bool 1 null
deallocated_at_modified bool 1 null
deallocation_reason_modified bool 1 null
deallocated_by_modified bool 1 null
is_active_modified bool 1 null

Indexes

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

Relationships