15 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| species_successional_groups_species_id_fkey |
|
|
Cascade on delete | ||
| species_successional_groups_successional_group_id_fkey |
|
|
Restrict delete | ||
| species_growth_forms_species_id_fkey |
|
|
Cascade on delete | ||
| species_wood_density_level_id_fkey |
|
|
Restrict delete | ||
| species_organization_id_fkey |
|
|
Cascade on delete | ||
| species_conservation_category_id_fkey |
|
|
Restrict delete | ||
| gbif_names_taxon_id_fkey |
|
|
Restrict delete | ||
| species_ecosystem_types_ecosystem_type_id_fkey |
|
|
Restrict delete | ||
| species_ecosystem_types_species_id_fkey |
|
|
Cascade on delete | ||
| gbif_name_words_gbif_name_id_fkey |
|
|
Restrict delete | ||
| species_problems_type_id_fkey |
|
|
Restrict delete | ||
| species_problems_species_id_fkey |
|
|
Cascade on delete | ||
| species_problems_field_id_fkey |
|
|
Restrict delete | ||
| species_plant_material_sourci_plant_material_sourcing_meth_fkey |
|
|
Restrict delete | ||
| species_plant_material_sourcing_methods_species_id_fkey |
|
|
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)) |