dic_lith_composition

10 rows


Description

Dictionary of terms to describe the composition of samples e.g. calcareous, siliceous, carbonaceous. Based on table from Potter et al. 2005 Mud and Mudstones

Columns

Column Type Size Nulls Auto Default Children Parents Comments
lith_composition_id serial 10 √ nextval('dic_lith_comp_lith_comp_id_seq'::regclass)
sample.lith_composition_id dic_lith_composition_sample_fkR

PK. Unique identifier. Generated by database
lith_composition varchar 100 √ null

Compositional term, e.g. calcareous, siliceous
lith_composition_desc varchar 255 √ null

Description/definition of compositonal term
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
lith_composition_id Primary key Asc lith_composition_id

Relationships

Close relationships within degrees of separation