22 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| published_report_system_metrics_system_metric_id_fkey |
|
|
Restrict delete | ||
| published_report_system_metrics_status_id_fkey |
|
|
Restrict delete | ||
| published_report_system_metrics_report_id_fkey |
|
|
Cascade on delete | ||
| funding_entities_created_by_fkey |
|
|
Restrict delete | ||
| funding_entities_modified_by_fkey |
|
|
Restrict delete | ||
| published_report_challenges_report_id_fkey |
|
|
Cascade on delete | ||
| published_reports_report_id_fkey |
|
|
Cascade on delete | ||
| published_reports_report_frequency_id_fkey |
|
|
Restrict delete | ||
| published_reports_project_id_fkey |
|
|
Cascade on delete | ||
| published_reports_published_by_fkey |
|
|
Restrict delete | ||
| published_reports_report_quarter_id_fkey |
|
|
Restrict delete | ||
| published_report_standard_metrics_status_id_fkey |
|
|
Restrict delete | ||
| published_report_standard_metrics_report_id_fkey |
|
|
Cascade on delete | ||
| published_report_standard_metrics_standard_metric_id_fkey |
|
|
Restrict delete | ||
| funding_entity_users_funding_entity_id_fkey |
|
|
Cascade on delete | ||
| funding_entity_users_user_id_fkey |
|
|
Cascade on delete | ||
| funding_entity_projects_funding_entity_id_fkey |
|
|
Cascade on delete | ||
| funding_entity_projects_project_id_fkey |
|
|
Cascade on delete | ||
| published_report_project_metrics_project_metric_id_fkey |
|
|
Restrict delete | ||
| published_report_project_metrics_status_id_fkey |
|
|
Restrict delete | ||
| published_report_project_metrics_report_id_fkey |
|
|
Cascade on delete | ||
| published_report_achievements_report_id_fkey |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| published_report_challenges | published_report_challenges_position_check | ("position" >= 0) |
| published_reports | published_reports_check | (end_date > start_date) |
| published_report_achievements | published_report_achievements_position_check | ("position" >= 0) |