Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| colltypeid | serial | 10 | √ | nextval('ndb.seq_collectiontypes_colltypeid'::regclass) |
|
|
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 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| collectiontypes_pkey | Primary key | Asc | colltypeid |