variable_selects

0 rows


Description

Information about select variables that is not relevant for other variable types. This table only has information about the variable as a whole; the options are in variable_select_options.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
variable_id int8 19 null
variable_select_option_values.variable_id variable_select_option_values_variable_id_fkeyR
variable_select_options.variable_id variable_select_options_variable_id_variable_type_id_fkeyC
variables.id variable_selects_variable_id_variable_type_id_fkeyC
variable_type_id int4 10 null
variable_select_options.variable_type_id variable_select_options_variable_id_variable_type_id_fkeyC
variables.variable_type_id variable_selects_variable_id_variable_type_id_fkeyC
variable_types.id variable_selects_variable_type_id_fkeyR
is_multiple bool 1 null

If true, allow multiple options to be selected. The list of selected options is considered a single value; do not set variables.is_list to true unless you want a list of multiple-select variables.

Indexes

Constraint Name Type Sort Column(s)
variable_selects_pkey Primary key Asc variable_id
variable_selects_variable_id_variable_type_id_key Must be unique Asc/Asc variable_id + variable_type_id

Check Constraints

Constraint Name Constraint
variable_selects_variable_type_id_check ((variable_type_id = 5))

Relationships

Close relationships within degrees of separation