Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| taxon_id | int8 | 19 | null |
|
|
GBIF-defined ID of the taxon. GBIF taxon IDs are unrelated to the WCVP taxon IDs for the same species. |
|||||
| dataset_id | text | 2147483647 | √ | null |
|
|
|||||
| parent_name_usage_id | int8 | 19 | √ | null |
|
|
|||||
| accepted_name_usage_id | int8 | 19 | √ | null |
|
|
|||||
| original_name_usage_id | int8 | 19 | √ | null |
|
|
|||||
| scientific_name | text | 2147483647 | null |
|
|
||||||
| canonical_name | text | 2147483647 | √ | null |
|
|
|||||
| generic_name | text | 2147483647 | √ | null |
|
|
|||||
| specific_epithet | text | 2147483647 | √ | null |
|
|
|||||
| infraspecific_epithet | text | 2147483647 | √ | null |
|
|
|||||
| taxon_rank | text | 2147483647 | null |
|
|
||||||
| taxonomic_status | text | 2147483647 | null |
|
|
||||||
| nomenclatural_status | text | 2147483647 | √ | null |
|
|
|||||
| phylum | text | 2147483647 | √ | null |
|
|
|||||
| class | text | 2147483647 | √ | null |
|
|
|||||
| order | text | 2147483647 | √ | null |
|
|
|||||
| family | text | 2147483647 | √ | null |
|
|
|||||
| genus | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| gbif_taxa_pkey | Primary key | Asc | taxon_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| gbif_taxa_generic_name_check | (generic_name !~ similar_to_escape(' *'::text)) |
| gbif_taxa_canonical_name_check | (canonical_name !~ similar_to_escape(' *'::text)) |
| gbif_taxa_specific_epithet_check | (specific_epithet !~ similar_to_escape(' *'::text)) |
| gbif_taxa_nomenclatural_status_check | (nomenclatural_status !~ similar_to_escape(' *'::text)) |
| gbif_taxa_family_check | (family !~ similar_to_escape(' *'::text)) |
| gbif_taxa_class_check | (class !~ similar_to_escape(' *'::text)) |
| gbif_taxa_order_check | ("order" !~ similar_to_escape(' *'::text)) |
| gbif_taxa_genus_check | (genus !~ similar_to_escape(' *'::text)) |
| gbif_taxa_infraspecific_epithet_check | (infraspecific_epithet !~ similar_to_escape(' *'::text)) |
| gbif_taxa_dataset_id_check | (dataset_id !~ similar_to_escape(' *'::text)) |
| gbif_taxa_phylum_check | (phylum !~ similar_to_escape(' *'::text)) |