neo_variableunits

210 rows


Description

Is a Neotoma lookup table of Variable Units. This table is referenced by the ippd_variables table. (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#variableunits)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
VARUNITID int4 10 null
ippd_variables.VARUNITID <--VARUNITID_from_neo_variableunits_fkey R

Is the original Neotoma variableunitsid

VARUNIT text 2147483647 null

The units of measurement. For fauna, these are «present/absent», «NISP» (Number of Individual Specimens), and «MNI» (Minimum Number of Individals). For pollen, these are «NISP» (pollen counts) and «percent». Units for plant macrofossils include «present/abesnt» 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».

CREATED_AT timestamptz 35,6 timezone('UTC'::text, now())

Is record timestamp with timezone based on UTC

UPDATED_AT timestamptz 35,6 timezone('UTC'::text, now())

Is timestamp of record update with timezone based on UTC

Indexes

Constraint Name Type Sort Column(s)
neo_variableunits_pkey Primary key Asc VARUNITID

Relationships