130 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||
|---|---|---|---|---|---|---|---|
| events_created_by_fkey |
|
|
Restrict delete | ||||
| events_modified_by_fkey |
|
|
Restrict delete | ||||
| events_event_type_id_fkey |
|
|
Restrict delete | ||||
| events_event_status_id_fkey |
|
|
Restrict delete | ||||
| events_module_id_fkey |
|
|
Cascade on delete | ||||
| deliverable_variables_deliverable_id_fkey |
|
|
Cascade on delete | ||||
| deliverable_variables_variable_id_fkey |
|
|
Cascade on delete | ||||
| report_project_metrics_modified_by_fkey |
|
|
Restrict delete | ||||
| report_project_metrics_project_metric_id_fkey |
|
|
Restrict delete | ||||
| report_project_metrics_status_id_fkey |
|
|
Restrict delete | ||||
| report_project_metrics_report_id_fkey |
|
|
Cascade on delete | ||||
| deliverable_cohort_due_dates_deliverable_id_fkey |
|
|
Cascade on delete | ||||
| deliverable_cohort_due_dates_cohort_id_fkey |
|
|
Cascade on delete | ||||
| modules_created_by_fkey |
|
|
Restrict delete | ||||
| modules_modified_by_fkey |
|
|
Restrict delete | ||||
| modules_phase_id_fkey |
|
|
Restrict delete | ||||
| project_scores_project_id_fkey |
|
|
Cascade on delete | ||||
| project_scores_phase_id_fkey |
|
|
Restrict delete | ||||
| project_scores_created_by_fkey |
|
|
Restrict delete | ||||
| project_scores_score_category_id_fkey |
|
|
Restrict delete | ||||
| project_scores_modified_by_fkey |
|
|
Restrict delete | ||||
| reports_status_id_fkey |
|
|
Restrict delete | ||||
| reports_config_id_fkey |
|
|
Restrict delete | ||||
| reports_config_id_project_id_fkey |
|
|
Restrict delete | ||||
| reports_config_id_report_frequency_id_fkey |
|
|
Restrict delete | ||||
| reports_project_id_fkey |
|
|
Cascade on delete | ||||
| reports_created_by_fkey |
|
|
Restrict delete | ||||
| reports_report_frequency_id_fkey |
|
|
Restrict delete | ||||
| reports_submitted_by_fkey |
|
|
Restrict delete | ||||
| reports_report_quarter_id_fkey |
|
|
Restrict delete | ||||
| reports_modified_by_fkey |
|
|
Restrict delete | ||||
| project_accelerator_details_pipeline_id_fkey |
|
|
Restrict delete | ||||
| project_accelerator_details_deal_stage_id_fkey |
|
|
Restrict delete | ||||
| project_accelerator_details_project_id_fkey |
|
|
Restrict delete | ||||
| cohort_modules_cohort_id_fkey |
|
|
Restrict delete | ||||
| cohort_modules_module_id_fkey |
|
|
Restrict delete | ||||
| report_system_metrics_system_metric_id_fkey |
|
|
Restrict delete | ||||
| report_system_metrics_status_id_fkey |
|
|
Restrict delete | ||||
| report_system_metrics_report_id_fkey |
|
|
Cascade on delete | ||||
| report_system_metrics_modified_by_fkey |
|
|
Restrict delete | ||||
| deliverable_documents_deliverable_type_id_fkey |
|
|
Restrict delete | ||||
| deliverable_documents_deliverable_id_deliverable_type_id_fkey |
|
|
Restrict delete | ||||
| deliverable_documents_deliverable_id_fkey |
|
|
Restrict delete | ||||
| project_overall_scores_modified_by_fkey |
|
|
Restrict delete | ||||
| project_overall_scores_created_by_fkey |
|
|
Restrict delete | ||||
| project_overall_scores_project_id_fkey |
|
|
Cascade on delete | ||||
| submission_snapshots_submission_id_fkey |
|
|
Restrict delete | ||||
| submission_snapshots_file_id_fkey |
|
|
Cascade on delete | ||||
| report_challenges_report_id_fkey |
|
|
Cascade on delete | ||||
| deliverables_created_by_fkey |
|
|
Restrict delete | ||||
| deliverables_deliverable_category_id_fkey |
|
|
Restrict delete | ||||
| deliverables_deliverable_type_id_fkey |
|
|
Restrict delete | ||||
| deliverables_module_id_fkey |
|
|
Restrict delete | ||||
| deliverables_modified_by_fkey |
|
|
Restrict delete | ||||
| default_voters_user_id_fkey |
|
|
Cascade on delete | ||||
| submission_documents_submission_id_fkey |
|
|
Restrict delete | ||||
| submission_documents_project_id_fkey |
|
|
Restrict delete | ||||
| submission_documents_document_store_id_fkey |
|
|
Restrict delete | ||||
| submission_documents_created_by_fkey |
|
|
Restrict delete | ||||
| report_photos_report_id_fkey |
|
|
Restrict delete | ||||
| report_photos_file_id_fkey |
|
|
Cascade on delete | ||||
| activity_media_files_activity_id_fkey |
|
|
Restrict delete | ||||
| activity_media_files_file_id_fkey |
|
|
Cascade on delete | ||||
| activity_media_files_activity_media_type_id_fkey |
|
|
Restrict delete | ||||
| report_standard_metrics_status_id_fkey |
|
|
Restrict delete | ||||
| report_standard_metrics_report_id_fkey |
|
|
Cascade on delete | ||||
| report_standard_metrics_standard_metric_id_fkey |
|
|
Restrict delete | ||||
| report_standard_metrics_modified_by_fkey |
|
|
Restrict delete | ||||
| participants_created_by_fkey |
|
|
Restrict delete | ||||
| participants_cohort_id_fkey |
|
|
Restrict delete | ||||
| participants_modified_by_fkey |
|
|
Restrict delete | ||||
| report_achievements_report_id_fkey |
|
|
Cascade on delete | ||||
| deliverable_project_due_dates_project_id_fkey |
|
|
Cascade on delete | ||||
| deliverable_project_due_dates_deliverable_id_fkey |
|
|
Cascade on delete | ||||
| project_report_configs_report_frequency_id_fkey |
|
|
Restrict delete | ||||
| project_report_configs_project_id_fkey |
|
|
Cascade on delete | ||||
| cohorts_phase_id_fkey |
|
|
Restrict delete | ||||
| cohorts_created_by_fkey |
|
|
Restrict delete | ||||
| cohorts_modified_by_fkey |
|
|
Restrict delete | ||||
| project_metrics_project_id_fkey |
|
|
Cascade on delete | ||||
| project_metrics_component_id_fkey |
|
|
Restrict delete | ||||
| project_metrics_type_id_fkey |
|
|
Restrict delete | ||||
| applications_country_code_fkey |
|
|
Restrict delete | ||||
| applications_project_id_fkey |
|
|
Cascade on delete | ||||
| applications_created_by_fkey |
|
|
Restrict delete | ||||
| applications_modified_by_fkey |
|
|
Restrict delete | ||||
| applications_application_status_id_fkey |
|
|
Restrict delete | ||||
| application_histories_modified_by_fkey |
|
|
Restrict delete | ||||
| application_histories_application_id_fkey |
|
|
Cascade on delete | ||||
| application_histories_application_status_id_fkey |
|
|
Restrict delete | ||||
| deliverable_categories_internal_interest_id_fkey |
|
|
Restrict delete | ||||
| system_metrics_component_id_fkey |
|
|
Restrict delete | ||||
| system_metrics_type_id_fkey |
|
|
Restrict delete | ||||
| submissions_created_by_fkey |
|
|
Restrict delete | ||||
| submissions_deliverable_id_fkey |
|
|
Restrict delete | ||||
| submissions_submission_status_id_fkey |
|
|
Restrict delete | ||||
| submissions_modified_by_fkey |
|
|
Restrict delete | ||||
| submissions_project_id_fkey |
|
|
Cascade on delete | ||||
| user_internal_interests_user_id_fkey |
|
|
Restrict delete | ||||
| user_internal_interests_internal_interest_id_fkey |
|
|
Cascade on delete | ||||
| user_internal_interests_created_by_fkey |
|
|
Restrict delete | ||||
| event_projects_event_id_fkey |
|
|
Cascade on delete | ||||
| event_projects_project_id_fkey |
|
|
Cascade on delete | ||||
| activities_activity_status_id_fkey |
|
|
Restrict delete | ||||
| activities_verified_by_fkey |
|
|
Restrict delete | ||||
| activities_modified_by_fkey |
|
|
Restrict delete | ||||
| activities_project_id_fkey |
|
|
Cascade on delete | ||||
| activities_activity_type_id_fkey |
|
|
Restrict delete | ||||
| activities_created_by_fkey |
|
|
Restrict delete | ||||
| participant_project_species_submission_status_id_fkey |
|
|
Restrict delete | ||||
| participant_project_species_created_by_fkey |
|
|
Restrict delete | ||||
| participant_project_species_modified_by_fkey |
|
|
Restrict delete | ||||
| participant_project_species_project_id_fkey |
|
|
Cascade on delete | ||||
| participant_project_species_species_native_category_id_fkey |
|
|
Restrict delete | ||||
| participant_project_species_species_id_fkey |
|
|
Cascade on delete | ||||
| standard_metrics_component_id_fkey |
|
|
Restrict delete | ||||
| standard_metrics_type_id_fkey |
|
|
Restrict delete | ||||
| project_votes_project_id_fkey |
|
|
Cascade on delete | ||||
| project_votes_user_id_fkey |
|
|
Cascade on delete | ||||
| project_votes_modified_by_fkey |
|
|
Restrict delete | ||||
| project_votes_created_by_fkey |
|
|
Restrict delete | ||||
| project_votes_vote_option_id_fkey |
|
|
Restrict delete | ||||
| project_votes_phase_id_fkey |
|
|
Restrict delete | ||||
| project_vote_decisions_project_id_fkey |
|
|
Cascade on delete | ||||
| project_vote_decisions_vote_option_id_fkey |
|
|
Restrict delete | ||||
| project_vote_decisions_phase_id_fkey |
|
|
Restrict delete | ||||
| deal_stages_pipeline_id_fkey |
|
|
Restrict delete | ||||
| application_modules_application_module_status_id_fkey |
|
|
Restrict delete | ||||
| application_modules_module_id_fkey |
|
|
Restrict delete | ||||
| application_modules_application_id_fkey |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| events | times_start_before_end | (start_time <= end_time) |
| project_scores | project_scores_score_check | ((score >= '-2'::integer) AND (score <= 2)) |
| reports | 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 | reports_check | (end_date > start_date) |
| reports | 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)) |
| cohort_modules | dates_start_before_end | (start_date < end_date) |
| report_system_metrics | system_time | (((system_value IS NULL) AND (system_time IS NULL)) OR ((system_value IS NOT NULL) AND (system_time IS NOT NULL))) |
| deliverable_documents | deliverable_is_document | (deliverable_type_id = 1) |
| report_challenges | report_challenges_position_check | ("position" >= 0) |
| activity_media_files | cover_photo_only | ((is_cover_photo = false) OR (activity_media_type_id = 1)) |
| report_achievements | report_achievements_position_check | ("position" >= 0) |
| project_report_configs | project_report_configs_check | (reporting_end_date > reporting_start_date) |
| activities | activity_status_verified | CASE activity_status_id WHEN 2 THEN (verified_by IS NOT NULL) ELSE (verified_by IS NULL) END |
| activities | verified_by_requires_time | ((verified_by IS NULL) = (verified_time IS NULL)) |