ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

ReferenceMaterialValues

"Accepted" property values for a Reference Material, which can be cert...

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	ReferenceMaterialValueID	Integer				The primary key for ReferenceMaterialValues
	ReferenceMaterialID	Integer				A foreign key to ReferenceMaterials
	ReferenceMaterialValue	Float				The established property value for the ReferenceMaterial.
	ReferenceMaterialAccuracy	Float				The established accuracy of the property value for the ReferenceMaterial, in the same units as the value.
	VariableID	Integer				The property that is quantified by the ReferenceMaterialValue
	UnitsID	Integer				The units for the ReferenceMaterialValue and ReferenceMaterialAccuracy
	CitationID	Integer				The attribution for source that established the ReferenceMaterialValue and ReferenceMaterialAccuracy

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ReferenceMaterialValues_Citations	ODM2Provenance.Citations	ODM2DataQuality.ReferenceMaterialValues	CitationID	CitationID
fk_ReferenceMaterialValues_ReferenceMaterials	ODM2DataQuality.ReferenceMaterials	ODM2DataQuality.ReferenceMaterialValues	ReferenceMaterialID	ReferenceMaterialID
fk_ReferenceMaterialValues_Units	ODM2Core.Units	ODM2DataQuality.ReferenceMaterialValues	UnitsID	UnitsID
fk_ReferenceMaterialValues_Variables	ODM2Core.Variables	ODM2DataQuality.ReferenceMaterialValues	VariableID	VariableID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ResultNormalizationValues_ReferenceMaterialValues	ODM2DataQuality.ReferenceMaterialValues	ODM2DataQuality.ResultNormalizationValues	ReferenceMaterialValueID	NormalizedByReferenceMaterialValueID

Used in Diagrams

Diagram Name

ODM2DataQuality

ODM2Equipment