tbl_modification_types

10 rows


Description

Specifies various modifications or alterations observed in Quaternary or sub-fossils, such as carbonization, mineralization, and fragmentation.

Columns

Column Type Size Nulls Auto Children Parents Comments
modification_type_id int4 10 √
tbl_abundance_modifications.modification_type_id fk_abundance_modifications_modification_type_id R

Primary key (automatically incremented).
modification_type_name varchar(128) 128 √

Concise identifier for the modification type, such as ‘carbonized’.
modification_type_description text 2147483647 √

Detailed description of the modification to ensure clarity and understanding, especially for those unfamiliar with domain-specific terminology.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_modification_types_pkey Primary key Asc modification_type_id
tbl_modification_types_modification_type_name_key Must be unique Asc modification_type_name
tbl_modification_types_modification_type_name_unique Must be unique Asc modification_type_name
tbl_modification_types_norm_trgm Performance

Relationships

Close relationships within degrees of separation