tbl_text_identification_keys

425 rows


Description

Stores identification key extracts along with their bibliographic sources.

Columns

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

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

Specifies the publication that describes or mentions the identification key.
date_updated timestamptz 35,6 √
key_text text 2147483647 √

Text description of the identification key.
taxon_id int4 10
tbl_taxa_tree_master.taxon_id fk_text_identification_keys_taxon_id C

Specifies the taxonomic unit related to this record.
key_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_text_identification_keys_pkey Primary key Asc key_id
pk_tbl_text_identification_keys Must be unique Asc key_uuid

Relationships

Close relationships within degrees of separation