reports

-1 rows


Description

Accelerator project reports.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
report_achievements.report_id report_achievements_report_id_fkey C
report_challenges.report_id report_challenges_report_id_fkey C
report_photos.report_id report_photos_report_id_fkey R
report_project_metrics.report_id report_project_metrics_report_id_fkey C
report_standard_metrics.report_id report_standard_metrics_report_id_fkey C
report_system_metrics.report_id report_system_metrics_report_id_fkey C
published_reports.report_id published_reports_report_id_fkey C
config_id int8 19 null
project_report_configs.id reports_config_id_report_frequency_id_fkey R
project_id int8 19 null
projects.id reports_project_id_fkey C
project_report_configs.project_id reports_config_id_project_id_fkey R
status_id int4 10 √ null
report_statuses.id reports_status_id_fkey R
start_date date 13 null
end_date date 13 null
internal_comment text 2147483647 √ null
feedback text 2147483647 √ null
created_by int8 19 null
users.id reports_created_by_fkey R
created_time timestamptz 35,6 null
modified_by int8 19 null
users.id reports_modified_by_fkey R
modified_time timestamptz 35,6 null
submitted_by int8 19 √ null
users.id reports_submitted_by_fkey R
submitted_time timestamptz 35,6 √ null
highlights text 2147483647 √ null
report_frequency_id int4 10 null
report_frequencies.id reports_report_frequency_id_fkey R
project_report_configs.report_frequency_id reports_config_id_report_frequency_id_fkey R

Frequency of the report, that can determine report data. Must match with frequency of the configuration.
report_quarter_id int4 10 √ null
report_quarters.id reports_report_quarter_id_fkey R

Quarter of the report. Must be non-null for quarterly reports and null otherwise.
upcoming_notification_sent_time timestamptz 35,6 √ null
financial_summaries text 2147483647 √ null
additional_comments text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
reports_pkey Primary key Asc id
reports_end_date_idx Performance Asc end_date
reports_project_id_idx Performance Asc project_id

Check Constraints

Constraint Name Constraint
quarterly_report_has_quarter (((report_frequency_id = 1) AND (report_quarter_id IS NOT NULL) AND ((report_quarter_id)::numeric = EXTRACT(quarter FROM start_date)) AND ((report_quarter_id)::numeric = EXTRACT(quarter FROM end_date))) OR ((report_frequency_id <> 1) AND (report_quarter_id IS NULL)))
reports_check (end_date > start_date)
submitted_status (((status_id = 1) AND (submitted_by IS NULL) AND (submitted_time IS NULL)) OR (((status_id = 2) OR (status_id = 3) OR (status_id = 4)) AND (submitted_by IS NOT NULL) AND (submitted_time IS NOT NULL)) OR (status_id = 5))

Relationships

Close relationships within degrees of separation