tbl_taxonomic_order

14528 rows


Description

Contains taxonomic codes for organizing species within a taxonomic hierarchy or referencing external database systems (e.g., GBIF, Artdatabanken).

Columns

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

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
taxon_id int4 10 √
tbl_taxa_tree_master.taxon_id fk_taxonomic_order_taxon_id C

Specifies the taxonomic unit related to this record.
taxonomic_code numeric(18,10) 18,10 √

Unique code representing the taxonomic classification.
taxonomic_order_system_id int4 10 √
tbl_taxonomic_order_systems.taxonomic_order_system_id fk_taxonomic_order_taxonomic_order_system_id R

Specifies the taxonomic ordering system.

Indexes

Constraint Name Type Sort Column(s)
tbl_taxonomic_order_pkey Primary key Asc taxonomic_order_id
idx_taxonomic_order_taxon_id Performance Asc taxon_id
idx_taxonomic_order_taxonomic_code Performance Asc taxonomic_code
idx_taxonomic_order_taxonomic_order_id Performance Asc taxonomic_order_id
idx_taxonomic_order_taxonomic_system_id Performance Asc taxonomic_order_system_id

Relationships

Close relationships within degrees of separation