ODMX [ODMX_DBWrench_Schema.xml]
Equivalent to O&M Sampling Feature Type "Specimen". Describes physical samples or specimens.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| SamplingFeatureID | Integer | Foreign key identifier for the Sampling Feature that is the specimen |
|
|||
| SpecimenTypeCV | VarChar() | A CV term defining the type of specimen (e.g., aquatic sample, core, etc.) |
|
||||
| SpecimenMediumCV | VarChar() | A CV term defining the medium of the specimen (i.e. water, sediment, etc.) |
|
||||
| IsFieldSpecimen | Boolean | A boolean indicating whether the specimen was collected in the field | |||||
| SpecimenCollectionDateTime | DateTime |
| The UTC date and time that the specimen was collected at |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Specimens_CV_Medium | ODMXCV.CV_Medium | ODMXSamplingFeatures.Specimens | Term | SpecimenMediumCV |
| fk_Specimens_CV_SpecimenType | ODMXCV.CV_SpecimenType | ODMXSamplingFeatures.Specimens | Term | SpecimenTypeCV |
| fk_Specimens_SamplingFeatures | ODMXCore.SamplingFeatures | ODMXSamplingFeatures.Specimens | SamplingFeatureID | SamplingFeatureID |
(none)
| Diagram Name |
| ODMXDataQuality |
| ODMXLabAnalyses |
| ODMXMicrobial |
| ODMXOverviewSimplified |
| ODMXSamplingFeatures |