ODM2 Tables
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

Table NameCommentSchema
ActionAnnotationsNotes for or groups of one or more Actions.ODM2Annotations
ActionByAffiliates people with actions and describes thier role in the action.ODM2Core
ActionDirectives ODM2LabAnalyses
ActionExtensionPropertyValues ODM2ExtensionProperties
ActionsDescribes actions (e.g., observation, sample collection, sample analysis, field visits, field activities, etc.)ODM2Core
AffiliationsDescribes affiliations of people with organizations.ODM2Core
AnnotationsContains text annotations added to one or more records within various ODM2 tables. Annotations can be used to record notes about a particular SamplingFeature, Action, Result, etc. or to create groups of records such as Specimens, Sites, People, etc.ODM2Annotations
AuthorListsRelationship between Citations and their AuthorsODM2Provenance
CV_ActionTypeTable containing terms used in the ActionType controlled vocabulary.ODM2CV
CV_AggregationStatisticTable containing terms used in the AggregationStatistic controlled vocabulary.ODM2CV
CV_AnnotationTypeTable containing terms used in the AnnotationType controlled vocabulary.ODM2CV
CV_CensorCodeTable containing terms used in the CensorCode controlled vocabulary.ODM2CV
CV_DataQualityTypeTable containing terms used in the DataQualityType controlled vocabulary.ODM2CV
CV_DatasetTypeTable containing terms used in the DatasetType controlled vocabulary.ODM2CV
CV_DirectiveTypeTable containing terms used in the DirectiveType controlled vocabulary.ODM2CV
CV_ElevationDatumTable containing terms used in the ElevationDatum controlled vocabulary.ODM2CV
CV_EquipmentTypeTable containing terms used in the EquipmentType controlled vocabulary.ODM2CV
CV_MediumTable containing terms used in the Medium controlled vocabulary.ODM2CV
CV_MethodTypeTable containing terms used in the MethodType controlled vocabulary.ODM2CV
CV_OrganizationTypeTable containing terms used in the OrganizationType controlled vocabulary.ODM2CV
CV_PropertyDataTypeTable containing terms used in the PropertyDataType controlled vocabulary.ODM2CV
CV_QualityCodeTable containing terms used in the QualityCode controlled vocabulary.ODM2CV
CV_RelationshipTypeTable containing terms used in the RelationshipType controlled vocabulary.ODM2CV
CV_ResultTypeTable containing terms used in the ResultType controlled vocabulary.ODM2CV
CV_SamplingFeatureGeoTypeTable containing terms used in the SamplingFeatureGeoType controlled vocabulary.ODM2CV
CV_SamplingFeatureTypeTable containing terms used in the SamplingFeatureType controlled vocabulary.ODM2CV
CV_SiteTypeTable containing terms used in the SiteType controlled vocabulary.ODM2CV
CV_SpatialOffsetTypeTable containing terms used in the SpatialOffsetType controlled vocabulary.ODM2CV
CV_SpeciationTable containing terms used in the Speciation controlled vocabulary.ODM2CV
CV_SpecimenTypeTable containing terms used in the SpecimenType controlled vocabulary.ODM2CV
CV_StatusTable containing terms used in the Status controlled vocabulary.ODM2CV
CV_TaxonomicClassifierTypeTable containing terms used in the TaxonomicClassifierType controlled vocabulary.ODM2CV
CV_UnitsTypeTable containing terms used in the UnitsType controlled vocabulary.ODM2CV
CV_VariableNameTable containing terms used in the VariableName controlled vocabulary.ODM2CV
CV_VariableTypeTable containing terms used in the VariableType controlled vocabulary.ODM2CV
CalibrationActionsInformation about calibration ActionsODM2Equipment
CalibrationReferenceEquipmentInformation about equipment used as referenece for a calibrationODM2Equipment
CalibrationStandardsBridge table linking field calibrations to the reference materials usedODM2Equipment
CategoricalResultValueAnnotationsAnnotations for Categorical ResultValuesODM2Annotations
CategoricalResultValues ODM2Results
CategoricalResults ODM2Results
CitationExtensionPropertyValuesValues for Citation Extension PropertiesODM2ExtensionProperties
CitationExternalIdentifiers ODM2ExternalIdentifiers
CitationsInformation about CitationsODM2Provenance
DataLoggerFilesDestibes datalogger files created by a deployment actionODM2Equipment
DataQuality ODM2DataQuality
DataloggerFileColumnsInformation about columns in datalogger filesODM2Equipment
DataloggerProgramFilesInformation about datalogger program filesODM2Equipment
DatasetCitationsRelationship between DataSets and CitationsODM2Provenance
DatasetsDescribes groupings of observation results that can be considered "datasets"ODM2Core
DatasetsResultsLists the Results that are grouped into a DataSetODM2Core
DerivationEquationsDerivationEquations include calibration equations, normalizations, etc. on one or more RelatedResults to produce a DerivedResult.ODM2Provenance
DirectivesDescribes the directive or purpose under which actions are made. Directives can be projects, intended analyses for a specimen, etc.ODM2LabAnalyses
EquipmentDescriptions of specific pieces of equipment.ODM2Equipment
EquipmentAnnotationsBridge table linking Annotations to EquipmentODM2Annotations
EquipmentModelsDescribes models of sensors, loggers, and related equipment used in making observations.ODM2Equipment
EquipmentUsed ODM2Equipment
ExtensionPropertiesDescribes extension properties added to objects in an ODM databaseODM2ExtensionProperties
ExternalIdentifierSystemsA single table for connecting various primary keys with points to outside systems.ODM2ExternalIdentifiers
FeatureActions ODM2Core
InstrumentOutputVariablesInformation about the Variables that an instrument is capable of measuringODM2Equipment
MaintenanceActionsInformation about maintenance Actions performed on EquipmentODM2Equipment
MeasurementResultValueAnnotationsAnnotations for Measurement ResultValuesODM2Annotations
MeasurementResultValues ODM2Results
MeasurementResults ODM2Results
MethodAnnotationsNotes for or groups of one or more Methods.ODM2Annotations
MethodCitations ODM2Provenance
MethodExtensionPropertyValuesLinks extnsion properties to a MethodODM2ExtensionProperties
MethodExternalIdentifiers ODM2ExternalIdentifiers
MethodsDescribes methods used to perform actions recorded in ODM (e.g., observation methods, sample analysis methods, sample preparation methods, etc.)ODM2Core
ModelAffiliations ODM2Simulation
Models ODM2Simulation
OrganizationsDescribes organizations - as in research groups, companies, universities, etc.ODM2Core
PeopleDescribes people.ODM2Core
PersonExternalIdentifiersCross reference "linking" table to allow many to many ODM2ExternalIdentifiers
PointCoverageResultValueAnnotationsAnnotations for Point Coverage ResultValuesODM2Annotations
PointCoverageResultValues ODM2Results
PointCoverageResults ODM2Results
ProcessingLevelsDescribes the processing level of ResultsODM2Core
ProfileResultValueAnnotationsAnnotations for Profile ResultValuesODM2Annotations
ProfileResultValuesNumeric values of Depth Profile Results.ODM2Results
ProfileResultsInformation about Profile ResultsODM2Results
ReferenceMaterialExternalIdentifiers ODM2ExternalIdentifiers
ReferenceMaterialValues"Accepted" property values for a Reference Material, which can be certified by an agency or vendor, established in the literature by the research community, or developed for "in house" use only by a laboratory.ODM2DataQuality
ReferenceMaterialsDescribes materials that are used for the calibration of an instrument, the assessment of a measurement method, or for assigning values to unknown specimens.ODM2DataQuality
RelatedActionsDescribes Actions that are related to one another.ODM2Core
RelatedAnnotationsStores information about relationships among AnnotationsODM2Provenance
RelatedCitationsInformation about relationships among citationsODM2Provenance
RelatedDatasetsInformation about relationships among DataSetsODM2Provenance
RelatedEquipmentInformation about relationships among EquipmentODM2Equipment
RelatedFeaturesDescribes parrent/child relationships among Sampling FeaturesODM2SamplingFeatures
RelatedModels ODM2Simulation
RelatedResultsInformation about relationships among ResultsODM2Provenance
ResultAnnotationsNotes for or groups of one or more Results [sets].ODM2Annotations
ResultDerivationEquationsRelationship between Results and Equations used to derive themODM2Provenance
ResultExtensionPropertyValuesLinks extension properties to a ResultODM2ExtensionProperties
ResultNormalizationValuesExtends the Results table with a foreign key to NormalizationReferenceMaterialValues when the optional DataQuality schema is implemented. In a database implementation, we would not implement this as a separate table from Results.ODM2DataQuality
ResultsDescribes the results of observation actions (e.g., groups of one or more numeric data values that result from an observation action)ODM2Core
ResultsDataQuality ODM2DataQuality
SamplingFeatureAnnotationsNotes for or groups of one or more Sampling Features.ODM2Annotations
SamplingFeatureExtensionPropertyValues ODM2ExtensionProperties
SamplingFeatureExternalIdentifiers ODM2ExternalIdentifiers
SamplingFeaturesDescribes the sampling features on which observations are made.ODM2Core
SectionResultValueAnnotationsAnnotations for Section ResultValuesODM2Annotations
SectionResultValues ODM2Results
SectionResults ODM2Results
Simulations ODM2Simulation
SitesDescribes sampling features that are point sitesODM2SamplingFeatures
SpatialOffsetsAn explicit spatial relationship between a sampling feature relative to it's parent.ODM2SamplingFeatures
SpatialReferenceExternalIdentifiers ODM2ExternalIdentifiers
SpatialReferencesDescribes spatial reference systems used to reference the coordinates for sitesODM2SamplingFeatures
SpecimenBatchPostionsExtends the FeatureActions table with a foreign key when the optional LabAnalyses schema is implemented. In a database implementation, we would not implement this as a separate table from FeatureActions, but rather just add the additional field(s).ODM2LabAnalyses
SpecimenTaxonomicClassifiersThis cross-reference table allows Taxonomic Classification of Specimens as an annotation, rather than as a Result.ODM2SamplingFeatures
SpecimensEquivalent to O&M Sampling Feature Type "Specimen". Describes physical samples or specimens.ODM2SamplingFeatures
SpectraResultValueAnnotationsAnnotations for Spectra ResultValuesODM2Annotations
SpectraResultValues ODM2Results
SpectraResults ODM2Results
TaxonomicClassifierExternalIdentifiers ODM2ExternalIdentifiers
TaxonomicClassifiers ODM2Core
TimeSeriesResultValueAnnotationsAnnotations for Time Series ResultValuesODM2Annotations
TimeSeriesResultValues ODM2Results
TimeSeriesResults ODM2Results
TrajectoryResultValueAnnotationsAnnotations for Trajectory ResultValuesODM2Annotations
TrajectoryResultValues ODM2Results
TrajectoryResults ODM2Results
TransectResultValueAnnotationsAnnotations for Transect ResultValuesODM2Annotations
TransectResultValues ODM2Results
TransectResults ODM2Results
UnitsDescribes units of measure for varibles and timeODM2Core
VariableExtensionPropertyValues ODM2ExtensionProperties
VariableExternalIdentifiers ODM2ExternalIdentifiers
VariablesStores information about measured properties.ODM2Core