project_indicators

-1 rows


Description

Indicators specific to one project to report on.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
project_indicator_targets.project_indicator_id project_indicator_targets_project_indicator_id_fkey C
report_project_indicator_targets.project_indicator_id report_project_indicator_targets_project_indicator_id_fkey C
report_project_indicators.project_indicator_id report_project_indicators_project_indicator_id_fkey R
published_project_indicator_baselines.project_indicator_id published_project_indicator_baselines_project_indicator_id_fkey C
published_project_indicator_targets.project_indicator_id published_project_indicator_targets_project_indicator_id_fkey C
published_report_project_indicators.project_indicator_id published_report_project_indicators_project_indicator_id_fkey R
project_id int8 19 null
projects.id project_indicators_project_id_fkey C
level_id int4 10 null
indicator_levels.id project_indicators_level_id_fkey R
category_id int4 10 null
indicator_categories.id project_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 project_indicators_class_id_fkey R
frequency_id int4 10 √ null
indicator_frequencies.id project_indicators_frequency_id_fkey R
tf_owner text 2147483647 √ null
precision int4 10 0

Indexes

Constraint Name Type Sort Column(s)
project_indicators_pkey Primary key Asc id
project_indicators_project_id_idx Performance Asc project_id

Relationships

Close relationships within degrees of separation