variablecontexts

71 rows


Description

Variable Contexts lookup table. Table is referenced by the Variables table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
variablecontextid serial 10 nextval('ndb.seq_variablecontexts_variablecontextid'::regclass)
contextsdatasettypes.variablecontextid fk_contextsdatasettypes_variablecontexts C
variables.variablecontextid fk_variables_variablecontexts C

An arbitrary Variable Context identification number.

variablecontext varchar 64 null

Depositional context. Examples are: *anachronic – specimen older than the primary deposit, e.g. a Paleozoic spore in a Holocene deposit; may be redeposited from the catchment or may be derived from long distance, e.g. Tertiary pollen grains in Quaternary sediments with no local Tertiary source. A Pleistocene specimen in a Holocene archaeological deposit, possibly resulting from aboriginal fossil collecting, would also be anachronic. *intrusive – specimen generally younger younger than the primary deposit, e.g. a domestic pig in an otherwise Pleistocene deposit in North America. *redeposited – specimen older than the primary deposit and assumed to have been redeposited from a local source by natural causes. *articulated – articulated skeleton *clump – clump, esp. of pollen grains

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

Indexes

Constraint Name Type Sort Column(s)
variablecontexts_pkey Primary key Asc variablecontextid

Relationships