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

SpecimensEquivalent to O&M Sampling Feature Type "Specimen". Describes physica...

PKNameData TypeNULLsA/NDefaultCommentFK

SamplingFeatureIDInteger Foreign key identifier for the Sampling Feature that is the specimen

SpecimenTypeCVVarChar(255) A CV term defining the type of specimen (e.g., aquatic sample, core, etc.)

SpecimenMediumCVVarChar(255) A CV term defining the medium of the specimen (i.e. water, sediment, etc.)

IsFieldSpecimenBoolean A boolean indicating whether the specimen was collected in the field


NameParent TableChild TableParent ColumnsChild Columns
fk_Specimens_CV_MediumODM2CV.CV_MediumODM2SamplingFeatures.SpecimensNameSpecimenMediumCV
fk_Specimens_CV_SpecimenTypeODM2CV.CV_SpecimenTypeODM2SamplingFeatures.SpecimensNameSpecimenTypeCV
fk_Specimens_SamplingFeaturesODM2Core.SamplingFeaturesODM2SamplingFeatures.SpecimensSamplingFeatureIDSamplingFeatureID

NameParent TableChild TableParent ColumnsChild Columns
fk_SpecimenTaxonomicClassifiers_SpecimensODM2SamplingFeatures.SpecimensODM2SamplingFeatures.SpecimenTaxonomicClassifiersSamplingFeatureIDSamplingFeatureID

Diagram Name
ODM2DataQuality
ODM2LabAnalyses
ODM2OverviewSimplified
ODM2SamplingFeatures