tbl_taxa_synonyms

0 rows


Description

Contains alternative scientific names for taxa, along with primary references for their definition or usage.

Columns

Column Type Size Nulls Auto Children Parents Comments
synonym_id int4 10 √

Primary key (automatically incremented).
biblio_id int4 10
tbl_biblio.biblio_id fk_taxa_synonyms_biblio_id R

Specifies the publication that describes or mentions then taxon synonym.
date_updated timestamptz 35,6 √
family_id int4 10 √
tbl_taxa_tree_families.family_id fk_taxa_synonyms_family_id R

Specifies the taxonomic family related to the taxon synonym.
genus_id int4 10 √
tbl_taxa_tree_genera.genus_id fk_taxa_synonyms_genus_id R

Specifies the genus related to the taxon synonym.
notes text 2147483647 √

Additional information relevant to the history or usage of the synonym.
taxon_id int4 10 √
tbl_taxa_tree_master.taxon_id fk_taxa_synonyms_taxon_id C

Specifies the taxonomic unit related to this record.
author_id int4 10 √
tbl_taxa_tree_authors.author_id fk_taxa_synonyms_taxa_tree_author_id R

Specifies the author related to the taxon synonym.
synonym varchar(255) 255 √

The synonym at the specified taxonomic level. A separate record is used for different taxonomic levels when names differ from the master list.
reference_type varchar 2147483647 √

Type of reference related to the synonym, such as usage, definition, or incorrect usage.
synonym_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_taxa_synonyms_pkey Primary key Asc synonym_id
pk_tbl_taxa_synonyms Must be unique Asc synonym_uuid

Relationships

Close relationships within degrees of separation