variables

55155 rows


Description

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.

Columns

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

Indexes

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

Relationships

Close relationships within degrees of separation