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

ResultsDescribes the results of observation actions (e.g., groups of one or m...

PKNameData TypeNULLsA/NDefaultCommentFK

ResultIDBigInt

Primary key identifier.
ResultUUIDUniqueID A universally unique identifier for the Result
FeatureActionIDInteger Foreign key identifier for the combinaton of SamplingFeature and Action that created the Result

ResultTypeCVVarChar(255) CV term describing the result type (e.g., time series, measurement, etc.)

VariableIDInteger Foreign key identifier for the Variable of the result

UnitsIDInteger Foreign key identifier for the Units of the result

TaxonomicClassifierIDInteger

Foreign key identifier for a TaxonomicClassifier for the variable (if one exists)

ProcessingLevelIDInteger Foreign key identifier for the ProcessingLevel of the result

ResultDateTimeDateTime

Date and time at which the result became available (could be used as analysis time for samples)
ResultDateTimeUTCOffsetBigInt

UTDCOffset of ResultDateTime
ValidDateTimeDateTime

Date and time for which the result is valid (e.g., for a forecast result). Should probably be expressed as a duration
ValidDateTimeUTCOffsetBigInt

UTCOffset of ValidDateTime
StatusCVVarChar(255)

Status of the result (e.g., finished, ongoing, etc.)

SampledMediumCVVarChar(255) CV term defining the environmental medium that the result represents (e.g., air, soil, water)

ValueCountInteger Number of data values contained within the result


NameParent TableChild TableParent ColumnsChild Columns
fk_Results_CV_MediumODM2CV.CV_MediumODM2Core.ResultsNameSampledMediumCV
fk_Results_CV_ResultTypeODM2CV.CV_ResultTypeODM2Core.ResultsNameResultTypeCV
fk_Results_CV_StatusODM2CV.CV_StatusODM2Core.ResultsNameStatusCV
fk_Results_FeatureActionsODM2Core.FeatureActionsODM2Core.ResultsFeatureActionIDFeatureActionID
fk_Results_ProcessingLevelsODM2Core.ProcessingLevelsODM2Core.ResultsProcessingLevelIDProcessingLevelID
fk_Results_TaxonomicClassifiersODM2Core.TaxonomicClassifiersODM2Core.ResultsTaxonomicClassifierIDTaxonomicClassifierID
fk_Results_UnitsODM2Core.UnitsODM2Core.ResultsUnitsIDUnitsID
fk_Results_VariablesODM2Core.VariablesODM2Core.ResultsVariableIDVariableID

NameParent TableChild TableParent ColumnsChild Columns
fk_ResultAnnotations_ResultsODM2Core.ResultsODM2Annotations.ResultAnnotationsResultIDResultID
fk_DataSetsResults_ResultsODM2Core.ResultsODM2Core.DatasetsResultsResultIDResultID
fk_ResultNormalizationValues_ResultsODM2Core.ResultsODM2DataQuality.ResultNormalizationValuesResultIDResultID
fk_ResultsDataQuality_ResultsODM2Core.ResultsODM2DataQuality.ResultsDataQualityResultIDResultID
fk_DataloggerFileColumns_ResultsODM2Core.ResultsODM2Equipment.DataloggerFileColumnsResultIDResultID
fk_ResultExtensionPropertyValues_ResultsODM2Core.ResultsODM2ExtensionProperties.ResultExtensionPropertyValuesResultIDResultID
fk_RelatedResults_ResultsODM2Core.ResultsODM2Provenance.RelatedResultsResultIDResultID
fk_RelatedResults_Results_AreRelatedODM2Core.ResultsODM2Provenance.RelatedResultsResultIDRelatedResultID
fk_ResultDerivationEquations_ResultsODM2Core.ResultsODM2Provenance.ResultDerivationEquationsResultIDResultID
fk_CategoricalResults_ResultsODM2Core.ResultsODM2Results.CategoricalResultsResultIDResultID
fk_MeasurementResults_ResultsODM2Core.ResultsODM2Results.MeasurementResultsResultIDResultID
fk_PointCoverageResults_ResultsODM2Core.ResultsODM2Results.PointCoverageResultsResultIDResultID
fk_ProfileResults_ResultsODM2Core.ResultsODM2Results.ProfileResultsResultIDResultID
fk_SectionResults_ResultsODM2Core.ResultsODM2Results.SectionResultsResultIDResultID
fk_SpectraResults_ResultsODM2Core.ResultsODM2Results.SpectraResultsResultIDResultID
fk_TimeSeriesResults_ResultsODM2Core.ResultsODM2Results.TimeSeriesResultsResultIDResultID
fk_TrajectoryResults_ResultsODM2Core.ResultsODM2Results.TrajectoryResultsResultIDResultID
fk_TransectResults_ResultsODM2Core.ResultsODM2Results.TransectResultsResultIDResultID

Diagram Name
ODM2Annotations
ODM2Core
ODM2DataQuality
ODM2Equipment
ODM2ExtensionProperties
ODM2LabAnalyses
ODM2OverviewSimplified
ODM2Provenance
ODM2Results
ODM2Simulation