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
	SpecimenCollectionID	Integer

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Specimens_CV_Medium	ODM2CV.CV_Medium	ODM2SamplingFeatures.Specimens	Term	SpecimenMediumCV
fk_Specimens_CV_SpecimenType	ODM2CV.CV_SpecimenType	ODM2SamplingFeatures.Specimens	Term	SpecimenTypeCV
fk_Specimens_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2SamplingFeatures.Specimens	SamplingFeatureID	SamplingFeatureID
fk_Specimens_SpecimenCollection	ODM2SamplingFeatures.SpecimenCollection	ODM2SamplingFeatures.Specimens	SpecimenCollectionID	SpecimenCollectionID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SpecimenTaxonomicClassifiers_Specimens	ODM2SamplingFeatures.Specimens	ODM2SamplingFeatures.SpecimenTaxonomicClassifiers	SamplingFeatureID	SamplingFeatureID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2DataQuality

ODM2LabAnalyses

ODM2OverviewSimplified

ODM2SamplingFeatures