Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| taxon_id | int8 | 19 | null |
|
|
|||||
| 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_dataset_id_check | ((dataset_id !~ similar_to_escape(' *'::text))) |
| gbif_taxa_class_check | ((class !~ similar_to_escape(' *'::text))) |
| gbif_taxa_specific_epithet_check | ((specific_epithet !~ similar_to_escape(' *'::text))) |
| gbif_taxa_generic_name_check | ((generic_name !~ similar_to_escape(' *'::text))) |
| gbif_taxa_canonical_name_check | ((canonical_name !~ similar_to_escape(' *'::text))) |
| gbif_taxa_nomenclatural_status_check | ((nomenclatural_status !~ similar_to_escape(' *'::text))) |
| gbif_taxa_genus_check | ((genus !~ similar_to_escape(' *'::text))) |
| gbif_taxa_order_check | (("order" !~ similar_to_escape(' *'::text))) |
| gbif_taxa_phylum_check | ((phylum !~ similar_to_escape(' *'::text))) |
| gbif_taxa_family_check | ((family !~ similar_to_escape(' *'::text))) |
| gbif_taxa_infraspecific_epithet_check | ((infraspecific_epithet !~ similar_to_escape(' *'::text))) |