variables

43825 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
taxonid int4 10 null
taxa.taxonid fk_variables_taxaC
variableelementid int4 10 null
variableelements.variableelementid fk_variables_variableelementsC
variableunitsid int4 10 null
variableunits.variableunitsid fk_variables_variableunitsC
variablecontextid int4 10 null
variablecontexts.variablecontextid fk_variables_variablecontextsC
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