depenvttypes

222 rows


Description

Lookup table of Depositional Environment Types. Table is referenced by the CollectionUnits table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
depenvtid serial 10 nextval('ndb.seq_depenvttypes_depenvtid'::regclass)
collectionunits.depenvtid fk_collectionunits_depenvttypesC
depenvttypes.depenvthigherid fk_depenvthigheridR
depenvt varchar 255 null
depenvthigherid int4 10 null
depenvttypes.depenvtid fk_depenvthigheridR
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
depenvttypes_pkey Primary key Asc depenvtid

Relationships