TAXON
Referencing tables: attachment_link | conop_distribution | preparation | preparation_taxa | selection | specimen_identification | specimen_union | taxon_character_key | taxon_common_name | taxon_description | taxon_image | taxon_list | taxon_occurrence | taxon_opinion | taxon_page | taxon_search | taxon_synonym | taxon_type_specimen |
| 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 | ||
| is_recombined | tinyint | ||
| taxon_full_name | varchar | ||
| taxon_original_name | varchar | ||
| reference | int | reference | |
| parent | int | taxon | |
| fossil_group | int | taxon | |
| synonym_of | int | taxon | |
| synonym_of_reference_id | int | reference | |
| 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_nrm | varchar | ||
| taxon_id_plutof | int | ||
| taxon_id_tol | int | ||
| taxon_id_eol | int | ||
| species_id | int | ||
| genus_id | int | ||
| remarks | text | ||
| owner | varchar | ||
| is_authorized | tinyint | ||
| user_authorized | varchar | ||
| id | int(auto increment) | ||
| timestamp | datetime | ||
| attachments | int | attachment |
