| 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 |
| Primary key identifier. | |||
| ResultUUID | UniqueID | 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 |
|
||||
| TaxonomicClassifierID | Integer |
| Foreign key identifier for a TaxonomicClassifier for the variable (if one exists) |
|
|||
| 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.) |
|
|||
| SampledMediumCV | VarChar(255) | CV term defining the environmental medium that the result represents (e.g., air, soil, water) |
|
||||
| ValueCount | Integer | Number of data values contained within the result | |||||
| Indexes (none) |
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Results_CV_Medium | ODM2CV.CV_Medium | ODM2Core.Results | Name | SampledMediumCV |
| fk_Results_CV_ResultType | ODM2CV.CV_ResultType | ODM2Core.Results | Name | ResultTypeCV |
| fk_Results_CV_Status | ODM2CV.CV_Status | ODM2Core.Results | Name | StatusCV |
| fk_Results_FeatureActions | ODM2Core.FeatureActions | ODM2Core.Results | FeatureActionID | FeatureActionID |
| fk_Results_ProcessingLevels | ODM2Core.ProcessingLevels | ODM2Core.Results | ProcessingLevelID | ProcessingLevelID |
| fk_Results_TaxonomicClassifiers | ODM2Core.TaxonomicClassifiers | ODM2Core.Results | TaxonomicClassifierID | TaxonomicClassifierID |
| fk_Results_Units | ODM2Core.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 |