variable_sections

-1 rows


Description

Hierarchy of sections that define the structure of the rendered document.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
variable_id int8 19 null
variables.id variable_sections_variable_id_variable_type_id_fkey C
variable_type_id int4 10 null
variables.variable_type_id variable_sections_variable_id_variable_type_id_fkey C
variable_types.id variable_sections_variable_type_id_fkey R
parent_variable_id int8 19 √ null
variables.id variable_sections_parent_variable_id_parent_variable_type__fkey C
parent_variable_type_id int4 10 √ null
variables.variable_type_id variable_sections_parent_variable_id_parent_variable_type__fkey C
variable_types.id variable_sections_parent_variable_type_id_fkey R
render_heading bool 1 true

If false, the title is not included in the rendered document. False in cases where we want a single section to have multiple content blocks; in that case, we add them as child sections with this flag set to false.

Indexes

Constraint Name Type Sort Column(s)
variable_sections_pkey Primary key Asc variable_id

Check Constraints

Constraint Name Constraint
variable_sections_variable_type_id_check (variable_type_id = 8)
variable_sections_parent_variable_type_id_check ((parent_variable_type_id IS NULL) OR (parent_variable_type_id = 8))

Relationships

Close relationships within degrees of separation