tbl_taxonomy_notes

17255 rows


Description

Contains general notes on taxa, primarily regarding identification issues (e.g., potential confusion with similar taxa), and may include references and image links.

Columns

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

Primary key (automatically incremented).
biblio_id int4 10
tbl_biblio.biblio_id fk_taxonomy_notes_biblio_id R

Specifies the publication that describes or mentions the taxonomy note.
date_updated timestamptz 35,6 √
taxon_id int4 10
tbl_taxa_tree_master.taxon_id fk_taxonomy_notes_taxon_id C

Specifies the taxonomic unit related to this record.
taxonomy_notes text 2147483647 √

Detailed notes about the taxon, including identification tips and relevant references.
taxonomy_notes_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_taxonomy_notes_pkey Primary key Asc taxonomy_notes_id
tbl_taxonomy_notes_norm_trgm Performance
unique_tbl_taxonomy_notes_taxonomy_notes_uuid Must be unique Asc taxonomy_notes_uuid

Relationships

Close relationships within degrees of separation