ODM2 [ODM2_DBWrench_Schema.xml] |
Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
ReferenceMaterials | Describes materials that are used for the calibration of an instrument... |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
| ReferenceMaterialID | Integer |
| The primary key to the Reference Material used to calibrate an instrument, assess a measurement method, or assign values to unknown specimens | |||
ReferenceMaterialMediumCV | VarChar(255) | 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(50) | A code or short name used to identify the reference material. | |||||
ReferenceMaterialLotCode | VarChar(255) |
| 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(255) |
| 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. |
|
Indexes (none) |
Foreign Keys | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_ReferenceMaterials_CV_Medium | ODM2CV.CV_Medium | ODM2DataQuality.ReferenceMaterials | Name | ReferenceMaterialMediumCV |
fk_ReferenceMaterials_Organizations | ODM2Core.Organizations | ODM2DataQuality.ReferenceMaterials | OrganizationID | ReferenceMaterialOrganizationID |
fk_ReferenceMaterials_SamplingFeatures | ODM2Core.SamplingFeatures | ODM2DataQuality.ReferenceMaterials | SamplingFeatureID | SamplingFeatureID |
Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_ReferenceMaterialValues_ReferenceMaterials | ODM2DataQuality.ReferenceMaterials | ODM2DataQuality.ReferenceMaterialValues | ReferenceMaterialID | ReferenceMaterialID |
fk_FieldCalibrationStandards_ReferenceMaterials | ODM2DataQuality.ReferenceMaterials | ODM2Equipment.CalibrationStandards | ReferenceMaterialID | ReferenceMaterialID |
fk_RefMaterialExtIdentifiers_RefMaterials | ODM2DataQuality.ReferenceMaterials | ODM2ExternalIdentifiers.ReferenceMaterialExternalIdentifiers | ReferenceMaterialID | ReferenceMaterialID |
Used in Diagrams |
Diagram Name |
ODM2DataQuality |
ODM2Equipment |
ODM2ExternalIdentifers |
ODM2LabAnalyses |