tbl_taxa_tree_authors

4828 rows


Description

Specifies authoritative information for species names or synonyms.

Columns

Column Type Size Nulls Auto Children Parents Comments
author_id int4 10 √
tbl_taxa_synonyms.author_id fk_taxa_synonyms_taxa_tree_author_id R
tbl_taxa_tree_master.author_id fk_taxa_tree_master_author_id R
view_taxa_alphabetically.author_id Implied Constraint R

Primary key (automatically incremented).
author_name varchar(100) 100 √

The name of the authority related to the species or synonym.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_taxa_tree_authors_pkey Primary key Asc author_id
idx_taxa_tree_authors_name Performance Asc author_name
tbl_taxa_tree_authors_norm_trgm Performance

Relationships

Close relationships within degrees of separation