| ODM2 [ODM2_DBWrench_Schema.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| Results | Describes the results of observation actions (e.g., groups of one or m... |
| Columns | |||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
|
| ResultID | BigInt |
| nextval('"ODM2Core"."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(255) | 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(255) |
| 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. | ||||
| Indexes (none) |
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Results_CV_ResultType | ODM2CV.CV_ResultType | ODM2Core.Results | Term | ResultTypeCV |
| fk_Results_CV_Status | ODM2CV.CV_Status | ODM2Core.Results | Term | StatusCV |
| fk_Results_FeatureActions | ODM2Core.FeatureActions | ODM2Core.Results | FeatureActionID | FeatureActionID |
| fk_Results_ProcessingLevels | ODM2Core.ProcessingLevels | ODM2Core.Results | ProcessingLevelID | ProcessingLevelID |
| fk_Results_Units | ODM2CV.CV_Units | ODM2Core.Results | UnitsID | UnitsID |
| fk_Results_Variables | ODM2Core.Variables | ODM2Core.Results | VariableID | VariableID |
| Triggers (none) |
| Used in Diagrams |
| Diagram Name |
| ODM2Annotations |
| ODM2Core |
| ODM2DataQuality |
| ODM2Equipment |
| ODM2ExtensionProperties |
| ODM2LabAnalyses |
| ODM2OverviewSimplified |
| ODM2Provenance |
| ODM2Results |
| ODM2Simulation |