Tables


SchemaSpy Analysis of terraware.public

Generated on Wed Apr 02 00:47 GMT 2025

XML Representation
Insertion Order Deletion Order
TABLES 20
VIEWS 0
COLUMNS 104
Constraints 15
Anomalies 0
Routines 1200

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 18 3 26 -1 Table

Per-organization information about species.

species_growth_forms 0 1 2 -1 Table

Growth forms of each 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.