variable_section_default_values

-1 rows


Description

Section values that are set by default on newly-created documents.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
variable_id int8 19 null
variables.id variable_section_default_values_variable_id_fkey C
variable_type_id int4 10 null
variables.variable_type_id variable_section_default_valu_variable_id_variable_type_id_fkey R
variable_types.id variable_section_default_values_variable_type_id_fkey R
variable_manifest_id int8 19 null
variable_manifests.id variable_section_default_values_variable_manifest_id_fkey C
list_position int4 10 null
text_value text 2147483647 √ null
used_variable_id int8 19 √ null
variables.id variable_section_default_values_used_variable_id_fkey C
used_variable_type_id int4 10 √ null
variables.variable_type_id variable_section_default_valu_used_variable_id_used_variab_fkey R
variable_types.id variable_section_default_values_used_variable_type_id_fkey R
usage_type_id int4 10 √ null
variable_usage_types.id variable_section_default_values_usage_type_id_fkey R
display_style_id int4 10 √ null
variable_injection_display_styles.id variable_section_default_values_display_style_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
variable_section_default_values_pkey Primary key Asc id
variable_section_default_valu_variable_manifest_id_variable_key Must be unique Asc/Asc/Asc variable_manifest_id + variable_id + list_position
variable_section_default_values_used_variable_id_idx Performance Asc used_variable_id

Check Constraints

Constraint Name Constraint
cannot_reference_other_sections ((used_variable_type_id IS NULL) OR (used_variable_type_id <> 8))
must_have_text_or_reference ((text_value IS NOT NULL) OR (used_variable_id IS NOT NULL))
variable_section_default_values_variable_type_id_check (variable_type_id = 8)
cannot_have_both_text_and_reference ((text_value IS NULL) OR (used_variable_id IS NULL))

Relationships

Close relationships within degrees of separation