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 |
Used in Diagrams |
Diagram Name |
ODM2Annotations |
ODM2Core |
ODM2DataQuality |
ODM2Equipment |
ODM2ExtensionProperties |
ODM2LabAnalyses |
ODM2OverviewSimplified |
ODM2Provenance |
ODM2Results |
ODM2Simulation |