tbl_abundance_elements

0 rows


Description

Contains reference data that defines the type of element, part, or unit being counted, as indicated by the values in tbl_abundances. For insects, this is often the Minimum Number of Individuals (MNI), but it can also include individual body parts such as wings, shells, or leg segments. For plant remains (macrofossils), it generally represents specific plant parts like seeds, leaves, or bud scales.

Columns

Column Type Size Nulls Auto Children Parents Comments
abundance_element_id int4 10 √
tbl_abundances.abundance_element_id fk_abundances_abundance_elements_id R
tbl_dating_material.abundance_element_id fk_dating_material_abundance_elements_id R

Primary key (automatically incremented).
record_type_id int4 10 √
tbl_record_types.record_type_id fk_abundance_elements_record_type_id R

Specifies record types, thereby restricting the list of available elements based on the record type. This facilitates the use of the same term for different proxies, such as ‘mni insects’ versus ‘mni seeds’, without causing confusion.
element_name varchar(100) 100

Abbreviated name for the element, such as ‘mni’, ‘seed’, or ‘leaf’.
element_description text 2147483647 √

Detailed description of the element, such as ‘minimum number of individuals’, ‘base of seed grain’, or ‘covering of leaf or flower bud’.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_abundance_elements_pkey Primary key Asc abundance_element_id

Relationships

Close relationships within degrees of separation