tbl_text_biology

39452 rows


Description

Contains ecological, habitat, and behavioral information for various taxa, along with references to their sources, such as ‘in hollows on old oaks.’

Columns

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

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

Specifies the publication detailing the biological information.
biology_text text 2147483647 √

Descriptive text providing ecological, habitat, or behavioral details.
date_updated timestamptz 35,6 √
taxon_id int4 10
tbl_taxa_tree_master.taxon_id fk_text_biology_taxon_id C

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

Indexes

Constraint Name Type Sort Column(s)
tbl_text_biology_pkey Primary key Asc biology_id
pk_tbl_text_biology Must be unique Asc biology_uuid

Relationships

Close relationships within degrees of separation