ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

Variables

Stores information about measured properties.

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	VariableID	Integer				Primary key identifier
	VariableTypeCV	VarChar(255)				Controlled vocabulary for the type of variable
	VariableCode	VarChar(50)				Unique text code for the variable
	VariableNameCV	VarChar(255)				Controlled vocabulary for the name of the variable
	VariableDefinition	VarChar(5000)				Text definition of the variable
	SpeciationCV	VarChar(255)				Speciation for the variable (e.g., expressed as P or as PO4)
	NoDataValue	Double				A numeric value indicating no data.

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Variables_CV_Speciation	ODM2CV.CV_Speciation	ODM2Core.Variables	Name	SpeciationCV
fk_Variables_CV_VariableName	ODM2CV.CV_VariableName	ODM2Core.Variables	Name	VariableNameCV
fk_Variables_CV_VariableType	ODM2CV.CV_VariableType	ODM2Core.Variables	Name	VariableTypeCV

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Results_Variables	ODM2Core.Variables	ODM2Core.Results	VariableID	VariableID
fk_ReferenceMaterialValues_Variables	ODM2Core.Variables	ODM2DataQuality.ReferenceMaterialValues	VariableID	VariableID
fk_InstrumentOutputVariables_Variables	ODM2Core.Variables	ODM2Equipment.InstrumentOutputVariables	VariableID	VariableID
fk_VariableExtensionPropertyValues_Variables	ODM2Core.Variables	ODM2ExtensionProperties.VariableExtensionPropertyValues	VariableID	VariableID
fk_VariableExternalIdentifiers_Variables	ODM2Core.Variables	ODM2ExternalIdentifiers.VariableExternalIdentifiers	VariableID	VariableID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Core

ODM2Equipment

ODM2ExtensionProperties

ODM2ExternalIdentifers

ODM2OverviewSimplified

ODM2Simulation