ODMX [ODMX_DBWrench_Schema.xml]
Describes materials that are used for the calibration of an instrument, the assessment of a measurement method, or for assigning values to unknown specimens.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ReferenceMaterialID | Integer |
| nextval('"ODMXDataQuality"."ReferenceMaterials_ReferenceMaterialID_seq"'::regclass) | The primary key to the Reference Material used to calibrate an instrument, assess a measurement method, or assign values to unknown specimens | ||
| ReferenceMaterialMediumCV | VarChar() | The medium of a Reference Material, from the same CV as SpecimenMediumCV. Examples include: water, sediment, air, tissue, etc. |
|
||||
| ReferenceMaterialOrganizationID | Integer | A foreign key to the Organization that manufactured and established property values for the ReferenceMaterial |
|
||||
| ReferenceMaterialCode | VarChar() | A code or short name used to identify the reference material. | |||||
| ReferenceMaterialLotCode | VarChar() |
| The lot, or manufactured batch, of the reference material, that is often associated with a certified set of property values | ||||
| ReferenceMaterialPurchaseDate | DateTime |
| The purchase date of a reference material, when applicable | ||||
| ReferenceMaterialExpirationDate | DateTime |
| The expiration date of a reference material, when applicable | ||||
| ReferenceMaterialCertificateLink | VarChar() |
| A URL or file path to the Certificate that provides established property values for the given lot number. | ||||
| SamplingFeatureID | Integer |
| A foreign key to SamplingFeatures. Only required when the ReferenceMaterial is Analyzed as if it were an unknown specimen. |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ReferenceMaterials_CV_Medium | ODMXCV.CV_Medium | ODMXDataQuality.ReferenceMaterials | Term | ReferenceMaterialMediumCV |
| fk_ReferenceMaterials_Organizations | ODMXCore.Organizations | ODMXDataQuality.ReferenceMaterials | OrganizationID | ReferenceMaterialOrganizationID |
| fk_ReferenceMaterials_SamplingFeatures | ODMXCore.SamplingFeatures | ODMXDataQuality.ReferenceMaterials | SamplingFeatureID | SamplingFeatureID |
(none)
| Name | Table | Columns |
| uc_ReferenceMaterialCode | ODMXDataQuality.ReferenceMaterials | ReferenceMaterialCode |
| Diagram Name |
| ODMXDataQuality |
| ODMXEquipment |
| ODMXExternalIdentifiers |
| ODMXLabAnalyses |