variable_section_default_values

0 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_fkeyC
variable_type_id int4 10 null
variables.variable_type_id variable_section_default_valu_variable_id_variable_type_id_fkeyR
variable_types.id variable_section_default_values_variable_type_id_fkeyR
variable_manifest_id int8 19 null
variable_manifests.id variable_section_default_values_variable_manifest_id_fkeyC
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_fkeyC
used_variable_type_id int4 10 √ null
variables.variable_type_id variable_section_default_valu_used_variable_id_used_variab_fkeyR
variable_types.id variable_section_default_values_used_variable_type_id_fkeyR
usage_type_id int4 10 √ null
variable_usage_types.id variable_section_default_values_usage_type_id_fkeyR
display_style_id int4 10 √ null
variable_injection_display_styles.id variable_section_default_values_display_style_id_fkeyR

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_have_both_text_and_reference (((text_value IS NULL) OR (used_variable_id IS NULL)))
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))

Relationships

Close relationships within degrees of separation