Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| variable_id | int8 | 19 | null |
|
|
|||||||
| variable_type_id | int4 | 10 | null |
|
|
|||||||
| parent_variable_id | int8 | 19 | √ | null |
|
|
||||||
| parent_variable_type_id | int4 | 10 | √ | null |
|
|
||||||
| 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_parent_variable_type_id_check | (((parent_variable_type_id IS NULL) OR (parent_variable_type_id = 8))) |
| variable_sections_variable_type_id_check | ((variable_type_id = 8)) |