120 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_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 | ||||
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 | ||||
default_project_leads_region_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) |
report_achievements | report_achievements_position_check | ("position" >= 0) |
project_report_configs | project_report_configs_check | (reporting_end_date > reporting_start_date) |