Constraints

137 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

events_created_by_fkey

events.created_by

Restrict delete

events_modified_by_fkey

events.modified_by

Restrict delete

events_event_type_id_fkey

events.event_type_id

Restrict delete

events_event_status_id_fkey

events.event_status_id

event_statuses.id

Restrict delete

events_module_id_fkey

events.module_id

Cascade on delete

deliverable_variables_deliverable_id_fkey

deliverable_variables.deliverable_id

deliverables.id

Cascade on delete

deliverable_variables_variable_id_fkey

deliverable_variables.variable_id

Cascade on delete

project_indicator_targets_project_indicator_id_fkey

project_indicator_targets.project_indicator_id

project_indicators.id

Cascade on delete

project_indicator_targets_project_id_fkey

project_indicator_targets.project_id

Cascade on delete

modules_created_by_fkey

modules.created_by

Restrict delete

modules_modified_by_fkey

modules.modified_by

Restrict delete

modules_phase_id_fkey

modules.phase_id

accelerator_phases.id

Restrict delete

report_auto_calculated_indicators_report_id_fkey

report_auto_calculated_indicators.report_id

Cascade on delete

report_auto_calculated_indicators_modified_by_fkey

report_auto_calculated_indicators.modified_by

Restrict delete

report_auto_calculated_indicators_status_id_fkey

report_auto_calculated_indicators.status_id

report_indicator_statuses.id

Restrict delete

report_auto_calculated_indicators_auto_calculated_indicator_id_

report_auto_calculated_indicators.auto_calculated_indicator_id

auto_calculated_indicators.id

Restrict delete

project_scores_project_id_fkey

project_scores.project_id

Cascade on delete

project_scores_phase_id_fkey

project_scores.phase_id

accelerator_phases.id

Restrict delete

project_scores_created_by_fkey

project_scores.created_by

Restrict delete

project_scores_score_category_id_fkey

project_scores.score_category_id

score_categories.id

Restrict delete

project_scores_modified_by_fkey

project_scores.modified_by

Restrict delete

reports_status_id_fkey

reports.status_id

report_statuses.id

Restrict delete

reports_config_id_fkey

reports.config_id

project_report_configs.id

Restrict delete

reports_config_id_project_id_fkey

reports.config_id

reports.project_id

project_report_configs.id

project_report_configs.project_id

Restrict delete

reports_project_id_fkey

reports.project_id

Cascade on delete

reports_created_by_fkey

reports.created_by

Restrict delete

reports_submitted_by_fkey

reports.submitted_by

Restrict delete

reports_report_quarter_id_fkey

reports.report_quarter_id

report_quarters.id

Restrict delete

reports_modified_by_fkey

reports.modified_by

Restrict delete

project_accelerator_details_pipeline_id_fkey

project_accelerator_details.pipeline_id

Restrict delete

project_accelerator_details_deal_stage_id_fkey

project_accelerator_details.deal_stage_id

Restrict delete

project_accelerator_details_project_id_fkey

project_accelerator_details.project_id

Restrict delete

project_modules_module_id_fkey

project_modules.module_id

Cascade on delete

project_modules_project_id_fkey

project_modules.project_id

Cascade on delete

deliverable_documents_deliverable_type_id_fkey

deliverable_documents.deliverable_type_id

deliverable_types.id

Restrict delete

deliverable_documents_deliverable_id_deliverable_type_id_fkey

deliverable_documents.deliverable_id

deliverable_documents.deliverable_type_id

deliverables.id

deliverables.deliverable_type_id

Restrict delete

deliverable_documents_deliverable_id_fkey

deliverable_documents.deliverable_id

deliverables.id

Restrict delete

project_overall_scores_modified_by_fkey

project_overall_scores.modified_by

Restrict delete

project_overall_scores_created_by_fkey

project_overall_scores.created_by

Restrict delete

project_overall_scores_project_id_fkey

project_overall_scores.project_id

Cascade on delete

submission_snapshots_submission_id_fkey

submission_snapshots.submission_id

Restrict delete

submission_snapshots_file_id_fkey

submission_snapshots.file_id

Cascade on delete

report_common_indicator_targets_common_indicator_id_fkey

report_common_indicator_targets.common_indicator_id

common_indicators.id

Cascade on delete

report_common_indicator_targets_project_id_fkey

report_common_indicator_targets.project_id

Cascade on delete

report_challenges_report_id_fkey

report_challenges.report_id

Cascade on delete

deliverables_created_by_fkey

deliverables.created_by

Restrict delete

deliverables_deliverable_category_id_fkey

deliverables.deliverable_category_id

deliverable_categories.id

Restrict delete

deliverables_deliverable_type_id_fkey

deliverables.deliverable_type_id

deliverable_types.id

Restrict delete

deliverables_module_id_fkey

deliverables.module_id

Restrict delete

deliverables_modified_by_fkey

deliverables.modified_by

Restrict delete

default_voters_user_id_fkey

default_voters.user_id

Cascade on delete

submission_documents_submission_id_fkey

submission_documents.submission_id

Restrict delete

submission_documents_project_id_fkey

submission_documents.project_id

Restrict delete

submission_documents_document_store_id_fkey

submission_documents.document_store_id

document_stores.id

Restrict delete

submission_documents_created_by_fkey

submission_documents.created_by

Restrict delete

report_photos_report_id_fkey

report_photos.report_id

Restrict delete

report_photos_file_id_fkey

report_photos.file_id

Cascade on delete

common_indicator_targets_common_indicator_id_fkey

common_indicator_targets.common_indicator_id

common_indicators.id

Cascade on delete

common_indicator_targets_project_id_fkey

common_indicator_targets.project_id

Cascade on delete

project_indicators_project_id_fkey

project_indicators.project_id

Cascade on delete

project_indicators_class_id_fkey

project_indicators.class_id

indicator_classes.id

Restrict delete

project_indicators_category_id_fkey

project_indicators.category_id

indicator_categories.id

Restrict delete

project_indicators_level_id_fkey

project_indicators.level_id

indicator_levels.id

Restrict delete

project_indicators_frequency_id_fkey

project_indicators.frequency_id

indicator_frequencies.id

Restrict delete

auto_calculated_indicators_frequency_id_fkey

auto_calculated_indicators.frequency_id

indicator_frequencies.id

Restrict delete

auto_calculated_indicators_class_id_fkey

auto_calculated_indicators.class_id

indicator_classes.id

Restrict delete

auto_calculated_indicators_category_id_fkey

auto_calculated_indicators.category_id

indicator_categories.id

Restrict delete

auto_calculated_indicators_level_id_fkey

auto_calculated_indicators.level_id

indicator_levels.id

Restrict delete

activity_media_files_activity_id_fkey

activity_media_files.activity_id

Restrict delete

activity_media_files_file_id_fkey

activity_media_files.file_id

Cascade on delete

activity_media_files_activity_media_type_id_fkey

activity_media_files.activity_media_type_id

activity_media_types.id

Restrict delete

report_auto_calculated_indicator_targets_auto_calculated_indica

report_auto_calculated_indicator_targets.auto_calculated_indicator_id

auto_calculated_indicators.id

Cascade on delete

report_auto_calculated_indicator_targets_project_id_fkey

report_auto_calculated_indicator_targets.project_id

Cascade on delete

report_achievements_report_id_fkey

report_achievements.report_id

Cascade on delete

deliverable_project_due_dates_project_id_fkey

deliverable_project_due_dates.project_id

Cascade on delete

deliverable_project_due_dates_deliverable_id_fkey

deliverable_project_due_dates.deliverable_id

deliverables.id

Cascade on delete

report_project_indicator_targets_project_id_fkey

report_project_indicator_targets.project_id

Cascade on delete

report_project_indicator_targets_project_indicator_id_fkey

report_project_indicator_targets.project_indicator_id

project_indicators.id

Cascade on delete

report_project_indicators_report_id_fkey

report_project_indicators.report_id

Cascade on delete

report_project_indicators_status_id_fkey

report_project_indicators.status_id

report_indicator_statuses.id

Restrict delete

report_project_indicators_project_indicator_id_fkey

report_project_indicators.project_indicator_id

project_indicators.id

Restrict delete

report_project_indicators_modified_by_fkey

report_project_indicators.modified_by

Restrict delete

project_report_configs_project_id_fkey

project_report_configs.project_id

Cascade on delete

applications_country_code_fkey

applications.country_code

Restrict delete

applications_project_id_fkey

applications.project_id

Cascade on delete

applications_created_by_fkey

applications.created_by

Restrict delete

applications_modified_by_fkey

applications.modified_by

Restrict delete

applications_application_status_id_fkey

applications.application_status_id

application_statuses.id

Restrict delete

application_histories_modified_by_fkey

application_histories.modified_by

Restrict delete

application_histories_application_id_fkey

application_histories.application_id

applications.id

Cascade on delete

application_histories_application_status_id_fkey

application_histories.application_status_id

application_statuses.id

Restrict delete

deliverable_categories_internal_interest_id_fkey

deliverable_categories.internal_interest_id

internal_interests.id

Restrict delete

submissions_created_by_fkey

submissions.created_by

Restrict delete

submissions_deliverable_id_fkey

submissions.deliverable_id

deliverables.id

Restrict delete

submissions_submission_status_id_fkey

submissions.submission_status_id

submission_statuses.id

Restrict delete

submissions_modified_by_fkey

submissions.modified_by

Restrict delete

submissions_project_id_fkey

submissions.project_id

Cascade on delete

user_internal_interests_user_id_fkey

user_internal_interests.user_id

Restrict delete

user_internal_interests_internal_interest_id_fkey

user_internal_interests.internal_interest_id

internal_interests.id

Cascade on delete

user_internal_interests_created_by_fkey

user_internal_interests.created_by

Restrict delete

event_projects_event_id_fkey

event_projects.event_id

Cascade on delete

event_projects_project_id_fkey

event_projects.project_id

Cascade on delete

report_common_indicators_common_indicator_id_fkey

report_common_indicators.common_indicator_id

common_indicators.id

Restrict delete

report_common_indicators_report_id_fkey

report_common_indicators.report_id

Cascade on delete

report_common_indicators_status_id_fkey

report_common_indicators.status_id

report_indicator_statuses.id

Restrict delete

report_common_indicators_modified_by_fkey

report_common_indicators.modified_by

Restrict delete

activities_activity_status_id_fkey

activities.activity_status_id

activity_statuses.id

Restrict delete

activities_verified_by_fkey

activities.verified_by

Restrict delete

activities_modified_by_fkey

activities.modified_by

Restrict delete

activities_project_id_fkey

activities.project_id

Cascade on delete

activities_activity_type_id_fkey

activities.activity_type_id

activity_types.id

Restrict delete

activities_created_by_fkey

activities.created_by

Restrict delete

participant_project_species_submission_status_id_fkey

participant_project_species.submission_status_id

submission_statuses.id

Restrict delete

participant_project_species_created_by_fkey

participant_project_species.created_by

Restrict delete

participant_project_species_modified_by_fkey

participant_project_species.modified_by

Restrict delete

participant_project_species_project_id_fkey

participant_project_species.project_id

Cascade on delete

participant_project_species_species_native_category_id_fkey

participant_project_species.species_native_category_id

species_native_categories.id

Restrict delete

participant_project_species_species_id_fkey

participant_project_species.species_id

Cascade on delete

auto_calculated_indicator_tar_auto_calculated_indicator_id_fkey

auto_calculated_indicator_targets.auto_calculated_indicator_id

auto_calculated_indicators.id

Cascade on delete

auto_calculated_indicator_targets_project_id_fkey

auto_calculated_indicator_targets.project_id

Cascade on delete

project_votes_project_id_fkey

project_votes.project_id

Cascade on delete

project_votes_user_id_fkey

project_votes.user_id

Cascade on delete

project_votes_modified_by_fkey

project_votes.modified_by

Restrict delete

project_votes_created_by_fkey

project_votes.created_by

Restrict delete

project_votes_vote_option_id_fkey

project_votes.vote_option_id

vote_options.id

Restrict delete

project_votes_phase_id_fkey

project_votes.phase_id

accelerator_phases.id

Restrict delete

common_indicators_category_id_fkey

common_indicators.category_id

indicator_categories.id

Restrict delete

standard_indicators_frequency_id_fkey

common_indicators.frequency_id

indicator_frequencies.id

Restrict delete

common_indicators_level_id_fkey

common_indicators.level_id

indicator_levels.id

Restrict delete

standard_indicators_class_id_fkey

common_indicators.class_id

indicator_classes.id

Restrict delete

project_vote_decisions_project_id_fkey

project_vote_decisions.project_id

Cascade on delete

project_vote_decisions_vote_option_id_fkey

project_vote_decisions.vote_option_id

vote_options.id

Restrict delete

project_vote_decisions_phase_id_fkey

project_vote_decisions.phase_id

accelerator_phases.id

Restrict delete

deal_stages_pipeline_id_fkey

deal_stages.pipeline_id

Restrict delete

application_modules_application_module_status_id_fkey

application_modules.application_module_status_id

application_module_statuses.id

Restrict delete

application_modules_module_id_fkey

application_modules.module_id

Restrict delete

application_modules_application_id_fkey

application_modules.application_id

applications.id

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	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))
project_modules	dates_start_before_end	(start_date <= end_date)
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	((activity_status_id <> 2) OR (verified_by IS NOT NULL))
activities	verified_by_requires_time	((verified_by IS NULL) = (verified_time IS NULL))