common_indicators

-1 rows


Description

Standard non-system indicators for every project to measure in accelerator reports.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
common_indicator_targets.common_indicator_id common_indicator_targets_common_indicator_id_fkey C
report_common_indicator_targets.common_indicator_id report_common_indicator_targets_common_indicator_id_fkey C
report_common_indicators.common_indicator_id report_common_indicators_common_indicator_id_fkey R
published_common_indicator_baselines.common_indicator_id published_common_indicator_baselines_common_indicator_id_fkey C
published_common_indicator_targets.common_indicator_id published_common_indicator_targets_common_indicator_id_fkey C
published_report_common_indicators.common_indicator_id published_report_common_indicators_common_indicator_id_fkey R
level_id int4 10 null
indicator_levels.id common_indicators_level_id_fkey R
category_id int4 10 null
indicator_categories.id common_indicators_category_id_fkey R
name text 2147483647 null
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 standard_indicators_class_id_fkey R
frequency_id int4 10 √ null
indicator_frequencies.id standard_indicators_frequency_id_fkey R
tf_owner text 2147483647 √ null
precision int4 10 0

Indexes

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

Relationships

Close relationships within degrees of separation