datasettypes

43 rows


Description

Lookup table for Dataset Types. Table is referenced by the Datasets table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
datasettypeid serial 10 nextval('ndb.seq_datasettypes_datasettypeid'::regclass)
contextsdatasettypes.datasettypeid fk_contextsdatasettypes_datasettypes C
datasets.datasettypeid fk_datasets_datasettypes C
datasettaxagrouptypes.datasettypeid fk_datasettaxagrouptypes_datasettypes C
elementdatasettaxagroups.datasettypeid fk_datasettypeid R
taphonomicsystemsdatasettypes.datasettypeid fk_taphonomicsystemsdatasettypes_taphonomicsystemsdatasettypes C
unitsdatasettypes.datasettypeid fk_unitsdatasettypes_datasettypes C

An arbitrary Dataset Type identification number.

datasettype varchar 64 null

The Dataset type, including the following: geochronologic loss-on-ignition pollen plant macrofossils vertebrate fauna mollusks

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

Indexes

Constraint Name Type Sort Column(s)
datasettypes_pkey Primary key Asc datasettypeid

Relationships