published_reports

-1 rows


Description

Published reports visible to funders.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
report_id int8 19 null
published_report_achievements.report_id published_report_achievements_report_id_fkey C
published_report_challenges.report_id published_report_challenges_report_id_fkey C
published_report_project_metrics.report_id published_report_project_metrics_report_id_fkey C
published_report_standard_metrics.report_id published_report_standard_metrics_report_id_fkey C
published_report_system_metrics.report_id published_report_system_metrics_report_id_fkey C
reports.id published_reports_report_id_fkey C
project_id int8 19 null
projects.id published_reports_project_id_fkey C
report_frequency_id int4 10 null
report_frequencies.id published_reports_report_frequency_id_fkey R
report_quarter_id int4 10 √ null
report_quarters.id published_reports_report_quarter_id_fkey R
start_date date 13 null
end_date date 13 null
highlights text 2147483647 √ null
published_by int8 19 null
users.id published_reports_published_by_fkey R
published_time timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
published_reports_pkey Primary key Asc report_id
published_reports_project_id_idx Performance Asc project_id

Check Constraints

Constraint Name Constraint
published_reports_check (end_date > start_date)

Relationships

Close relationships within degrees of separation