Variables - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

VariablesStores information about measured properties.

PKNameData TypeNULLsA/NDefaultCommentFK

VariableIDInteger

Primary key identifier
VariableTypeCVVarChar(255) Controlled vocabulary for the type of variable

VariableCodeVarChar(50) Unique text code for the variable
VariableNameCVVarChar(255) Controlled vocabulary for the name of the variable

VariableDefinitionVarChar(5000)

Text definition of the variable
SpeciationCVVarChar(255)

Speciation for the variable (e.g., expressed as P or as PO4)

NoDataValueDouble A numeric value indicating no data.


NameParent TableChild TableParent ColumnsChild Columns
fk_Variables_CV_SpeciationODM2CV.CV_SpeciationODM2Core.VariablesNameSpeciationCV
fk_Variables_CV_VariableNameODM2CV.CV_VariableNameODM2Core.VariablesNameVariableNameCV
fk_Variables_CV_VariableTypeODM2CV.CV_VariableTypeODM2Core.VariablesNameVariableTypeCV

NameParent TableChild TableParent ColumnsChild Columns
fk_Results_VariablesODM2Core.VariablesODM2Core.ResultsVariableIDVariableID
fk_ReferenceMaterialValues_VariablesODM2Core.VariablesODM2DataQuality.ReferenceMaterialValuesVariableIDVariableID
fk_InstrumentOutputVariables_VariablesODM2Core.VariablesODM2Equipment.InstrumentOutputVariablesVariableIDVariableID
fk_VariableExtensionPropertyValues_VariablesODM2Core.VariablesODM2ExtensionProperties.VariableExtensionPropertyValuesVariableIDVariableID
fk_VariableExternalIdentifiers_VariablesODM2Core.VariablesODM2ExternalIdentifiers.VariableExternalIdentifiersVariableIDVariableID

Diagram Name
ODM2Core
ODM2Equipment
ODM2ExtensionProperties
ODM2ExternalIdentifers
ODM2OverviewSimplified
ODM2Simulation