variable_values

-1 rows


Description

Insert-only table with all historical and current values of all inputs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
variable_image_values.variable_value_id variable_image_values_variable_value_id_variable_id_variab_fkey R
variable_link_values.variable_value_id variable_link_values_variable_value_id_variable_id_variabl_fkey R
variable_section_values.variable_value_id variable_section_values_variable_value_id_variable_id_vari_fkey R
variable_select_option_values.variable_value_id variable_select_option_values_variable_value_id_variable_i_fkey R
variable_value_table_rows.table_row_value_id variable_value_table_rows_table_row_value_id_fkey C
variable_value_table_rows.variable_value_id variable_value_table_rows_variable_value_id_fkey C
variable_workflow_history.max_variable_value_id variable_workflow_history_max_variable_value_id_fkey R
project_id int8 19 null
projects.id variable_values_project_id_fkey C
variable_id int8 19 null
variable_image_values.variable_id variable_image_values_variable_value_id_variable_id_variab_fkey R
variable_link_values.variable_id variable_link_values_variable_value_id_variable_id_variabl_fkey R
variable_section_values.variable_id variable_section_values_variable_value_id_variable_id_vari_fkey R
variable_select_option_values.variable_id variable_select_option_values_variable_value_id_variable_i_fkey R
variables.id variable_values_variable_id_variable_type_id_fkey R
variable_type_id int4 10 null
variable_image_values.variable_type_id variable_image_values_variable_value_id_variable_id_variab_fkey R
variable_link_values.variable_type_id variable_link_values_variable_value_id_variable_id_variabl_fkey R
variable_section_values.variable_type_id variable_section_values_variable_value_id_variable_id_vari_fkey R
variable_select_option_values.variable_type_id variable_select_option_values_variable_value_id_variable_i_fkey R
variable_types.id variable_values_variable_type_id_fkey R
variables.variable_type_id variable_values_variable_id_variable_type_id_fkey R
list_position int4 10 0
created_by int8 19 '-1'::integer
users.id variable_values_created_by_fkey
created_time timestamptz 35,6 null
is_deleted bool 1 false
number_value numeric 0 √ null
text_value text 2147483647 √ null

For text or email variables, the variable’s value. May contain newlines if the text variable is multi-line.
date_value date 13 √ null
citation text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
variable_values_pkey Primary key Asc id
variable_values_project_id_idx Performance Asc project_id
variable_values_variable_id_id_key Must be unique Asc/Asc variable_id + id
variable_values_variable_id_variable_type_id_id_key Must be unique Asc/Asc/Asc variable_id + variable_type_id + id

Check Constraints

Constraint Name Constraint
variable_values_check ((number_value IS NULL) OR (variable_type_id = 1))
text_value_is_text_or_email ((text_value IS NULL) OR (variable_type_id = ANY (ARRAY[2, 9])))

Relationships

Close relationships within degrees of separation