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

UnitsDescribes units of measure for varibles and time

PKNameData TypeNULLsA/NDefaultCommentFK

UnitsIDInteger

Primary key identifier
UnitsTypeCVVarChar(255) CV term that defines the unit type

UnitsAbbreviationVarChar(50) Text abbreviation for the unit
UnitsNameVarChar(255) Text name for the unit
UnitsLinkVarChar(255)

A link to the system from which the Unit was retreived or a URI for the definition of the Unit within that system.


NameParent TableChild TableParent ColumnsChild Columns
fk_Units_CV_UnitsTypeODM2CV.CV_UnitsTypeODM2Core.UnitsNameUnitsTypeCV

NameParent TableChild TableParent ColumnsChild Columns
fk_Results_UnitsODM2Core.UnitsODM2Core.ResultsUnitsIDUnitsID
fk_DataQuality_UnitsODM2Core.UnitsODM2DataQuality.DataQualityUnitsIDDataQualityValueUnitsID
fk_ReferenceMaterialValues_UnitsODM2Core.UnitsODM2DataQuality.ReferenceMaterialValuesUnitsIDUnitsID
fk_DataloggerFileColumns_RecordingUnitsODM2Core.UnitsODM2Equipment.DataloggerFileColumnsUnitsIDRecordingIntervalUnitsID
fk_DataloggerFileColumns_ScanUnitsODM2Core.UnitsODM2Equipment.DataloggerFileColumnsUnitsIDScanIntervalUnitsID
fk_InstrumentOutputVariables_UnitsODM2Core.UnitsODM2Equipment.InstrumentOutputVariablesUnitsIDInstrumentRawOutputUnitsID
fk_ExtensionProperties_UnitsODM2Core.UnitsODM2ExtensionProperties.ExtensionPropertiesUnitsIDPropertyUnitsID
fk_MeasurementResults_AIUnitsODM2Core.UnitsODM2Results.MeasurementResultsUnitsIDTimeAggregationIntervalUnitsID
fk_MeasurementResults_XUnitsODM2Core.UnitsODM2Results.MeasurementResultsUnitsIDXLocationUnitsID
fk_MeasurementResults_YUnitsODM2Core.UnitsODM2Results.MeasurementResultsUnitsIDYLocationUnitsID
fk_MeasurementResults_ZUnitsODM2Core.UnitsODM2Results.MeasurementResultsUnitsIDZLocationUnitsID
fk_PointCoverageResults_XUnitsODM2Core.UnitsODM2Results.PointCoverageResultsUnitsIDIntendedXSpacingUnitsID
fk_PointCoverageResults_YUnitsODM2Core.UnitsODM2Results.PointCoverageResultsUnitsIDIntendedYSpacingUnitsID
fk_PointCoverageResults_ZUnitsODM2Core.UnitsODM2Results.PointCoverageResultsUnitsIDZLocationUnitsID
fk_PointCoverageResultValues_XUnitsODM2Core.UnitsODM2Results.PointCoverageResultValuesUnitsIDXLocationUnitsID
fk_PointCoverageResultValues_YUnitsODM2Core.UnitsODM2Results.PointCoverageResultValuesUnitsIDYLocationUnitsID
fk_ProfileResults_DUnitsODM2Core.UnitsODM2Results.ProfileResultsUnitsIDIntendedZSpacingUnitsID
fk_ProfileResults_TUnitsODM2Core.UnitsODM2Results.ProfileResultsUnitsIDIntendedTimeSpacingUnitsID
fk_ProfileResults_XUnitsODM2Core.UnitsODM2Results.ProfileResultsUnitsIDXLocationUnitsID
fk_ProfileResults_YUnitsODM2Core.UnitsODM2Results.ProfileResultsUnitsIDYLocationUnitsID
fk_ProfileResultValues_AIUnitsODM2Core.UnitsODM2Results.ProfileResultValuesUnitsIDTimeAggregationIntervalUnitsID
fk_ProfileResultValues_DUnitsODM2Core.UnitsODM2Results.ProfileResultValuesUnitsIDZLocationUnitsID
fk_SectionResults_TMUnitsODM2Core.UnitsODM2Results.SectionResultsUnitsIDIntendedTimeSpacingUnitsID
fk_SectionResults_UnitsODM2Core.UnitsODM2Results.SectionResultsUnitsIDYLocationUnitsID
fk_SectionResults_XUnitsODM2Core.UnitsODM2Results.SectionResultsUnitsIDIntendedXSpacingUnitsID
fk_SectionResults_ZUnitsODM2Core.UnitsODM2Results.SectionResultsUnitsIDIntendedZSpacingUnitsID
fk_SectionResultValues_AIUnitsODM2Core.UnitsODM2Results.SectionResultValuesUnitsIDTimeAggregationIntervalUnitsID
fk_SectionResultValues_XUnitsODM2Core.UnitsODM2Results.SectionResultValuesUnitsIDXLocationUnitsID
fk_SectionResultValues_ZUnitsODM2Core.UnitsODM2Results.SectionResultValuesUnitsIDZLocationUnitsID
fk_SpectraResults_UnitsODM2Core.UnitsODM2Results.SpectraResultsUnitsIDIntendedWavelengthSpacingUnitsID
fk_SpectraResults_XUnitsODM2Core.UnitsODM2Results.SpectraResultsUnitsIDXLocationUnitsID
fk_SpectraResults_YUnitsODM2Core.UnitsODM2Results.SpectraResultsUnitsIDYLocationUnitsID
fk_SpectraResults_ZUnitsODM2Core.UnitsODM2Results.SpectraResultsUnitsIDZLocationUnitsID
fk_SpectraResultValues_AIUnitsODM2Core.UnitsODM2Results.SpectraResultValuesUnitsIDTimeAggregationIntervalUnitsID
fk_SpectraResultValues_WUnitsODM2Core.UnitsODM2Results.SpectraResultValuesUnitsIDWavelengthUnitsID
fk_TimeSeriesResults_TUnitsODM2Core.UnitsODM2Results.TimeSeriesResultsUnitsIDIntendedTimeSpacingUnitsID
fk_TimeSeriesResults_XUnitsODM2Core.UnitsODM2Results.TimeSeriesResultsUnitsIDXLocationUnitsID
fk_TimeSeriesResults_YUnitsODM2Core.UnitsODM2Results.TimeSeriesResultsUnitsIDYLocationUnitsID
fk_TimeSeriesResults_ZUnitsODM2Core.UnitsODM2Results.TimeSeriesResultsUnitsIDZLocationUnitsID
fk_TimeSeriesResultValues_AIUnitsODM2Core.UnitsODM2Results.TimeSeriesResultValuesUnitsIDTimeAggregationIntervalUnitsID
fk_TrajectoryResults_TSUnitsODM2Core.UnitsODM2Results.TrajectoryResultsUnitsIDIntendedTrajectorySpacingUnitsID
fk_TrajectoryResults_TUnitsODM2Core.UnitsODM2Results.TrajectoryResultsUnitsIDIntendedTimeSpacingUnitsID
fk_TrajectoryResultValues_AIUnitsODM2Core.UnitsODM2Results.TrajectoryResultValuesUnitsIDTimeAggregationIntervalUnitsID
fk_TrajectoryResultValues_DistanceUnitsODM2Core.UnitsODM2Results.TrajectoryResultValuesUnitsIDTrajectoryDistanceUnitsID
fk_TrajectoryResultValues_XUnitsODM2Core.UnitsODM2Results.TrajectoryResultValuesUnitsIDXLocationUnitsID
fk_TrajectoryResultValues_YUnitsODM2Core.UnitsODM2Results.TrajectoryResultValuesUnitsIDYLocationUnitsID
fk_TrajectoryResultValues_ZUnitsODM2Core.UnitsODM2Results.TrajectoryResultValuesUnitsIDZLocationUnitsID
fk_TransectResults_TMUnitsODM2Core.UnitsODM2Results.TransectResultsUnitsIDIntendedTimeSpacingUnitsID
fk_TransectResults_TSUnitsODM2Core.UnitsODM2Results.TransectResultsUnitsIDIntendedTransectSpacingUnitsID
fk_TransectResults_UnitsODM2Core.UnitsODM2Results.TransectResultsUnitsIDZLocationUnitsID
fk_TransectResultValues_AIUnitsODM2Core.UnitsODM2Results.TransectResultValuesUnitsIDTimeAggregationIntervalUnitsID
fk_TransectResultValues_DistanceUnitsODM2Core.UnitsODM2Results.TransectResultValuesUnitsIDTransectDistanceUnitsID
fk_TransectResultValues_XUnitsODM2Core.UnitsODM2Results.TransectResultValuesUnitsIDXLocationUnitsID
fk_TransectResultValues_YUnitsODM2Core.UnitsODM2Results.TransectResultValuesUnitsIDYLocationUnitsID
fk_SpatialOffsets_Offset1UnitsODM2Core.UnitsODM2SamplingFeatures.SpatialOffsetsUnitsIDOffset1UnitID
fk_SpatialOffsets_Offset2UnitsODM2Core.UnitsODM2SamplingFeatures.SpatialOffsetsUnitsIDOffset2UnitID
fk_SpatialOffsets_Offset3UnitsODM2Core.UnitsODM2SamplingFeatures.SpatialOffsetsUnitsIDOffset3UnitID

Diagram Name
ODM2Core
ODM2Simulation