152 rows


Lookup table of Variable Units. Table is referenced by the Variables table.


Column Type Size Nulls Auto Default Children Parents Comments
variableunitsid serial 10 nextval('ndb.seq_variableunits_variableunitsid'::regclass)
accumulationrates.variableunitsid fk_accumulationrates_variableunitsC
analysisunitaltdepthscales.variableunitsid fk_analysisunitaltdepths_variableunitsC
unitsdatasettypes.variableunitsid fk_unitsdatasettypes_variableunitsC
variables.variableunitsid fk_variables_variableunitsC

An arbitrary Variable Units identification number.

variableunits varchar 64 null

The units of measurement. For fauna, these are «present/absent», «NISP» (Number of Individual Specimens), and «MNI» (Minimum Number of Individuals). For pollen, these are «NISP» (pollen counts) and «percent». Units for plant macrofossils include «present/absent» and «NISP», as well as a number of quantitative concentration measurements and semi-quantitative abundance measurements such as «1-5 scale». Examples of charcoal measurement units are «fragments/ml» and «µm^2/ml».

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


Constraint Name Type Sort Column(s)
variableunits_pkey Primary key Asc variableunitsid