report_project_metrics

-1 rows


Description

Report entries of targets and values for project metrics.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
report_id int8 19 null
reports.id report_project_metrics_report_id_fkey C
project_metric_id int8 19 null
project_metrics.id report_project_metrics_project_metric_id_fkey R
target int4 10 √ null
value int4 10 √ null
underperformance_justification text 2147483647 √ null
progress_notes text 2147483647 √ null
modified_by int8 19 null
users.id report_project_metrics_modified_by_fkey R
modified_time timestamptz 35,6 null
status_id int4 10 √ null
report_metric_statuses.id report_project_metrics_status_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
report_project_metrics_pkey Primary key Asc/Asc report_id + project_metric_id
report_project_metrics_project_metric_id_idx Performance Asc project_metric_id
report_project_metrics_report_id_project_metric_id_idx Performance Asc/Asc report_id + project_metric_id

Relationships

Close relationships within degrees of separation