variable_section_recommendations

-1 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_fkey C
section_variable_type_id int4 10 null
variable_types.id variable_section_recommendations_section_variable_type_id_fkey R
recommended_variable_id int8 19 null
variables.id variable_section_recommendations_recommended_variable_id_fkey C
variable_manifest_id int8 19 null
variable_manifests.id variable_section_recommendations_variable_manifest_id_fkey C

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