tbl_taxonomic_order_systems

3 rows


Description

Contains different taxonomic order systems, which provide unique and name-independent identifiers for taxa. It facilitates mapping across various systems, enhancing interoperability between databases.

Columns

Column Type Size Nulls Auto Children Parents Comments
taxonomic_order_system_id int4 10 √
tbl_taxonomic_order.taxonomic_order_system_id fk_taxonomic_order_taxonomic_order_system_id R
tbl_taxonomic_order_biblio.taxonomic_order_system_id fk_taxonomic_order_biblio_taxonomic_order_system_id R

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
system_description text 2147483647 √

Gives a detailed description of the taxonomic order system.
system_name varchar(50) 50 √

The name of the taxonomic order system.
taxonomic_order_system_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_taxonomic_order_systems_pkey Primary key Asc taxonomic_order_system_id
idx_taxonomic_order_systems_taxonomic_system_id Performance Asc taxonomic_order_system_id
tbl_taxonomic_order_systems_norm_trgm Performance
unique_tbl_taxonomic_order_systems_taxonomic_order_system_uuid Must be unique Asc taxonomic_order_system_uuid

Relationships

Close relationships within degrees of separation