ODM2 [ODM2_DBWrench_Schema.xml] |
Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
Specimens | Equivalent to O&M Sampling Feature Type "Specimen". Describes physica... |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
| SamplingFeatureID | Integer | Foreign key identifier for the Sampling Feature that is the specimen |
|
|||
SpecimenTypeCV | VarChar(255) | A CV term defining the type of specimen (e.g., aquatic sample, core, etc.) |
|
||||
SpecimenMediumCV | VarChar(255) | 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 |
Indexes (none) |
Foreign Keys | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_Specimens_CV_Medium | ODM2CV.CV_Medium | ODM2SamplingFeatures.Specimens | Name | SpecimenMediumCV |
fk_Specimens_CV_SpecimenType | ODM2CV.CV_SpecimenType | ODM2SamplingFeatures.Specimens | Name | SpecimenTypeCV |
fk_Specimens_SamplingFeatures | ODM2Core.SamplingFeatures | ODM2SamplingFeatures.Specimens | SamplingFeatureID | SamplingFeatureID |
Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_SpecimenTaxonomicClassifiers_Specimens | ODM2SamplingFeatures.Specimens | ODM2SamplingFeatures.SpecimenTaxonomicClassifiers | SamplingFeatureID | SamplingFeatureID |
Used in Diagrams |
Diagram Name |
ODM2DataQuality |
ODM2LabAnalyses |
ODM2OverviewSimplified |
ODM2SamplingFeatures |