variable_section_values

-1 rows


Description

Fragments of the contents of document sections. Each fragment is either a block of text or a usage of a variable; they are assembled in order to render the contents of the section.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
variable_value_id int8 19 null
variable_values.id variable_section_values_variable_value_id_variable_id_vari_fkey R
variable_id int8 19 null
variables.id variable_section_values_variable_id_fkey R
variable_values.variable_id variable_section_values_variable_value_id_variable_id_vari_fkey R
variable_type_id int4 10 null
variable_values.variable_type_id variable_section_values_variable_value_id_variable_id_vari_fkey R
variable_types.id variable_section_values_variable_type_id_fkey R
usage_type_id int4 10 √ null
variable_usage_types.id variable_section_values_usage_type_id_fkey R
text_value text 2147483647 √ null
used_variable_id int8 19 √ null
variables.id variable_section_values_used_variable_id_used_variable_typ_fkey R
used_variable_type_id int4 10 √ null
variables.variable_type_id variable_section_values_used_variable_id_used_variable_typ_fkey R
variable_types.id variable_section_values_used_variable_type_id_fkey R
display_style_id int4 10 √ null
variable_injection_display_styles.id variable_section_values_display_style_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
variable_section_values_pkey Primary key Asc variable_value_id
variable_section_values_used_variable_id_idx Performance Asc used_variable_id

Check Constraints

Constraint Name Constraint
reference_only_for_figures_and_sections ((usage_type_id <> 2) OR (used_variable_type_id = ANY (ARRAY[4, 6, 8])))
cannot_reference_other_sections ((used_variable_type_id IS NULL) OR (used_variable_type_id <> 8))
cannot_have_both_text_and_reference ((text_value IS NULL) OR (used_variable_id IS NULL))
cannot_inject_sections (NOT ((usage_type_id = 1) AND (used_variable_type_id = 8)))
injection_has_display_style ((usage_type_id = 1) = (display_style_id IS NOT NULL))
usages_must_have_types ((used_variable_id IS NULL) = (usage_type_id IS NULL))
must_have_text_or_reference ((text_value IS NOT NULL) OR (used_variable_id IS NOT NULL))

Relationships

Close relationships within degrees of separation