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			nextval('"ODM2Core"."Variables_VariableID_seq"'::regclass)	Primary key identifier
	VariableTerm	VarChar(255)
	VariableName	VarChar(255)				The Human Readable name for the parameter
	VariableDefinition	VarChar(5000)				Text definition of the variable
	VariableDomainCV	VarChar(255)				CV for the Variable Domain
	SampledMediumCV	VarChar(255)				Controlled vocabulary for sampled Medium
	TaxonomicClassifierID	Integer				Classifier describing object "species" or other classification of the variable and from a biological, chemical, geological or other kind of taxonomy. Typically associated with an External Idenfication System.
	SpeciationID	Integer				Speciation for the variable
	QuantityKindCV	VarChar(255)				Controlled vocabulary for the type of variable
	VariableSourceURI	VarChar(1000)				Link to additional information on the variable

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Variables_CV_Medium	ODM2CV.CV_Medium	ODM2Core.Variables	Term	SampledMediumCV
fk_Variables_CV_QuantityKind	ODM2CV.CV_QuantityKind	ODM2Core.Variables	Term	QuantityKindCV
fk_Variables_CV_VariableDomain	ODM2CV.CV_VariableDomain	ODM2Core.Variables	Term	VariableDomainCV
fk_Variables_speciationid_TaxonomicClassifiers	ODM2Core.TaxonomicClassifiers	ODM2Core.Variables	TaxonomicClassifierID	SpeciationID
fk_Variables_TaxonomicClassifiers	ODM2Core.TaxonomicClassifiers	ODM2Core.Variables	TaxonomicClassifierID	TaxonomicClassifierID

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_InstrumentOutputQuantityKind_Variables	ODM2Core.Variables	ODM2Equipment.InstrumentOutputQuantityKind	VariableID	InstrumentStandardOutputVariable
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

ODM2ExternalIdentifiers

ODM2OverviewSimplified

ODM2Simulation