Database Properties
Database Type: PostgreSQL - 17.4 (Debian 17.4-1.pgdg110+2)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| species_successional_groups | 0 | 2 | 2 | -1 | Table | The successional groupings that the species is planted in. |
| species_growth_forms | 0 | 1 | 2 | -1 | Table | Growth forms of each species |
| species | 18 | 3 | 26 | -1 | Table | Per-organization information about species. |
| ecosystem_types | 1 | 0 | 2 | -1 | Table | (Enum) Types of ecosystems in which plants can be found. Based on the World Wildlife Federation’s “Terrestrial Ecoregions of the World” report. |
| species_problem_types | 1 | 0 | 2 | -1 | Table | (Enum) Specific types of problems that can be detected in species data. |
| gbif_distributions | 0 | 0 | 5 | -1 | Table | Information about geographic distribution of species and their conservation statuses. |
| successional_groups | 1 | 0 | 2 | -1 | Table | (Enum) Successional Groups that a plant may be planted in. |
| conservation_categories | 1 | 0 | 2 | -1 | Table | (Enum) IUCN conservation category codes. |
| gbif_names | 1 | 1 | 5 | -1 | Table | Scientific and vernacular names from the GBIF backbone dataset. Names are not required to be unique. |
| species_ecosystem_types | 0 | 2 | 2 | -1 | Table | Ecosystems where each species can be found. |
| species_problem_fields | 1 | 0 | 2 | -1 | Table | (Enum) Species fields that can be scanned for problems. |
| organizations | 5 | 0 | 14 | -1 | Table | Top-level information about organizations. |
| gbif_name_words | 0 | 1 | 2 | -1 | Table | Inverted index of lower-cased words from species and family names in the GBIF backbone dataset. Used to support fast per-word prefix searches. |
| species_problems | 0 | 3 | 6 | -1 | Table | Problems found in species data. Rows are deleted from this table when the problem is marked as ignored by the user or the user accepts the suggested fix. |
| gbif_taxa | 1 | 0 | 18 | -1 | Table | Taxonomic data about species and families. A subset of the GBIF backbone dataset. |
| plant_material_sourcing_methods | 1 | 0 | 2 | -1 | Table | (Enum) Sourcing methods for acquiring plant material. |
| species_plant_material_sourcing_methods | 0 | 2 | 2 | -1 | Table | Sourcing methods for the plant material used to grow a particular species. |
| gbif_vernacular_names | 0 | 0 | 4 | -1 | Table | Vernacular names for species and families. Part of the GBIF backbone dataset. |
| wood_density_levels | 1 | 0 | 2 | -1 | Table | The taxonomic level in the at which a wood density measurement is known |
| species_native_categories | 1 | 0 | 2 | -1 | Table | (Enum) Categories related to native-ness of a species. |