TAXON
Referencing tables: attachment | attachment_link | preparation | reference | specimen_identification | specimen_union | stratigraphy | taxon_common_name | taxon_description | taxon_image | taxon_list | taxon_occurrence | taxon_opinion | taxon_page | taxon_rank | taxon_search | taxon_synonym | taxon_type_specimen | selection |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| taxon | varchar | ||
| author_year | varchar | ||
| taxon_epithet | varchar | ||
| taxon_full_name | varchar | ||
| taxon_original_name | varchar | ||
| reference | int | reference | |
| parent | int | taxon | |
| fossil_group | int | taxon | |
| synonym_of | int | ||
| synonym_of_reference_id | int | ||
| hierarchy_string | varchar | ||
| rank | int | taxon_rank | |
| rank_original | int | taxon_rank | |
| type_taxon | int | taxon | |
| type_taxon_txt | varchar | ||
| stratigraphy_base | int | stratigraphy | |
| stratigraphy_top | int | stratigraphy | |
| in_estonia | tinyint | ||
| in_baltoscandia | tinyint | ||
| is_fossil | tinyint | ||
| is_private | tinyint | ||
| is_valid | tinyint | ||
| is_fossil_group | tinyint | ||
| sort | int | ||
| taxon_id_pbdb | int | ||
| taxon_id_plutof | int | ||
| taxon_id_tol | int | ||
| taxon_id_eol | int | ||
| taxon_id_nrm | varchar | ||
| remarks | text | ||
| owner | varchar | ||
| is_authorized | tinyint | ||
| user_authorized | varchar | ||
| id | int(auto increment) | ||
| attachments | int | attachment |
