variables

56878 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_variables C
datasetvariables.variableid fk_datasetvariables_variables C
dsdatasample.variableid Implied Constraint R
isoinstrumentation.variableid fk_isoinstrumentation_variables C
isosrmetadata.variableid fk_isosrmetadata_variables C
isostandards.variableid fk_isostandards_variables C
isovariablescaletypes.variableid fk_isovariablescaletypes_variables C

An arbitrary Variable identification number.
taxonid int4 10 null
taxa.taxonid fk_variables_taxa C

Taxon identification number. Field links to the Taxa table.
variableelementid int4 10 √ null
variableelements.variableelementid fk_variables_variableelements C

Variable Element identification number. Field links to the VariableElements lookup table.
variableunitsid int4 10 √ null
variableunits.variableunitsid fk_variables_variableunits C

Variable Units identification number. Field links to the VariableUnits lookup table.
variablecontextid int4 10 √ null
variablecontexts.variablecontextid fk_variables_variablecontexts C

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
variables_unique Must be unique Asc/Asc/Asc/Asc taxonid + variableelementid + variableunitsid + variablecontextid

Relationships

Close relationships within degrees of separation