WaDE2.0 [WaDE2.01.xml]
specific granular variables
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| MethodUUID | BigInt | Foreign key unique identifier to Methods_dim table. | ||||
| ApplicableResourceTypeCV | NVarChar(100) | A description of the types of water supply or water use for which the method is used (e.g. surface water, groundwater, storage, consumptive use, withdrawal). | |||||
| DataConfidenceValue | NVarChar(50) |
| An indicator of data confidence, should be a confidence interval (e.g. 90%, 50%, etc.). | ||||
| DataCoverageValue | NVarChar(100) |
| An indicator of data coverage (e.g., full, partial, etc.). | ||||
| DataQualityValueCV | NVarChar(50) |
| An indicator of the quality of data or grading (e.g. fair, good, best, unreported), or using the NEMS data quality grading system. | ||||
| MethodDescription | Text | A high level / general description of the data provided. | |||||
| MethodName | NVarChar(50) | The name of the method used by the data provider. | |||||
| MethodNEMILink | NVarChar(100) |
| A link back to the data provider's website or other webpage for more information about the method (e.g., https://www.nemi.gov/home/). | ||||
| MethodTypeCV | NVarChar(50) | Indicator of how the actual amount value within the data was determined (i.e. calculated, measured, estimated, reported, modeled, etc). |
(none)
(none)
(none)
| Diagram Name |
| 6_InputTables |