reference_data - keyworker-api-db.public

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
recorded_event.type_id	recorded_event_type_id_fkey	R
reference_data_policy.id	reference_data_policy_id_fkey	R
staff_configuration.status_id	key_worker_status_id_fkey	R

domain

varchar

32

null

code

varchar

32

null

description

varchar

128

null

sequence_number

int4

10

null

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