reference_data

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('reference_data_id_seq'::regclass)
allocation.allocation_reason_id allocation_allocation_reason_id_fkey R
allocation.deallocation_reason_id allocation_deallocation_reason_id_fkey R
staff_configuration.status_id key_worker_status_id_fkey R
zz_archived_legacy_keyworker_allocation.allocation_reason_id offender_key_worker_allocation_reason_id_fkey R
zz_archived_legacy_keyworker_allocation.deallocation_reason_id offender_key_worker_deallocation_reason_id_fkey R
domain varchar 32 null
code varchar 32 null
description varchar 128 null
sequence_number int4 10 null

Indexes

Constraint Name Type Sort Column(s)
reference_data_pkey Primary key Asc id
unq_reference_data_domain_code Must be unique Asc/Asc domain + code
unq_reference_data_domain_sequence Must be unique Asc/Asc domain + sequence_number

Relationships

Close relationships within degrees of separation