25983 rows


This table stores the lithologic descriptions of Collection Units.


Column Type Size Nulls Auto Default Children Parents Comments
lithologyid serial 10 nextval('ndb.seq_lithology_lithologyid'::regclass)

An arbitrary identification number for a lithologic unit.

collectionunitid int4 10 null
collectionunits.collectionunitid fk_lithology_collectionunitsC

Collection Unit identification number. Field links to the CollectionUnits table.

depthtop float8 17,17 null

Depth of the top of the lithologic unit in cm.

depthbottom float8 17,17 null

Depth of the bottom of the lithologic unit in cm.

lowerboundary varchar 255 null
description text 2147483647 null

Description of the lithologic unit. These can be quite detailed, with Munsell color or Troels-Smith descriptions. Some examples:
interbedded gray silt and peat
marly fine-detritus copropel
humified sedge and Sphagnum peat
sedge peat 5YR 5/4
gray sandy loam with mammoth and other animal bones
grey-green gyttja, oxidizing to gray-brown
Ag 3, Ga 1, medium gray, firm, elastic
nig3, strf0, elas2, sicc0; Th2 T12 Tb+
Ld°4, Ga+, Dg+, Dh+

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null


Constraint Name Type Sort Column(s)
lithology_pkey Primary key Asc lithologyid
ix_collectionunitid_lithology Performance Asc collectionunitid