48476 rows


This table lists Variables, which always consist of a Taxon and Units of measurement. Variables can also have Elements, Contexts, and Modifications. Thus, the same taxon with different measurement units (e.g. present/absent, NISP, MNI) are different Variables.


Column Type Size Nulls Auto Default Children Parents Comments
variableid serial 10 nextval('ndb.seq_variables_variableid'::regclass)
data.variableid fk_data_variablesC
datasetvariables.variableid fk_datasetvariables_variablesC
dsdatasample.variableid Implied ConstraintR
isoinstrumentation.variableid fk_isoinstrumentation_variablesC
isosrmetadata.variableid fk_isosrmetadata_variablesC
isostandards.variableid fk_isostandards_variablesC
isovariablescaletypes.variableid fk_isovariablescaletypes_variablesC

An arbitrary Variable identification number.

taxonid int4 10 null
taxa.taxonid fk_variables_taxaC

Taxon identification number. Field links to the Taxa table.

variableelementid int4 10 null
variableelements.variableelementid fk_variables_variableelementsC

Variable Element identification number. Field links to the VariableElements lookup table.

variableunitsid int4 10 null
variableunits.variableunitsid fk_variables_variableunitsC

Variable Units identification number. Field links to the VariableUnits lookup table.

variablecontextid int4 10 null
variablecontexts.variablecontextid fk_variables_variablecontextsC

Variable Context identification number. Field links to the VariableContexts lookup table.

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


Constraint Name Type Sort Column(s)
variables_pkey Primary key Asc variableid
ix_taxonid_variables Performance Asc taxonid
variableel Performance Asc/Asc/Asc taxonid + variableelementid + variableunitsid