Table hierarchy_topic
Node in a hierarchy

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int8 19
hierarchy_topic.parent_id fk12ba86a51152333c R
hierarchy_topic_add_idefs.hierarchy_topic_id fkda58f6bfe27af61 R
hierarchy_topic_add_schemas.hierarchy_topic_id fkb76982bae27af61 R
hierarchy_topic_all_parents.all_parents_id fk5a4911d13b841bdb R
hierarchy_topic_all_parents.hierarchy_topic_id fk5a4911d1e27af61 R
hierarchy_topic_attributes.hierarchy_topic_id fk20214f31e27af61 R
hierarchy_topic_inh_idefs.hierarchy_topic_id fk5ee11c81e27af61 R
hierarchy_topic_inh_schemas.hierarchy_topic_id fk3a7f3ffce27af61 R
hierarchy_topic_key_resources.hierarchy_topic_id fka591802be27af61 R
freetext varchar 100  √  null
hide_subtopics_with_no_result bool 1  √  null
inherit_freetext bool 1
list_position int4 10
show_results bool 1
uuid varchar 40
virtualisation_id varchar 100  √  null
virtualisation_path varchar 255  √  null
advanced_search_id int8 19  √  null
power_search.id fk12ba86a5282920d0 R
institution_id int8 19
institution.id fk12ba86a5bc711081 R
long_description_id int8 19  √  null
language_bundle.id fk12ba86a54ac8a50d R
name_id int8 19  √  null
language_bundle.id fk12ba86a5d4838ffb R
parent_id int8 19  √  null
hierarchy_topic.id fk12ba86a51152333c R
results_section_name_id int8 19  √  null
language_bundle.id fk12ba86a5b14de658 R
short_description_id int8 19  √  null
language_bundle.id fk12ba86a5d8e2270d R
subtopics_section_name_id int8 19  √  null
language_bundle.id fk12ba86a54f36f5c6 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc hierarchy_topic_pkey
advanced_search_id Performance Asc hiearchypowersearch
institution_id Performance Asc hierarchyinstitutionindex
long_description_id Performance Asc hierarchylongdescription
name_id Performance Asc hierarchyname
results_section_name_id Performance Asc hierarchyrsname
short_description_id Performance Asc hierarchyshortdescription
subtopics_section_name_id Performance Asc hierarchysname
uuid Performance Asc hierarchyuuidindex
parent_id Performance Asc parenttopic

Close relationships  within of separation: