Constraints

14 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fips_srs_fip_uuid_fkey
fips_srs.fip_uuid
fips_srs.db_version_year
fips.uuid
fips.db_version_year
Cascade on delete
fips_srs_sr_id_fkey
fips_srs.sr_id
srs.id
Cascade on delete
gfps_isscfg_fkey
gfps.isscfg
gears.isscfg
Restrict delete
gfps_iso_alpha3_fkey
gfps.iso_alpha3
countries.iso_alpha3
Restrict delete
gfps_species_id_fkey
gfps.species_id
species.id
Restrict delete
fips_gfps_gfp_id_fkey
fips_gfps.gfp_id
gfps.id
Cascade on delete
fips_gfps_fip_uuid_fkey
fips_gfps.fip_uuid
fips_gfps.db_version_year
fips.uuid
fips.db_version_year
Cascade on delete
gfps_mscs_gfp_id_fkey
gfps_mscs.gfp_id
gfps.id
Cascade on delete
fip_participants_organization_id_fkey
fip_participants.organization_id
organizations.id
Cascade on delete
fip_participants_fip_uuid_fkey
fip_participants.fip_uuid
fip_participants.db_version_year
fips.uuid
fips.db_version_year
Cascade on delete
jurisdictions_organization_id_fkey
jurisdictions.organization_id
organizations.id
Cascade on delete
jurisdictions_fip_uuid_fkey
jurisdictions.fip_uuid
jurisdictions.db_version_year
fips.uuid
fips.db_version_year
Cascade on delete
fs_retrospective_scores_gfp_id_fkey
fs_retrospective_scores.gfp_id
gfps.id
Restrict delete
undp_data_iso_alpha3_fkey
undp_data.iso_alpha3
countries.iso_alpha3
Restrict delete

Check Constraints

Table Constraint Name Constraint