variable_select_option_values

0 rows


Description

The options of a select variable that are selected in a document. Options that are not selected do not appear in this table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
variable_value_id int8 19 null
variable_values.id variable_select_option_values_variable_value_id_variable_i_fkeyR
variable_id int8 19 null
variable_values.variable_id variable_select_option_values_variable_value_id_variable_i_fkeyR
variable_selects.variable_id variable_select_option_values_variable_id_fkeyR
variable_select_options.variable_id variable_select_option_values_option_id_variable_id_fkeyR
variable_type_id int4 10 null
variable_values.variable_type_id variable_select_option_values_variable_value_id_variable_i_fkeyR
variable_types.id variable_select_option_values_variable_type_id_fkeyR
option_id int8 19 null
variable_select_options.id variable_select_option_values_option_id_variable_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
variable_select_option_values_pkey Primary key Asc/Asc variable_value_id + option_id

Check Constraints

Constraint Name Constraint
variable_select_option_values_variable_type_id_check ((variable_type_id = 5))

Relationships

Close relationships within degrees of separation