variable_section_recommendations

0 rows


Description

Which sections recommend using which other variables. Can vary between manifests.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
section_variable_id int8 19 null
variables.id variable_section_recommendations_section_variable_id_fkeyC
section_variable_type_id int4 10 null
variable_types.id variable_section_recommendations_section_variable_type_id_fkeyR
recommended_variable_id int8 19 null
variables.id variable_section_recommendations_recommended_variable_id_fkeyC
variable_manifest_id int8 19 null
variable_manifests.id variable_section_recommendations_variable_manifest_id_fkeyC

Indexes

Constraint Name Type Sort Column(s)
variable_section_recommendations_pkey Primary key Asc/Asc/Asc section_variable_id + variable_manifest_id + recommended_variable_id
variable_section_recommendati_recommended_variable_id_varia_key Must be unique Asc/Asc/Asc recommended_variable_id + variable_manifest_id + section_variable_id

Check Constraints

Constraint Name Constraint
variable_section_recommendations_section_variable_type_id_check ((section_variable_type_id = 8))

Relationships

Close relationships within degrees of separation