lithology

17560 rows


Description

This table stores the lithologic descriptions of Collection Units.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
lithologyid serial 10 nextval('ndb.seq_lithology_lithologyid'::regclass)
collectionunitid int4 10 null
collectionunits.collectionunitid fk_lithology_collectionunitsC
depthtop float8 17,17 null
depthbottom float8 17,17 null
lowerboundary varchar 255 null
description text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

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

Relationships