Constraints

52 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

published_project_indicator_targets_project_id_fkey

published_project_indicator_targets.project_id

Cascade on delete

published_project_indicator_targets_project_indicator_id_fkey

published_project_indicator_targets.project_indicator_id

project_indicators.id

Cascade on delete

published_auto_calculated_indicator_targets_project_id_fkey

published_auto_calculated_indicator_targets.project_id

Cascade on delete

published_auto_calculated_indicator_targets_auto_calculated_ind

published_auto_calculated_indicator_targets.auto_calculated_indicator_id

auto_calculated_indicators.id

Cascade on delete

published_auto_calculated_ind_auto_calculated_indicator_id_fkey

published_auto_calculated_indicator_baselines.auto_calculated_indicator_id

auto_calculated_indicators.id

Cascade on delete

published_auto_calculated_indicator_baselines_project_id_fkey

published_auto_calculated_indicator_baselines.project_id

Cascade on delete

published_project_sdg_project_id_fkey

published_project_sdg.project_id

Cascade on delete

published_report_challenges_report_id_fkey

published_report_challenges.report_id

published_reports.report_id

Cascade on delete

published_common_indicator_baselines_project_id_fkey

published_common_indicator_baselines.project_id

Cascade on delete

published_common_indicator_baselines_common_indicator_id_fkey

published_common_indicator_baselines.common_indicator_id

common_indicators.id

Cascade on delete

published_report_project_indicators_project_indicator_id_fkey

published_report_project_indicators.project_indicator_id

project_indicators.id

Restrict delete

published_report_project_indicators_status_id_fkey

published_report_project_indicators.status_id

report_indicator_statuses.id

Restrict delete

published_report_project_indicators_report_id_fkey

published_report_project_indicators.report_id

published_reports.report_id

Cascade on delete

published_project_carbon_certs_project_id_fkey

published_project_carbon_certs.project_id

Cascade on delete

published_project_land_use_project_id_fkey

published_project_land_use.project_id

Cascade on delete

published_project_land_use_land_use_model_type_id_fkey

published_project_land_use.land_use_model_type_id

land_use_model_types.id

Restrict delete

published_reports_report_id_fkey

published_reports.report_id

Cascade on delete

published_reports_project_id_fkey

published_reports.project_id

Cascade on delete

published_reports_published_by_fkey

published_reports.published_by

Restrict delete

published_reports_report_quarter_id_fkey

published_reports.report_quarter_id

report_quarters.id

Restrict delete

funding_entity_users_funding_entity_id_fkey

funding_entity_users.funding_entity_id

funding_entities.id

Cascade on delete

funding_entity_users_user_id_fkey

funding_entity_users.user_id

Cascade on delete

published_report_common_indicators_common_indicator_id_fkey

published_report_common_indicators.common_indicator_id

common_indicators.id

Restrict delete

published_report_common_indicators_status_id_fkey

published_report_common_indicators.status_id

report_indicator_statuses.id

Restrict delete

published_report_common_indicators_report_id_fkey

published_report_common_indicators.report_id

published_reports.report_id

Cascade on delete

published_activities_activity_type_id_fkey

published_activities.activity_type_id

activity_types.id

Restrict delete

published_activities_activity_id_fkey

published_activities.activity_id

Restrict delete

published_activities_project_id_fkey

published_activities.project_id

Cascade on delete

published_activities_published_by_fkey

published_activities.published_by

Restrict delete

published_report_achievements_report_id_fkey

published_report_achievements.report_id

published_reports.report_id

Cascade on delete

funding_entities_created_by_fkey

funding_entities.created_by

Restrict delete

funding_entities_modified_by_fkey

funding_entities.modified_by

Restrict delete

published_report_photos_file_id_fkey

published_report_photos.file_id

Cascade on delete

published_report_photos_report_id_file_id_fkey

published_report_photos.report_id

published_report_photos.file_id

report_photos.report_id

report_photos.file_id

Restrict delete

published_report_photos_report_id_fkey

published_report_photos.report_id

published_reports.report_id

Restrict delete

published_project_indicator_baselines_project_indicator_id_fkey

published_project_indicator_baselines.project_indicator_id

project_indicators.id

Cascade on delete

published_project_indicator_baselines_project_id_fkey

published_project_indicator_baselines.project_id

Cascade on delete

published_report_auto_calculated_indicators_report_id_fkey

published_report_auto_calculated_indicators.report_id

published_reports.report_id

Cascade on delete

published_report_auto_calculated_indicators_status_id_fkey

published_report_auto_calculated_indicators.status_id

report_indicator_statuses.id

Restrict delete

published_report_auto_calculated_indicators_auto_calculated_ind

published_report_auto_calculated_indicators.auto_calculated_indicator_id

auto_calculated_indicators.id

Restrict delete

published_project_details_country_code_fkey

published_project_details.country_code

Restrict delete

published_project_details_published_by_fkey

published_project_details.published_by

Restrict delete

published_project_details_project_highlight_photo_value_id_fkey

published_project_details.project_highlight_photo_value_id

variable_values.id

Restrict delete

published_project_details_project_zone_figure_value_id_fkey

published_project_details.project_zone_figure_value_id

variable_values.id

Restrict delete

published_project_details_project_id_fkey

published_project_details.project_id

Cascade on delete

funding_entity_projects_funding_entity_id_fkey

funding_entity_projects.funding_entity_id

funding_entities.id

Cascade on delete

funding_entity_projects_project_id_fkey

funding_entity_projects.project_id

Cascade on delete

published_activity_media_files_activity_media_type_id_fkey

published_activity_media_files.activity_media_type_id

activity_media_types.id

Restrict delete

published_activity_media_files_file_id_fkey

published_activity_media_files.file_id

Restrict delete

published_activity_media_files_activity_id_fkey

published_activity_media_files.activity_id

published_activities.activity_id

Restrict delete

published_common_indicator_targets_project_id_fkey

published_common_indicator_targets.project_id

Cascade on delete

published_common_indicator_targets_common_indicator_id_fkey

published_common_indicator_targets.common_indicator_id

common_indicators.id

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)