auto_calculated_indicators

-1 rows


Description

(Enum) Accelerator report auto-calculated indicators, for which data are collected from Terraware.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
auto_calculated_indicator_targets.auto_calculated_indicator_id auto_calculated_indicator_tar_auto_calculated_indicator_id_fkey C
report_auto_calculated_indicator_targets.auto_calculated_indicator_id report_auto_calculated_indicator_targets_auto_calculated_indica C
report_auto_calculated_indicators.auto_calculated_indicator_id report_auto_calculated_indicators_auto_calculated_indicator_id_ R
published_auto_calculated_indicator_baselines.auto_calculated_indicator_id published_auto_calculated_ind_auto_calculated_indicator_id_fkey C
published_auto_calculated_indicator_targets.auto_calculated_indicator_id published_auto_calculated_indicator_targets_auto_calculated_ind C
published_report_auto_calculated_indicators.auto_calculated_indicator_id published_report_auto_calculated_indicators_auto_calculated_ind R
name text 2147483647 null
level_id int4 10 null
indicator_levels.id auto_calculated_indicators_level_id_fkey R
category_id int4 10 null
indicator_categories.id auto_calculated_indicators_category_id_fkey R
description text 2147483647 √ null
ref_id text 2147483647 null
is_publishable bool 1 null
unit text 2147483647 √ null
primary_data_source text 2147483647 √ null
notes text 2147483647 √ null
active bool 1 true
class_id int4 10 null
indicator_classes.id auto_calculated_indicators_class_id_fkey R
frequency_id int4 10 √ null
indicator_frequencies.id auto_calculated_indicators_frequency_id_fkey R
tf_owner text 2147483647 √ null
precision int4 10 0

Indexes

Constraint Name Type Sort Column(s)
auto_calculated_indicators_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation