ODMXDataQuality - Schema
HomeTablesSchemasDiagramsForeign KeysIndexes

Schema: ODMXDataQuality

Tables

Table NameComment
DataQuality
ReferenceMaterialsDescribes materials that are used for the calibration of an instrument, the assessment of a measurement method, or for assigning values to unknown specimens.
ReferenceMaterialValues"Accepted" property values for a Reference Material, which can be certified by an agency or vendor, established in the literature by the research community, or developed for "in house" use only by a laboratory.
ResultNormalizationValuesExtends 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.
ResultsDataQuality

Procedures

(none)

Views

(none)

Sequences

NameComment
ReferenceMaterials_ReferenceMaterialID_seqDbWrench Autogenerated Sequence.
ReferenceMaterialValues_ReferenceMaterialValueID_seqDbWrench Autogenerated Sequence.
ResultsDataQuality_BridgeID_seqDbWrench Autogenerated Sequence.