11 rows


This table is a lookup table for types of Collection Units, or Collection Types. Table is referenced by the CollectionUnits table.


Column Type Size Nulls Auto Default Children Parents Comments
colltypeid serial 10 nextval('ndb.seq_collectiontypes_colltypeid'::regclass)
collectionunits.colltypeid fk_collectionunits_collectiontypesC

An arbitrary Collection Type identification number.

colltype varchar 64 null

The Collection Type. Types include cores, sections, excavations, and animal middens. Collection Units may be modern collections, surface float, or isolated specimens. Composite Collections Units include different kinds of Analysis Units, for example a modern surface sample for ostracodes and an associated water sample.

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


Constraint Name Type Sort Column(s)
collectiontypes_pkey Primary key Asc colltypeid