83 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||
|---|---|---|---|---|---|---|---|
| deliverable_project_due_dates_project_id_fkey |
|
|
Cascade on delete | ||||
| deliverable_project_due_dates_deliverable_id_fkey |
|
|
Cascade on delete | ||||
| 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_cohort_due_dates_deliverable_id_fkey |
|
|
Cascade on delete | ||||
| deliverable_cohort_due_dates_cohort_id_fkey |
|
|
Cascade on delete | ||||
| cohorts_phase_id_fkey |
|
|
Restrict delete | ||||
| cohorts_created_by_fkey |
|
|
Restrict delete | ||||
| cohorts_modified_by_fkey |
|
|
Restrict 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| cohort_modules_cohort_id_fkey |
|
|
Restrict delete | ||||
| cohort_modules_module_id_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 | ||||
| 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 | ||||
| submission_snapshots_submission_id_fkey |
|
|
Restrict delete | ||||
| submission_snapshots_file_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 | ||||
| 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 | ||||
| default_project_leads_region_id_fkey |
|
|
Restrict 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 | ||||
| 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 | ||||
| participants_created_by_fkey |
|
|
Restrict delete | ||||
| participants_cohort_id_fkey |
|
|
Restrict delete | ||||
| participants_modified_by_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))) |
| cohort_modules | dates_start_before_end | ((start_date < end_date)) |
| deliverable_documents | deliverable_is_document | ((deliverable_type_id = 1)) |