dic_weathering

7 rows


Description

Dictionary of weathering terms from the International Society for Rock Mechanics (and others). Rarely used, legacy table from the early stages of SGP project.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
weath_grade varchar 5 null
sample.weath_grade dic_weathering_sample_fk R

PK. Numbered gradation, with I being the least weathered and VI the most weathered

weath_term varchar 100 null

Short descriptive term of weathering grade

weath_desc varchar 4000 null

Descriptive definition of weathering grades

timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 now()

Indexes

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

Relationships