ODMXSamplingFeatures - Schema
HomeTablesSchemasDiagramsForeign KeysIndexes

Schema: ODMXSamplingFeatures

Tables

Table NameComment
FeaturesOfInterest
RelatedFeaturesDescribes parrent/child relationships among Sampling Features
SampledFeatures
SpatialOffsetsAn explicit spatial relationship between a sampling feature relative to it's parent.
SpatialReferencesDescribes spatial reference systems used to reference the coordinates for sites
SpecimenCollectionThis has the specimen collection information
SpecimensEquivalent to O&M Sampling Feature Type "Specimen". Describes physical samples or specimens.
SpecimenTaxonomicClassifiersThis cross-reference table allows Taxonomic Classification of Specimens as an annotation, rather than as a Result.
SpecimenToSpecimenCollectionBridgethis is a bridge between specimens and specimencollections

Procedures

(none)

Views

(none)

Sequences

NameComment
RelatedFeatures_RelationID_seqDbWrench Autogenerated Sequence.
SpatialOffsets_SpatialOffsetID_seqDbWrench Autogenerated Sequence.
SpatialReferences_SpatialReferenceID_seqDbWrench Autogenerated Sequence.
SpecimenTaxonomicClassifiers_BridgeID_seqDbWrench Autogenerated Sequence.