tbl_taxa_tree_families

529 rows


Description

Stores information about taxonomic families.

Columns

Column Type Size Nulls Auto Children Parents Comments
family_id int4 10 √
tbl_taxa_synonyms.family_id fk_taxa_synonyms_family_id R
tbl_taxa_tree_genera.family_id fk_taxa_tree_genera_family_id C
view_taxa_alphabetically.family_id Implied Constraint R

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
family_name varchar(100) 100 √

Name of the taxonomic family.
order_id int4 10
tbl_taxa_tree_orders.order_id fk_taxa_tree_families_order_id C

Specifies the taxonomic order this family belongs to.

Indexes

Constraint Name Type Sort Column(s)
tbl_taxa_tree_families_pkey Primary key Asc family_id
idx_taxa_tree_families_name Performance Asc family_name
idx_taxa_tree_families_order_id Performance Asc order_id

Relationships

Close relationships within degrees of separation