reports

0 rows


Description

Accelerator project reports.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
report_project_metrics.report_id report_project_metrics_report_id_fkeyC
report_standard_metrics.report_id report_standard_metrics_report_id_fkeyC
config_id int8 19 null
project_report_configs.id reports_config_id_project_id_fkeyR
project_id int8 19 null
projects.id reports_project_id_fkeyC
project_report_configs.project_id reports_config_id_project_id_fkeyR
status_id int4 10 √ null
report_statuses.id reports_status_id_fkeyR
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_fkeyR
created_time timestamptz 35,6 null
modified_by int8 19 null
users.id reports_modified_by_fkeyR
modified_time timestamptz 35,6 null
submitted_by int8 19 √ null
users.id reports_submitted_by_fkeyR
submitted_time timestamptz 35,6 √ 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
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)))
reports_check ((end_date > start_date))

Relationships

Close relationships within degrees of separation