tbl_taxa_tree_master

23980 rows


Description

Represents the finest level of taxonomic classification, typically at the species level. It may also include designations such as ‘sp.’ for an unspecified single species, ‘spp.’ for multiple unspecified species, ‘grp’ for taxonomic groups, or split identifications (e.g., x/y), along with other cases depending on the taxonomic context.

Columns

Column Type Size Nulls Auto Children Parents Comments
taxon_id int4 10 √
tbl_abundances.taxon_id fk_abundances_taxon_id C
tbl_analysis_taxon_counts.taxon_id tbl_analysis_taxon_counts_taxon_id_fkey R
tbl_dating_material.taxon_id fk_dating_material_taxa_tree_master_taxon_id R
tbl_ecocodes.taxon_id fk_ecocodes_taxon_id R
tbl_imported_taxa_replacements.taxon_id fk_imported_taxa_replacements_taxon_id C
tbl_mcr_names.taxon_id fk_mcr_names_taxon_id R
tbl_mcr_summary_data.taxon_id fk_mcr_summary_data_taxon_id R
tbl_mcrdata_birmbeetledat.taxon_id fk_mcrdata_birmbeetledat_taxon_id R
tbl_rdb.taxon_id fk_rdb_taxon_id C
tbl_species_associations.taxon_id fk_species_associations_taxon_id R
tbl_taxa_common_names.taxon_id fk_taxa_common_names_taxon_id R
tbl_taxa_images.taxon_id fk_taxa_images_taxa_tree_master_id R
tbl_taxa_measured_attributes.taxon_id fk_taxa_measured_attributes_taxon_id C
tbl_taxa_reference_specimens.taxon_id fk_taxa_reference_specimens_taxon_id R
tbl_taxa_seasonality.taxon_id fk_taxa_seasonality_taxon_id C
tbl_taxa_synonyms.taxon_id fk_taxa_synonyms_taxon_id C
tbl_taxonomic_order.taxon_id fk_taxonomic_order_taxon_id C
tbl_taxonomy_notes.taxon_id fk_taxonomy_notes_taxon_id C
tbl_text_biology.taxon_id fk_text_biology_taxon_id C
tbl_text_distribution.taxon_id fk_text_distribution_taxon_id C
tbl_text_identification_keys.taxon_id fk_text_identification_keys_taxon_id C

Primary key (automatically incremented).
author_id int4 10 √
tbl_taxa_tree_authors.author_id fk_taxa_tree_master_author_id R

Specifies the author of the taxonomic classification.
date_updated timestamptz 35,6 √
genus_id int4 10 √
tbl_taxa_tree_genera.genus_id fk_taxa_tree_master_genus_id C

Specifies the genus related to this taxon.
species varchar(255) 255 √

Name of the species or designation for unspecified species (e.g., ‘sp.’, ‘spp.’).

Indexes

Constraint Name Type Sort Column(s)
tbl_taxa_tree_master_pkey Primary key Asc taxon_id
idx_taxa_tree_master_author_id Performance Asc author_id
idx_taxa_tree_master_genus_id Performance Asc genus_id

Relationships

Close relationships within degrees of separation