tbl_taxonomic_order_biblio

0 rows


Description

Contains bibliographic references related to the taxonomic ordering or numbering systems. Multiple references may be associated.

Columns

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

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

Specifies the publication that describes or mentions the taxon synonym.
date_updated timestamptz 35,6 √
taxonomic_order_system_id int4 10 √
tbl_taxonomic_order_systems.taxonomic_order_system_id fk_taxonomic_order_biblio_taxonomic_order_system_id R

Specifies the the taxonomic order system.

Indexes

Constraint Name Type Sort Column(s)
tbl_taxonomic_order_biblio_pkey Primary key Asc taxonomic_order_biblio_id
idx_taxonomic_order_biblio_biblio_id Performance Asc biblio_id
idx_taxonomic_order_biblio_taxonomic_order_biblio_id Performance Asc taxonomic_order_biblio_id
idx_taxonomic_order_biblio_taxonomic_order_system_id Performance Asc taxonomic_order_system_id

Relationships

Close relationships within degrees of separation