ODMX [ODMX_DBWrench_Schema.xml]
Describes the results of observation actions (e.g., groups of one or more numeric data values that result from an observation action)
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ResultID | BigInt |
| nextval('"ODMXCore"."Results_ResultID_seq"'::regclass) | Primary key identifier. | ||
| ResultUUID | VarChar(36) | A universally unique identifier for the Result | |||||
| FeatureActionID | Integer | Foreign key identifier for the combinaton of SamplingFeature and Action that created the Result |
|
||||
| ResultTypeCV | VarChar() | CV term describing the result type (e.g., time series, measurement, etc.) |
|
||||
| VariableID | Integer | Foreign key identifier for the Variable of the result |
|
||||
| UnitsID | Integer | Foreign key identifier for the Units of the result |
|
||||
| ProcessingLevelID | Integer | Foreign key identifier for the ProcessingLevel of the result |
|
||||
| ResultDateTime | DateTime |
| Date and time at which the result became available (could be used as analysis time for samples) | ||||
| ResultDateTimeUTCOffset | BigInt |
| UTDCOffset of ResultDateTime | ||||
| ValidDateTime | DateTime |
| Date and time for which the result is valid (e.g., for a forecast result). Should probably be expressed as a duration | ||||
| ValidDateTimeUTCOffset | BigInt |
| UTCOffset of ValidDateTime | ||||
| StatusCV | VarChar() |
| Status of the result (e.g., finished, ongoing, etc.) |
|
|||
| ValueCount | Integer | Number of data values contained within the result. For instance we could have a timeseries data with 1000s of results or a chemical analysis with a sd | |||||
| NoDataValue | Double |
| A numeric value indicating no data. |
| Name | Table | Columns | Unique | Clustered |
| Results_ResultUUID_Idx | ODMXCore.Results | ResultUUID |
|
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Results_CV_ResultType | ODMXCV.CV_ResultType | ODMXCore.Results | Term | ResultTypeCV |
| fk_Results_CV_Status | ODMXCV.CV_Status | ODMXCore.Results | Term | StatusCV |
| fk_Results_FeatureActions | ODMXCore.FeatureActions | ODMXCore.Results | FeatureActionID | FeatureActionID |
| fk_Results_ProcessingLevels | ODMXCore.ProcessingLevels | ODMXCore.Results | ProcessingLevelID | ProcessingLevelID |
| fk_Results_Units | ODMXCV.CV_Units | ODMXCore.Results | UnitsID | UnitsID |
| fk_Results_Variables | ODMXCore.Variables | ODMXCore.Results | VariableID | VariableID |
(none)
| Diagram Name |
| ODMXAnnotations |
| ODMXCore |
| ODMXDataQuality |
| ODMXEquipment |
| ODMXExtensionProperties |
| ODMXLabAnalyses |
| ODMXOverviewSimplified |
| ODMXProvenance |
| ODMXResults |
| ODMXSimulation |