tbl_mcr_names

436 rows


Description

Contains the original taxon names utilized in the Birmingham MCR calculation system for climate reconstruction. It ensures the reproducibility of results and facilitates comparison with historical data.

Columns

Column Type Size Nulls Auto Children Parents Comments
taxon_id int4 10 √
tbl_taxa_tree_master.taxon_id fk_mcr_names_taxon_id R

Primary key. Specifies the taxonomic unit related to this record.
comparison_notes varchar(255) 255 √

Additional notes for cross-referencing and comparison with other taxa.
date_updated timestamptz 35,6 √
mcr_name_trim varchar(80) 80 √

The abbreviated or trimmed version of the MCR taxon name for consistency.
mcr_number int2 5 √

A unique identifier related to each MCR taxon name.
mcr_species_name varchar(200) 200 √

The full scientific name of the species as used in MCR calculations.

Indexes

Constraint Name Type Sort Column(s)
tbl_mcr_names_pkey Primary key Asc taxon_id

Relationships

Close relationships within degrees of separation