variable_values

0 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_fkeyR
variable_link_values.variable_value_id variable_link_values_variable_value_id_variable_id_variabl_fkeyR
variable_section_values.variable_value_id variable_section_values_variable_value_id_variable_id_vari_fkeyR
variable_select_option_values.variable_value_id variable_select_option_values_variable_value_id_variable_i_fkeyR
variable_value_table_rows.table_row_value_id variable_value_table_rows_table_row_value_id_fkeyC
variable_value_table_rows.variable_value_id variable_value_table_rows_variable_value_id_fkeyC
variable_workflow_history.max_variable_value_id variable_workflow_history_max_variable_value_id_fkeyR
project_id int8 19 null
projects.id variable_values_project_id_fkeyC
variable_id int8 19 null
variable_image_values.variable_id variable_image_values_variable_value_id_variable_id_variab_fkeyR
variable_link_values.variable_id variable_link_values_variable_value_id_variable_id_variabl_fkeyR
variable_section_values.variable_id variable_section_values_variable_value_id_variable_id_vari_fkeyR
variable_select_option_values.variable_id variable_select_option_values_variable_value_id_variable_i_fkeyR
variables.id variable_values_variable_id_variable_type_id_fkeyR
variable_type_id int4 10 null
variable_image_values.variable_type_id variable_image_values_variable_value_id_variable_id_variab_fkeyR
variable_link_values.variable_type_id variable_link_values_variable_value_id_variable_id_variabl_fkeyR
variable_section_values.variable_type_id variable_section_values_variable_value_id_variable_id_vari_fkeyR
variable_select_option_values.variable_type_id variable_select_option_values_variable_value_id_variable_i_fkeyR
variables.variable_type_id variable_values_variable_id_variable_type_id_fkeyR
variable_types.id variable_values_variable_type_id_fkeyR
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 131089 null
text_value text 2147483647 null
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_check1 (((text_value IS NULL) OR (variable_type_id = 2)))
variable_values_check (((number_value IS NULL) OR (variable_type_id = 1)))

Relationships