tbl_abundance_modifications

7594 rows


Description

Stores information about modifications applied to individual specimen counts, such as carbonization, corrosion, or calcification. This enables recording multiple instances of the same taxon with varying modifications (e.g., Hordeum sp. carbonized and Hordeum sp. unmodified).

Columns

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

Primary key (automatically incremented).
abundance_id int4 10
tbl_abundances.abundance_id fk_abundance_modifications_abundance_id R

Specifies the related abundance record.
modification_type_id int4 10
tbl_modification_types.modification_type_id fk_abundance_modifications_modification_type_id R

Specifies the type of modification applied.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_abundance_modifications_pkey Primary key Asc abundance_modification_id
idx_abundance_modifications_abundance_id Performance Asc abundance_id
idx_abundance_modifications_modification_type_id Performance Asc modification_type_id

Relationships

Close relationships within degrees of separation