ODMX [ODMX_DBWrench_Schema.xml]
"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.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ReferenceMaterialValueID | Integer |
| nextval('"ODMXDataQuality"."ReferenceMaterialValues_ReferenceMaterialValueID_seq"'::regclass) | 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 |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ReferenceMaterialValues_Citations | ODMXProvenance.Citations | ODMXDataQuality.ReferenceMaterialValues | CitationID | CitationID |
| fk_ReferenceMaterialValues_ReferenceMaterials | ODMXDataQuality.ReferenceMaterials | ODMXDataQuality.ReferenceMaterialValues | ReferenceMaterialID | ReferenceMaterialID |
| fk_ReferenceMaterialValues_Variables | ODMXCore.Variables | ODMXDataQuality.ReferenceMaterialValues | VariableID | VariableID |
(none)
| Diagram Name |
| ODMXDataQuality |
| ODMXEquipment |