variable_select_options

-1 rows


Description

Available options for select variables.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
variable_select_option_values.option_id variable_select_option_values_option_id_variable_id_fkey R
variable_id int8 19 null
variable_select_option_values.variable_id variable_select_option_values_option_id_variable_id_fkey R
variables.id variable_select_options_variable_id_fkey C
variable_selects.variable_id variable_select_options_variable_id_variable_type_id_fkey C
variable_type_id int4 10 null
variable_types.id variable_select_options_variable_type_id_fkey R
variable_selects.variable_type_id variable_select_options_variable_id_variable_type_id_fkey C
position int4 10 null
name text 2147483647 null
description text 2147483647 √ null
rendered_text text 2147483647 √ null

What text should be rendered in the document when this option is selected. Null if the option’s name should be rendered.

Indexes

Constraint Name Type Sort Column(s)
variable_select_options_pkey Primary key Asc id
variable_select_options_id_variable_id_key Must be unique Asc/Asc id + variable_id

Relationships

Close relationships within degrees of separation