tbl_abundances

233645 rows


Description

This table records data related to biological proxies, such as individual counts, presence indicators, or scaled values, linking each entry to a specific taxon through an analysis entity. It serves as a species list detailing abundance information for a single physical sample. The intermediate analysis entity allows for the association of multiple proxies per sample. Entries typically reflect count values (abundance), but can also denote presence (1) or use categorical or relative scales, as specified by the dataset’s data type.

Columns

Column Type Size Nulls Auto Children Parents Comments
abundance_id int8 19 √
tbl_abundance_ident_levels.abundance_id fk_abundance_ident_levels_abundance_id R
tbl_abundance_modifications.abundance_id fk_abundance_modifications_abundance_id R

Primary key (automatically incremented).
taxon_id int4 10
tbl_taxa_tree_master.taxon_id fk_abundances_taxon_id C

Specifies the taxonomic unit related to this record.
analysis_entity_id int8 19
tbl_analysis_entities.analysis_entity_id fk_abundances_analysis_entity_id R

Identifies the specific analysis entity associated with this record.
abundance_element_id int4 10 √
tbl_abundance_elements.abundance_element_id fk_abundances_abundance_elements_id R

Specifies specific parts of a taxon, like leaf, seed, or MNI (Minimum Number of Individuals), enabling detailed taxonomic recording.
abundance int4 10

Represents the frequency of occurrence, which is usually a numerical count, but can also indicate presence (1), a categorical value, or a value on a relative scale, in accordance with the dataset’s data type.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_abundances_pkey Primary key Asc abundance_id
idx_abundances_abundance_element_id Performance Asc abundance_element_id
idx_abundances_analysis_entity_id Performance Asc analysis_entity_id
idx_abundances_taxon_id Performance Asc taxon_id

Relationships

Close relationships within degrees of separation