wcvp_distributions

-1 rows


Description

World Checklist of Vascular Plants distribution data, indicating which species are found in which botanical countries.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
taxon_id int8 19 null
wcvp_taxa.taxon_id wcvp_distributions_taxon_id_fkey C
level3_code text 2147483647 null

Original TDWG level 3 region (botanical country) for this distribution record, if any. This is usually the same as botanical_country_code but preserves the original value if the code was not on the list of TDWG regions.
establishment_means text 2147483647 √ null
occurrence_status text 2147483647 √ null
threat_status text 2147483647 √ null
botanical_country_code text 2147483647 √ null
botanical_countries.level3_code wcvp_distributions_botanical_country_code_fkey N

Valid TDWG level 3 region (botanical country) for this distribution record, if any. Null if the location ID is unknown or if it contains a code not in the TDWG regions list.
species_nativity_id int4 10 √ null
species_nativities.id wcvp_distributions_species_nativity_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
wcvp_distributions_pkey Primary key Asc/Asc taxon_id + level3_code
wcvp_distributions_botanical_country_code_idx Performance Asc botanical_country_code

Relationships

Close relationships within degrees of separation