Constraints

133 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
country_worldbank_status_touchstone_fkey
country_worldbank_status.touchstone
touchstone.id
Restrict delete
country_worldbank_status_country_fkey
country_worldbank_status.country
country.id
Restrict delete
country_worldbank_status_worldbank_status_fkey
country_worldbank_status.worldbank_status
worldbank_status.id
Restrict delete
impact_estimate_impact_estimate_set_fkey
impact_estimate.impact_estimate_set
impact_estimate_set.id
Restrict delete
impact_estimate_country_fkey
impact_estimate.country
country.id
Restrict delete
burden_estimate_burden_estimate_set
burden_estimate.burden_estimate_set
burden_estimate_set.id
Restrict delete
burden_estimate_country_nid
burden_estimate.country
country.nid
Restrict delete
burden_estimate_burden_outcome
burden_estimate.burden_outcome
burden_outcome.id
Restrict delete
burden_estimate_model_run
burden_estimate.model_run
model_run.internal_id
Restrict delete
scenario_coverage_set_scenario_fkey
scenario_coverage_set.scenario
scenario.id
Restrict delete
scenario_coverage_set_coverage_set_fkey
scenario_coverage_set.coverage_set
coverage_set.id
Restrict delete
demographic_statistic_type_variant_demographic_variant_fkey
demographic_statistic_type_variant.demographic_variant
demographic_variant.id
Restrict delete
demographic_statistic_type_vari_demographic_statistic_type_fkey
demographic_statistic_type_variant.demographic_statistic_type
demographic_statistic_type.id
Restrict delete
demographic_statistic_type_default_variant_fkey
demographic_statistic_type.default_variant
demographic_variant.id
Restrict delete
demographic_statistic_type_demographic_value_unit_fkey
demographic_statistic_type.demographic_value_unit
demographic_value_unit.id
Restrict delete
coverage_set_vaccine_fkey
coverage_set.vaccine
vaccine.id
Restrict delete
coverage_set_touchstone_fkey
coverage_set.touchstone
touchstone.id
Restrict delete
coverage_set_gavi_support_level_fkey
coverage_set.gavi_support_level
gavi_support_level.id
Restrict delete
coverage_set_activity_type_fkey
coverage_set.activity_type
activity_type.id
Restrict delete
impact_estimate_set_coverage_touchstone_fkey
impact_estimate_set.coverage_touchstone
touchstone.id
Restrict delete
impact_estimate_set_focal_burden_estimate_set_fkey
impact_estimate_set.focal_burden_estimate_set
burden_estimate_set.id
Restrict delete
impact_estimate_set_impact_estimate_recipe_fkey
impact_estimate_set.impact_estimate_recipe
impact_estimate_recipe.id
Restrict delete
impact_estimate_set_recipe_touchstone_fkey
impact_estimate_set.recipe_touchstone
touchstone.id
Restrict delete
impact_estimate_set_focal_coverage_set_fkey
impact_estimate_set.focal_coverage_set
coverage_set.id
Restrict delete
vaccine_routine_age_vaccine_fkey
vaccine_routine_age.vaccine
vaccine.id
Restrict delete
api_access_log_who_fkey
api_access_log.who
app_user.username
Restrict delete
impact_estimate_recipe_disease_fkey
impact_estimate_recipe.disease
disease.id
Restrict delete
impact_estimate_recipe_support_type_fkey
impact_estimate_recipe.support_type
support_type.id
Restrict delete
impact_estimate_recipe_focal_ingredient_fkey
impact_estimate_recipe.focal_ingredient
impact_estimate_ingredient.id
Restrict delete
impact_estimate_recipe_current_impact_estimate_set_fkey
impact_estimate_recipe.current_impact_estimate_set
impact_estimate_set.id
Restrict delete
impact_estimate_recipe_vaccine_fkey
impact_estimate_recipe.vaccine
vaccine.id
Restrict delete
impact_estimate_recipe_impact_outcome_fkey
impact_estimate_recipe.impact_outcome
impact_outcome.id
Restrict delete
impact_estimate_recipe_activity_type_fkey
impact_estimate_recipe.activity_type
activity_type.id
Restrict delete
impact_estimate_recipe_responsibility_set_fkey
impact_estimate_recipe.responsibility_set
responsibility_set.id
Restrict delete
touchstone_demographic_dataset_demographic_dataset_fkey
touchstone_demographic_dataset.demographic_dataset
demographic_dataset.id
Restrict delete
touchstone_demographic_dataset_touchstone_fkey
touchstone_demographic_dataset.touchstone
touchstone.id
Restrict delete
touchstone_years_disease_fkey
touchstone_years.disease
disease.id
Restrict delete
touchstone_years_touchstone_fkey
touchstone_years.touchstone
touchstone.id
Restrict delete
touchstone_demographic_source_demographic_source_fkey
touchstone_demographic_source.demographic_source
demographic_source.id
Restrict delete
touchstone_demographic_source_touchstone_fkey
touchstone_demographic_source.touchstone
touchstone.id
Restrict delete
touchstone_country_touchstone_fkey
touchstone_country.touchstone
touchstone.id
Restrict delete
touchstone_country_disease_fkey
touchstone_country.disease
disease.id
Restrict delete
touchstone_country_country_fkey
touchstone_country.country
country.id
Restrict delete
impact_estimate_set_ingredient_burden_estimate_set_fkey
impact_estimate_set_ingredient.burden_estimate_set
burden_estimate_set.id
Restrict delete
impact_estimate_set_ingredient_impact_estimate_ingredient_fkey
impact_estimate_set_ingredient.impact_estimate_ingredient
impact_estimate_ingredient.id
Restrict delete
impact_estimate_set_ingredient_impact_estimate_set_fkey
impact_estimate_set_ingredient.impact_estimate_set
impact_estimate_set.id
Restrict delete
user_group_membership_username_fkey
user_group_membership.username
app_user.username
Restrict delete
user_group_membership_user_group_fkey
user_group_membership.user_group
user_group.id
Restrict delete
country_cofinance_touchstone_fkey
country_cofinance.touchstone
touchstone.id
Restrict delete
country_cofinance_country_fkey
country_cofinance.country
country.id
Restrict delete
country_cofinance_cofinance_status_fkey
country_cofinance.cofinance_status
cofinance_status.id
Restrict delete
burden_estimate_country_expectation_country_fkey
burden_estimate_country_expectation.country
country.id
Restrict delete
burden_estimate_country_expect_burden_estimate_expectation_fkey
burden_estimate_country_expectation.burden_estimate_expectation
burden_estimate_expectation.id
Restrict delete
country_disease_endemic_touchstone_fkey
country_disease_endemic.touchstone
touchstone.id
Restrict delete
country_disease_endemic_country_fkey
country_disease_endemic.country
country.id
Restrict delete
country_disease_endemic_disease_fkey
country_disease_endemic.disease
disease.id
Restrict delete
scenario_description_scenario_type_fkey
scenario_description.scenario_type
scenario_type.id
Restrict delete
scenario_description_disease_fkey
scenario_description.disease
disease.id
Restrict delete
disability_weight_disease_fkey
disability_weight.disease
disease.id
Restrict delete
disability_weight_touchstone_fkey
disability_weight.touchstone
touchstone.id
Restrict delete
user_group_role_role_fkey
user_group_role.role
role.id
Restrict delete
user_group_role_user_group_fkey
user_group_role.user_group
user_group.id
Restrict delete
burden_estimate_set_problem_burden_estimate_set_fkey
burden_estimate_set_problem.burden_estimate_set
burden_estimate_set.id
Restrict delete
burden_estimate_outcome_expectation_outcome_fkey
burden_estimate_outcome_expectation.outcome
burden_outcome.code
Restrict delete
burden_estimate_outcome_expect_burden_estimate_expectation_fkey
burden_estimate_outcome_expectation.burden_estimate_expectation
burden_estimate_expectation.id
Restrict delete
impact_estimate_ingredient_impact_estimate_recipe_fkey
impact_estimate_ingredient.impact_estimate_recipe
impact_estimate_recipe.id
Restrict delete
impact_estimate_ingredient_burden_outcome_fkey
impact_estimate_ingredient.burden_outcome
burden_outcome.id
Restrict delete
impact_estimate_ingredient_responsibility_fkey
impact_estimate_ingredient.responsibility
responsibility.id
Restrict delete
coverage_gender_fkey
coverage.gender
gender.id
Restrict delete
coverage_coverage_set_fkey
coverage.coverage_set
coverage_set.id
Restrict delete
coverage_country_fkey
coverage.country
country.id
Restrict delete
gavi_focal_model_disease_fkey
gavi_focal_model.disease
disease.id
Restrict delete
gavi_focal_model_model_fkey
gavi_focal_model.model
model.id
Restrict delete
gavi_focal_model_touchstone_fkey
gavi_focal_model.touchstone
touchstone.id
Restrict delete
user_legal_agreement_username_fkey
user_legal_agreement.username
app_user.username
Restrict delete
user_legal_agreement_legal_agreement_fkey
user_legal_agreement.legal_agreement
legal_agreement.name
Restrict delete
country_vaccine_metadata_vaccine_fkey
country_vaccine_metadata.vaccine
vaccine.id
Restrict delete
country_vaccine_metadata_touchstone_fkey
country_vaccine_metadata.touchstone
touchstone.id
Restrict delete
country_vaccine_metadata_country_fkey
country_vaccine_metadata.country
country.id
Restrict delete
touchstone_status_fkey
touchstone.status
touchstone_status.id
Restrict delete
touchstone_touchstone_name_fkey
touchstone.touchstone_name
touchstone_name.id
Restrict delete
role_permission_role_fkey
role_permission.role
role.id
Restrict delete
role_permission_permission_fkey
role_permission.permission
permission.name
Restrict delete
model_run_parameter_set_model_version_fkey
model_run_parameter_set.model_version
model_version.id
Restrict delete
model_run_parameter_set_responsibility_set_fkey
model_run_parameter_set.responsibility_set
responsibility_set.id
Restrict delete
model_run_parameter_set_upload_info_fkey
model_run_parameter_set.upload_info
upload_info.id
Restrict delete
model_run_parameter_model_run_parameter_set_fkey
model_run_parameter.model_run_parameter_set
model_run_parameter_set.id
Restrict delete
burden_estimate_set_set_type_fkey
burden_estimate_set.set_type
burden_estimate_set_type.code
Restrict delete
burden_estimate_set_responsibility_fkey
burden_estimate_set.responsibility
responsibility.id
Restrict delete
burden_estimate_set_status_fkey
burden_estimate_set.status
burden_estimate_set_status.code
Restrict delete
burden_estimate_set_model_run_parameter_set_fkey
burden_estimate_set.model_run_parameter_set
model_run_parameter_set.id
Restrict delete
burden_estimate_set_uploaded_by_fkey
burden_estimate_set.uploaded_by
app_user.username
Restrict delete
burden_estimate_set_model_version_fkey
burden_estimate_set.model_version
model_version.id
Restrict delete
model_version_model_fkey
model_version.model
model.id
Restrict delete
model_run_model_run_parameter_set_fkey
model_run.model_run_parameter_set
model_run_parameter_set.id
Restrict delete
country_metadata_vxdel_segment_fkey
country_metadata.vxdel_segment
vxdel_segment.id
Restrict delete
country_metadata_touchstone_fkey
country_metadata.touchstone
touchstone.id
Restrict delete
country_metadata_francophone_fkey
country_metadata.francophone
francophone_status.id
Restrict delete
country_metadata_country_fkey
country_metadata.country
country.id
Restrict delete
country_metadata_gavi_region_fkey
country_metadata.gavi_region
gavi_region.id
Restrict delete
model_version_country_country_fkey
model_version_country.country
country.id
Restrict delete
model_version_country_model_version_fkey
model_version_country.model_version
model_version.id
Restrict delete
modelling_group_current_fkey
modelling_group.replaced_by
modelling_group.id
Restrict delete
model_gender_fkey
model.gender
gender.id
Restrict delete
model_disease_fkey
model.disease
disease.id
Restrict delete
model_current_version_fkey
model.current_version
model_version.id
Restrict delete
model_modelling_group_fkey
model.modelling_group
modelling_group.id
Restrict delete
model_run_parameter_value_model_run_parameter_fkey
model_run_parameter_value.model_run_parameter
model_run_parameter.id
Restrict delete
model_run_parameter_value_model_run_fkey
model_run_parameter_value.model_run
model_run.internal_id
Restrict delete
responsibility_responsibility_set_fkey
responsibility.responsibility_set
responsibility_set.id
Restrict delete
responsibility_current_stochastic_burden_estimate_set_fkey
responsibility.current_stochastic_burden_estimate_set
burden_estimate_set.id
Restrict delete
responsibility_expectations_fkey
responsibility.expectations
burden_estimate_expectation.id
Restrict delete
responsibility_current_burden_estimate_set_fkey
responsibility.current_burden_estimate_set
burden_estimate_set.id
Restrict delete
responsibility_scenario_fkey
responsibility.scenario
scenario.id
Restrict delete
demographic_statistic_demographic_variant_fkey
demographic_statistic.demographic_variant
demographic_variant.id
Restrict delete
demographic_statistic_demographic_statistic_type_fkey
demographic_statistic.demographic_statistic_type
demographic_statistic_type.id
Restrict delete
demographic_statistic_demographic_dataset_fkey
demographic_statistic.demographic_dataset
demographic_dataset.id
Restrict delete
demographic_statistic_country_fkey
demographic_statistic.country
country.id
Restrict delete
demographic_statistic_gender_fkey
demographic_statistic.gender
gender.id
Restrict delete
demographic_statistic_demographic_source_fkey
demographic_statistic.demographic_source
demographic_source.id
Restrict delete
demographic_dataset_demographic_statistic_type_fkey
demographic_dataset.demographic_statistic_type
demographic_statistic_type.id
Restrict delete
demographic_dataset_demographic_source_fkey
demographic_dataset.demographic_source
demographic_source.id
Restrict delete
gavi_eligibility_country_fkey
gavi_eligibility.country
country.id
Restrict delete
gavi_eligibility_touchstone_fkey
gavi_eligibility.touchstone
touchstone.id
Restrict delete
gavi_eligibility_status_fkey
gavi_eligibility.status
gavi_eligibility_status.id
Restrict delete
responsibility_set_status_fkey
responsibility_set.status
responsibility_set_status.id
Restrict delete
responsibility_set_modelling_group_fkey
responsibility_set.modelling_group
modelling_group.id
Restrict delete
responsibility_set_touchstone_fkey
responsibility_set.touchstone
touchstone.id
Restrict delete
country_fragility_touchstone_fkey
country_fragility.touchstone
touchstone.id
Restrict delete
country_fragility_country_fkey
country_fragility.country
country.id
Restrict delete
scenario_focal_coverage_set_fkey
scenario.focal_coverage_set
coverage_set.id
Restrict delete
scenario_touchstone_fkey
scenario.touchstone
touchstone.id
Restrict delete
scenario_scenario_description_fkey
scenario.scenario_description
scenario_description.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected