tbl_taxa_tree_genera

Column

Type

Size

Nulls

Auto

Children

Parents

Comments

genus_id

int4

10

√

tbl_taxa_synonyms.genus_id	fk_taxa_synonyms_genus_id	R
tbl_taxa_tree_master.genus_id	fk_taxa_tree_master_genus_id	C
view_taxa_alphabetically.genus_id	Implied Constraint	R

Primary key (automatically incremented).

date_updated

timestamptz

35,6

√

family_id

int4

10

√

fk_taxa_tree_genera_family_id

C

Specifies the taxonomic family.

genus_name

varchar(100)

100

√

Name of the genus.

Constraint Name	Type	Sort	Column(s)
tbl_taxa_tree_genera_pkey	Primary key	Asc	genus_id
idx_taxa_tree_genera_family_id	Performance	Asc	family_id
idx_taxa_tree_genera_name	Performance	Asc	genus_name
tbl_taxa_tree_genera_norm_trgm	Performance