variables

-1 rows


Description

variables that can be supplied by the user. This table stores the variables themselves, not the values of the variables in a particular document. Type-specific information is in child tables such as variable_numbers.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
deliverable_variables.variable_id deliverable_variables_variable_id_fkey C
variable_image_values.variable_id variable_image_values_variable_id_fkey R
variable_link_values.variable_id variable_link_values_variable_id_fkey R
variable_manifest_entries.variable_id variable_manifest_entries_variable_id_fkey R
variable_numbers.variable_id variable_numbers_variable_id_variable_type_id_fkey R
variable_owners.variable_id variable_owners_variable_id_fkey R
variable_section_default_values.used_variable_id variable_section_default_values_used_variable_id_fkey C
variable_section_default_values.variable_id variable_section_default_values_variable_id_fkey C
variable_section_recommendations.recommended_variable_id variable_section_recommendations_recommended_variable_id_fkey C
variable_section_recommendations.section_variable_id variable_section_recommendations_section_variable_id_fkey C
variable_section_values.used_variable_id variable_section_values_used_variable_id_used_variable_typ_fkey R
variable_section_values.variable_id variable_section_values_variable_id_fkey R
variable_sections.parent_variable_id variable_sections_parent_variable_id_parent_variable_type__fkey C
variable_sections.variable_id variable_sections_variable_id_variable_type_id_fkey C
variable_select_options.variable_id variable_select_options_variable_id_fkey C
variable_selects.variable_id variable_selects_variable_id_variable_type_id_fkey C
variable_table_columns.table_variable_id variable_table_columns_table_variable_id_fkey R
variable_table_columns.variable_id variable_table_columns_variable_id_fkey R
variable_tables.variable_id variable_tables_variable_id_variable_type_id_fkey C
variable_texts.variable_id variable_texts_variable_id_variable_type_id_fkey C
variable_values.variable_id variable_values_variable_id_variable_type_id_fkey R
variable_workflow_history.variable_id variable_workflow_history_variable_id_fkey R
variables.replaces_variable_id variables_replaces_variable_id_fkey N
variable_type_id int4 10 null
variable_numbers.variable_type_id variable_numbers_variable_id_variable_type_id_fkey R
variable_section_default_values.used_variable_type_id variable_section_default_valu_used_variable_id_used_variab_fkey R
variable_section_default_values.variable_type_id variable_section_default_valu_variable_id_variable_type_id_fkey R
variable_section_values.used_variable_type_id variable_section_values_used_variable_id_used_variable_typ_fkey R
variable_sections.parent_variable_type_id variable_sections_parent_variable_id_parent_variable_type__fkey C
variable_sections.variable_type_id variable_sections_variable_id_variable_type_id_fkey C
variable_selects.variable_type_id variable_selects_variable_id_variable_type_id_fkey C
variable_tables.variable_type_id variable_tables_variable_id_variable_type_id_fkey C
variable_texts.variable_type_id variable_texts_variable_id_variable_type_id_fkey C
variable_values.variable_type_id variable_values_variable_id_variable_type_id_fkey R
variable_types.id variables_variable_type_id_fkey R
replaces_variable_id int8 19 √ null
variables.id variables_replaces_variable_id_fkey N

If this is a new version of a variable that existed in a previous manifest version, the ID of the previous version of the variable. This allows the system to automatically migrate values from older variable versions when a document is updated to a new manifest version.
is_list bool 1 false

True if this variable is a list of values rather than a single value. If the variable is a table, true if the table can contain multiple rows.
stable_id text 2147483647 null
name text 2147483647 null
description text 2147483647 √ null
deliverable_question text 2147483647 √ null
dependency_variable_stable_id text 2147483647 √ null
dependency_condition_id int4 10 √ null
dependency_conditions.id variables_dependency_condition_id_fkey R
dependency_value text 2147483647 √ null
internal_only bool 1 false
is_required bool 1 null

Indexes

Constraint Name Type Sort Column(s)
variables_pkey Primary key Asc id
cannot_have_multiple_replacements Must be unique Asc replaces_variable_id
variables_id_variable_type_id_key Must be unique Asc/Asc id + variable_type_id

Relationships

Close relationships within degrees of separation