reference_data

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('reference_data_id_seq'::regclass)
reference_data_domain_link.id fk_reference_data_domain_link_reference_data R
reference_data_link.reference_data_id_1 fk_reference_data_one R
reference_data_link.reference_data_id_2 fk_reference_data_two R
temporary_absence_authorisation.absence_reason_category_id fk_temporary_absence_authorisation_absence_reason_category_id R
temporary_absence_authorisation.absence_reason_id fk_temporary_absence_authorisation_absence_reason_id R
temporary_absence_authorisation.absence_sub_type_id fk_temporary_absence_authorisation_absence_sub_type_id R
temporary_absence_authorisation.absence_type_id fk_temporary_absence_authorisation_absence_type_id R
temporary_absence_authorisation.status_id fk_temporary_absence_authorisation_status_id R
temporary_absence_movement.absence_reason_id fk_temporary_absence_movement_absence_reason_id R
temporary_absence_movement.accompanied_by_id fk_temporary_absence_movement_accompanied_by_id R
temporary_absence_occurrence.accompanied_by_id fk_temporary_absence_occurrence_accompanied_by_id R
temporary_absence_occurrence.transport_id fk_temporary_absence_occurrence_transport_id R
domain varchar 32 null
reference_data_domain.code fk_reference_data_domain R
code varchar 16 null
description varchar 255 null
hint_text varchar 255 √ null
sequence_number int4 10 null
active bool 1 null

Indexes

Constraint Name Type Sort Column(s)
pk_reference_data Primary key Asc id
uq_domain_code Must be unique Asc/Asc domain + code
uq_domain_sequence_number Must be unique Asc/Asc domain + sequence_number

Relationships

Close relationships within degrees of separation