project_report_configs

0 rows


Description

Configurations for accelerator project reports, including reporting dates and reporting frequencies.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
reports.config_id reports_config_id_project_id_fkeyR
project_id int8 19 null
reports.project_id reports_config_id_project_id_fkeyR
projects.id project_report_configs_project_id_fkeyC
report_frequency_id int4 10 null
report_frequencies.id project_report_configs_report_frequency_id_fkeyR
reporting_start_date date 13 null
reporting_end_date date 13 null

Indexes

Constraint Name Type Sort Column(s)
project_report_configs_pkey Primary key Asc id
project_report_configs_id_project_id_key Must be unique Asc/Asc id + project_id
project_report_configs_project_id_idx Performance Asc project_id

Check Constraints

Constraint Name Constraint
project_report_configs_check ((reporting_end_date > reporting_start_date))

Relationships

Close relationships within degrees of separation