tbl_taxa_tree_orders

56 rows


Description

Represents the taxonomic order level within the taxonomic hierarchy.

Columns

Column Type Size Nulls Auto Children Parents Comments
order_id int4 10 √
tbl_taxa_tree_families.order_id fk_taxa_tree_families_order_id C
view_taxa_alphabetically.order_id Implied Constraint R

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
order_name varchar(50) 50 √

The name of the taxonomic order.
record_type_id int4 10 √
tbl_record_types.record_type_id fk_taxa_tree_orders_record_type_id R

Specifies the record type, indicating the type of taxonomic record.
sort_order int4 10 √

Specifies the display order of taxonomic orders.

Indexes

Constraint Name Type Sort Column(s)
tbl_taxa_tree_orders_pkey Primary key Asc order_id
idx_taxa_tree_orders_order_id Performance Asc order_id

Relationships

Close relationships within degrees of separation