ReferenceMaterials - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

ReferenceMaterialsDescribes materials that are used for the calibration of an instrument...

PKNameData TypeNULLsA/NDefaultCommentFK

ReferenceMaterialIDInteger

The primary key to the Reference Material used to calibrate an instrument, assess a measurement method, or assign values to unknown specimens
ReferenceMaterialMediumCVVarChar(255) The medium of a Reference Material, from the same CV as SpecimenMediumCV. Examples include: water, sediment, air, tissue, etc.

ReferenceMaterialOrganizationIDInteger A foreign key to the Organization that manufactured and established property values for the ReferenceMaterial

ReferenceMaterialCodeVarChar(50) A code or short name used to identify the reference material.
ReferenceMaterialLotCodeVarChar(255)

The lot, or manufactured batch, of the reference material, that is often associated with a certified set of property values
ReferenceMaterialPurchaseDateDateTime

The purchase date of a reference material, when applicable
ReferenceMaterialExpirationDateDateTime

The expiration date of a reference material, when applicable
ReferenceMaterialCertificateLinkVarChar(255)

A URL or file path to the Certificate that provides established property values for the given lot number.
SamplingFeatureIDInteger

A foreign key to SamplingFeatures. Only required when the ReferenceMaterial is Analyzed as if it were an unknown specimen.



NameParent TableChild TableParent ColumnsChild Columns
fk_ReferenceMaterials_CV_MediumODM2CV.CV_MediumODM2DataQuality.ReferenceMaterialsNameReferenceMaterialMediumCV
fk_ReferenceMaterials_OrganizationsODM2Core.OrganizationsODM2DataQuality.ReferenceMaterialsOrganizationIDReferenceMaterialOrganizationID
fk_ReferenceMaterials_SamplingFeaturesODM2Core.SamplingFeaturesODM2DataQuality.ReferenceMaterialsSamplingFeatureIDSamplingFeatureID

NameParent TableChild TableParent ColumnsChild Columns
fk_ReferenceMaterialValues_ReferenceMaterialsODM2DataQuality.ReferenceMaterialsODM2DataQuality.ReferenceMaterialValuesReferenceMaterialIDReferenceMaterialID
fk_FieldCalibrationStandards_ReferenceMaterialsODM2DataQuality.ReferenceMaterialsODM2Equipment.CalibrationStandardsReferenceMaterialIDReferenceMaterialID
fk_RefMaterialExtIdentifiers_RefMaterialsODM2DataQuality.ReferenceMaterialsODM2ExternalIdentifiers.ReferenceMaterialExternalIdentifiersReferenceMaterialIDReferenceMaterialID

Diagram Name
ODM2DataQuality
ODM2Equipment
ODM2ExternalIdentifers
ODM2LabAnalyses