tbl_taxa_common_names

4272 rows


Description

Stores vernacular or common names of organisms, such as ‘bluebottle’.

Columns

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

Primary key (automatically incremented).
common_name varchar(255) 255 √

The common or vernacular name of the organism.
date_updated timestamptz 35,6 √
language_id int4 10 √
tbl_languages.language_id fk_taxa_common_names_language_id R

Specifies the language in which the common name is recorded.
taxon_id int4 10 √
tbl_taxa_tree_master.taxon_id fk_taxa_common_names_taxon_id R

Specifies the taxonomic unit related to this record.

Indexes

Constraint Name Type Sort Column(s)
tbl_taxa_common_names_pkey Primary key Asc taxon_common_name_id
idx_taxa_common_names_language_id Performance Asc language_id
idx_taxa_common_names_taxon_id Performance Asc taxon_id

Relationships

Close relationships within degrees of separation