Constraints

15 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
species_successional_groups_species_id_fkey
species_successional_groups.species_id
species.id
Cascade on delete
species_successional_groups_successional_group_id_fkey
species_successional_groups.successional_group_id
successional_groups.id
Restrict delete
species_growth_forms_species_id_fkey
species_growth_forms.species_id
species.id
Cascade on delete
species_wood_density_level_id_fkey
species.wood_density_level_id
wood_density_levels.id
Restrict delete
species_organization_id_fkey
species.organization_id
organizations.id
Cascade on delete
species_conservation_category_id_fkey
species.conservation_category_id
conservation_categories.id
Restrict delete
gbif_names_taxon_id_fkey
gbif_names.taxon_id
gbif_taxa.taxon_id
Restrict delete
species_ecosystem_types_ecosystem_type_id_fkey
species_ecosystem_types.ecosystem_type_id
ecosystem_types.id
Restrict delete
species_ecosystem_types_species_id_fkey
species_ecosystem_types.species_id
species.id
Cascade on delete
gbif_name_words_gbif_name_id_fkey
gbif_name_words.gbif_name_id
gbif_names.id
Restrict delete
species_problems_type_id_fkey
species_problems.type_id
species_problem_types.id
Restrict delete
species_problems_species_id_fkey
species_problems.species_id
species.id
Cascade on delete
species_problems_field_id_fkey
species_problems.field_id
species_problem_fields.id
Restrict delete
species_plant_material_sourci_plant_material_sourcing_meth_fkey
species_plant_material_sourcing_methods.plant_material_sourcing_method_id
plant_material_sourcing_methods.id
Restrict delete
species_plant_material_sourcing_methods_species_id_fkey
species_plant_material_sourcing_methods.species_id
species.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
species species_common_name_check ((common_name !~ similar_to_escape(' *'::text)))
species species_family_name_check ((family_name !~ similar_to_escape(' *'::text)))
gbif_distributions gbif_distributions_country_code_check ((country_code !~ similar_to_escape(' *'::text)))
gbif_distributions gbif_distributions_establishment_means_check ((establishment_means !~ similar_to_escape(' *'::text)))
gbif_distributions gbif_distributions_occurrence_status_check ((occurrence_status !~ similar_to_escape(' *'::text)))
gbif_distributions gbif_distributions_threat_status_check ((threat_status !~ similar_to_escape(' *'::text)))
gbif_names gbif_names_language_check ((language !~ similar_to_escape(' *'::text)))
organizations country_code_matches_subdivision (((country_subdivision_code IS NULL) OR (substr(country_subdivision_code, 1, 2) = country_code)))
organizations organizations_country_code_check ((country_code !~ similar_to_escape(' *'::text)))
organizations organizations_country_subdivision_code_check ((country_subdivision_code !~ similar_to_escape(' *'::text)))
organizations organizations_description_check ((description !~ similar_to_escape(' *'::text)))
organizations other_type_details_null_or_not_empty (((organization_type_details IS NULL) OR ((organization_type_details)::text <> ''::text)))
organizations other_type_details_only_for_other ((((organization_type_details IS NULL) AND (organization_type_id <> 6)) OR ((organization_type_details IS NOT NULL) AND (organization_type_id = 6))))
species_problems species_problems_suggested_value_check ((suggested_value !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_canonical_name_check ((canonical_name !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_class_check ((class !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_dataset_id_check ((dataset_id !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_family_check ((family !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_generic_name_check ((generic_name !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_genus_check ((genus !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_infraspecific_epithet_check ((infraspecific_epithet !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_nomenclatural_status_check ((nomenclatural_status !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_order_check (("order" !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_phylum_check ((phylum !~ similar_to_escape(' *'::text)))
gbif_taxa gbif_taxa_specific_epithet_check ((specific_epithet !~ similar_to_escape(' *'::text)))
gbif_vernacular_names gbif_vernacular_names_country_code_check ((country_code !~ similar_to_escape(' *'::text)))
gbif_vernacular_names gbif_vernacular_names_language_check ((language !~ similar_to_escape(' *'::text)))