Table: ResultNormalizationValues

Extends the Results table with a foreign key to NormalizationReferenceMaterialValues when the optional DataQuality schema is implemented. In a database implementation, we would not implement this as a separate table from Results.

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	ResultNormalizationValuesID	BigInt
	NormalizedByReferenceMaterialValueID	Integer
	ResultID	BigInt				Unique Identifier

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ResultNormalizationValues_ReferenceMaterialValues	ODMXDataQuality.ReferenceMaterialValues	ODMXDataQuality.ResultNormalizationValues	ReferenceMaterialValueID	NormalizedByReferenceMaterialValueID
fk_ResultNormalizationValues_Results	ODMXCore.Results	ODMXDataQuality.ResultNormalizationValues	ResultID	ResultID

Triggers

(none)

Used in Diagrams

ODMXDataQuality