dic_lith_texture

4 rows


Description

Dictionary of terms to describe the lithological texture of samples e.g. silty, muddy, clayey, sandy. Based on table from Potter et al. 2005 Mud and Mudstones

Columns

Column Type Size Nulls Auto Default Children Parents Comments
lith_texture_id serial 10 √ nextval('dic_lith_texture_lith_texture_id_seq'::regclass)
sample.lith_texture_id dic_lith_texture_sample_fkR

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

Textural term, e.g. silty, sandy
lith_texture_desc varchar 255 √ null

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

Indexes

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

Relationships

Close relationships within degrees of separation