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

Triggers (none)

Used in Diagrams

Diagram Name

ODM2DataQuality

ODM2Equipment

ODM2ExternalIdentifers

ODM2LabAnalyses