datasettypes

41 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_datasettypesC
datasets.datasettypeid fk_datasets_datasettypesC
datasettaxagrouptypes.datasettypeid fk_datasettaxagrouptypes_datasettypesC
elementdatasettaxagroups.datasettypeid fk_datasettypeidR
taphonomicsystemsdatasettypes.datasettypeid fk_taphonomicsystemsdatasettypes_taphonomicsystemsdatasettypesC
unitsdatasettypes.datasettypeid fk_unitsdatasettypes_datasettypesC

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