| Tables |
| ActionAnnotations | Notes for or groups of one or more Actions. | ODM2Annotations |
| ActionBy | Affiliates people with actions and describes thier role in the action. | ODM2Core |
| ActionDirectives | | ODM2LabAnalyses |
| ActionExtensionPropertyValues | | ODM2ExtensionProperties |
| Actions | Describes actions (e.g., observation, sample collection, sample analysis, field visits, field activities, etc.) | ODM2Core |
| Affiliations | Describes affiliations of people with organizations. | ODM2Core |
| Annotations | Contains 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 |
| AuthorLists | Relationship between Citations and their Authors | ODM2Provenance |
| CV_ActionType | Table containing terms used in the ActionType controlled vocabulary. | ODM2CV |
| CV_AggregationStatistic | Table containing terms used in the AggregationStatistic controlled vocabulary. | ODM2CV |
| CV_AnnotationType | Table containing terms used in the AnnotationType controlled vocabulary. | ODM2CV |
| CV_CensorCode | Table containing terms used in the CensorCode controlled vocabulary. | ODM2CV |
| CV_DataQualityType | Table containing terms used in the DataQualityType controlled vocabulary. | ODM2CV |
| CV_DatasetType | Table containing terms used in the DatasetType controlled vocabulary. | ODM2CV |
| CV_DirectiveType | Table containing terms used in the DirectiveType controlled vocabulary. | ODM2CV |
| CV_ElevationDatum | Table containing terms used in the ElevationDatum controlled vocabulary. | ODM2CV |
| CV_EquipmentType | Table containing terms used in the EquipmentType controlled vocabulary. | ODM2CV |
| CV_FeaturesOfInterestType | Table containing terms used in the FeatureOfInterestType controlled vocabulary. | ODM2CV |
| CV_LBNLICPMSMapper | Table which contains a mapping between LBNL Parameter names and official variable names | ODM2CV |
| CV_Medium | Table containing terms used in the Medium controlled vocabulary. | ODM2CV |
| CV_MethodType | Table containing terms used in the MethodType controlled vocabulary. | ODM2CV |
| CV_OrganizationType | Table containing terms used in the OrganizationType controlled vocabulary. | ODM2CV |
| CV_PropertyDataType | Table containing terms used in the PropertyDataType controlled vocabulary. | ODM2CV |
| CV_QualityCode | Table containing terms used in the QualityCode controlled vocabulary. | ODM2CV |
| CV_QuantityKind | Table containing terms used in the QuantityKind controlled vocabulary. | ODM2CV |
| CV_RelationshipType | Table containing terms used in the RelationshipType controlled vocabulary. | ODM2CV |
| CV_ResultType | Table containing terms used in the ResultType controlled vocabulary. | ODM2CV |
| CV_SamplingFeatureGeoType | Table containing terms used in the SamplingFeatureGeoType controlled vocabulary. | ODM2CV |
| CV_SamplingFeatureType | Table containing terms used in the SamplingFeatureType controlled vocabulary. | ODM2CV |
| CV_SpatialOffsetType | Table containing terms used in the SpatialOffsetType controlled vocabulary. | ODM2CV |
| CV_SpecimenCollection | Table containing terms used in the Specimen Collection controlled vocabulary. | ODM2CV |
| CV_SpecimenType | Table containing terms used in the SpecimenType controlled vocabulary. | ODM2CV |
| CV_Status | Table containing terms used in the Status controlled vocabulary. | ODM2CV |
| CV_TaxonomicClassifierDomain | Table containing terms used in the TaxonomicClassifierDomain controlled vocabulary. | ODM2CV |
| CV_Units | Table containing terms used in the VariableName controlled vocabulary. | ODM2CV |
| CV_VariableDomain | Table containing terms used in the VariableDomain controlled vocabulary. | ODM2CV |
| CV_VariableName | Table containing terms used in the VariableName controlled vocabulary. | ODM2CV |
| CV_VariableNamenew | Table containing terms used in the VariableName controlled vocabulary. | ODM2CV |
| CV_VariableType | Table containing terms used in the VariableType controlled vocabulary. | ODM2CV |
| CalibrationActions | Information about calibration Actions | ODM2Equipment |
| CalibrationReferenceEquipment | Information about equipment used as referenece for a calibration | ODM2Equipment |
| CalibrationStandards | Bridge table linking field calibrations to the reference materials used | ODM2Equipment |
| CategoricalResultValueAnnotations | Annotations for Categorical ResultValues | ODM2Annotations |
| CategoricalResultValues | | ODM2Results |
| CategoricalResults | | ODM2Results |
| CitationExtensionPropertyValues | Values for Citation Extension Properties | ODM2ExtensionProperties |
| CitationExternalIdentifiers | | ODM2ExternalIdentifiers |
| Citations | Information about Citations | ODM2Provenance |
| DataLoggerFiles | Destibes datalogger files created by a deployment action | ODM2Equipment |
| DataQuality | | ODM2DataQuality |
| DataloggerFileColumns | Information about columns in datalogger files | ODM2Equipment |
| DataloggerProgramFiles | Information about datalogger program files | ODM2Equipment |
| DatasetCitations | Relationship between DataSets and Citations | ODM2Provenance |
| Datasets | Describes groupings of observation results that can be considered "datasets" | ODM2Core |
| DatasetsResults | Lists the Results that are grouped into a DataSet | ODM2Core |
| DerivationEquations | DerivationEquations include calibration equations, normalizations, etc. on one or more RelatedResults to produce a DerivedResult. | ODM2Provenance |
| Directives | Describes the directive or purpose under which actions are made. Directives can be projects, intended analyses for a specimen, etc. | ODM2LabAnalyses |
| Equipment | Descriptions of specific pieces of equipment. | ODM2Equipment |
| EquipmentAnnotations | Bridge table linking Annotations to Equipment | ODM2Annotations |
| EquipmentModels | Describes models of sensors, loggers, and related equipment used in making observations. | ODM2Equipment |
| EquipmentUsed | | ODM2Equipment |
| ExtensionProperties | Describes extension properties added to objects in an ODM database | ODM2ExtensionProperties |
| ExternalIdentifierSystems | A single table for connecting various primary keys with points to outside systems. | ODM2ExternalIdentifiers |
| FeatureActions | | ODM2Core |
| FeaturesOfInterest | | ODM2SamplingFeatures |
| InstrumentOutputQuantityKind | Information about the QuantityKind that an instrument is capable of measuring | ODM2Equipment |
| MaintenanceActions | Information about maintenance Actions performed on Equipment | ODM2Equipment |
| MeasurementResultValueAnnotations | Annotations for Measurement ResultValues | ODM2Annotations |
| MeasurementResultValues | | ODM2Results |
| MeasurementResults | | ODM2Results |
| MethodAnnotations | Notes for or groups of one or more Methods. | ODM2Annotations |
| MethodCitations | | ODM2Provenance |
| MethodExtensionPropertyValues | Links extnsion properties to a Method | ODM2ExtensionProperties |
| MethodExternalIdentifiers | | ODM2ExternalIdentifiers |
| Methods | Describes methods used to perform actions recorded in ODM (e.g., observation methods, sample analysis methods, sample preparation methods, etc.) | ODM2Core |
| ModelAffiliations | | ODM2Simulation |
| Models | | ODM2Simulation |
| Organizations | Describes organizations - as in research groups, companies, universities, etc. | ODM2Core |
| People | Describes people. | ODM2Core |
| PersonExternalIdentifiers | Cross reference "linking" table to allow many to many | ODM2ExternalIdentifiers |
| PointCoverageResultValueAnnotations | Annotations for Point Coverage ResultValues | ODM2Annotations |
| PointCoverageResultValues | | ODM2Results |
| PointCoverageResults | | ODM2Results |
| ProcessingLevels | Describes the processing level of Results | ODM2Core |
| ProfileResultValueAnnotations | Annotations for Profile ResultValues | ODM2Annotations |
| ProfileResultValues | Numeric values of Depth Profile Results. | ODM2Results |
| ProfileResults | Information about Profile Results | ODM2Results |
| 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 |
| ReferenceMaterials | Describes materials that are used for the calibration of an instrument, the assessment of a measurement method, or for assigning values to unknown specimens. | ODM2DataQuality |
| RelatedActions | Describes Actions that are related to one another. | ODM2Core |
| RelatedAnnotations | Stores information about relationships among Annotations | ODM2Provenance |
| RelatedCitations | Information about relationships among citations | ODM2Provenance |
| RelatedDatasets | Information about relationships among DataSets | ODM2Provenance |
| RelatedEquipment | Information about relationships among Equipment | ODM2Equipment |
| RelatedFeatures | Describes parrent/child relationships among Sampling Features | ODM2SamplingFeatures |
| RelatedModels | | ODM2Simulation |
| RelatedResults | Information about relationships among Results | ODM2Provenance |
| ResultAnnotations | Notes for or groups of one or more Results [sets]. | ODM2Annotations |
| ResultDerivationEquations | Relationship between Results and Equations used to derive them | ODM2Provenance |
| ResultExtensionPropertyValues | Links extension properties to a Result | ODM2ExtensionProperties |
| ResultNormalizationValues | Extends 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 |
| Results | Describes the results of observation actions (e.g., groups of one or more numeric data values that result from an observation action) | ODM2Core |
| ResultsDataQuality | | ODM2DataQuality |
| SampledFeatures | | ODM2SamplingFeatures |
| SamplingFeatureAnnotations | Notes for or groups of one or more Sampling Features. | ODM2Annotations |
| SamplingFeatureExtensionPropertyValues | | ODM2ExtensionProperties |
| SamplingFeatureExternalIdentifiers | | ODM2ExternalIdentifiers |
| SamplingFeatures | Describes the sampling features on which observations are made. | ODM2Core |
| SectionResultValueAnnotations | Annotations for Section ResultValues | ODM2Annotations |
| SectionResultValues | | ODM2Results |
| SectionResults | | ODM2Results |
| Simulations | | ODM2Simulation |
| SpatialOffsets | An explicit spatial relationship between a sampling feature relative to it's parent. | ODM2SamplingFeatures |
| SpatialReferenceExternalIdentifiers | | ODM2ExternalIdentifiers |
| SpatialReferences | Describes spatial reference systems used to reference the coordinates for sites | ODM2SamplingFeatures |
| SpecimenBatchPositions | Extends 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 |
| SpecimenCollection | This has the specimen collection information | ODM2SamplingFeatures |
| SpecimenTaxonomicClassifiers | This cross-reference table allows Taxonomic Classification of Specimens as an annotation, rather than as a Result. | ODM2SamplingFeatures |
| Specimens | Equivalent to O&M Sampling Feature Type "Specimen". Describes physical samples or specimens. | ODM2SamplingFeatures |
| SpectraResultValueAnnotations | Annotations for Spectra ResultValues | ODM2Annotations |
| SpectraResultValues | | ODM2Results |
| SpectraResults | | ODM2Results |
| TaxonomicClassifierExternalIdentifiers | | ODM2ExternalIdentifiers |
| TaxonomicClassifiers | | ODM2Core |
| TimeSeriesResultValueAnnotations | Annotations for Time Series ResultValues | ODM2Annotations |
| TimeSeriesResultValues | | ODM2Results |
| TimeSeriesResults | | ODM2Results |
| TrajectoryResultValueAnnotations | Annotations for Trajectory ResultValues | ODM2Annotations |
| TrajectoryResultValues | | ODM2Results |
| TrajectoryResults | | ODM2Results |
| TransectResultValueAnnotations | Annotations for Transect ResultValues | ODM2Annotations |
| TransectResultValues | | ODM2Results |
| TransectResults | | ODM2Results |
| VariableExtensionPropertyValues | | ODM2ExtensionProperties |
| VariableExternalIdentifiers | | ODM2ExternalIdentifiers |
| Variables | Stores information about measured properties. | ODM2Core |