WaDE2.0 [WaDE2.01.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| AggBridgeID | BigInt |
| Primary internal key unique identifier for the bridge table between beneficial use and aggregated amounts tables. | |||
| AggregatedAmountID | BigInt |
| Primary internal key unique identifier for aggregated amount records. |
|
|||
| BeneficialUseCategoryCV | NVarChar(250) |
| The data provider's recognized stated purpose for the water right (e.g., irrigation, power, etc) (if multiple, provide as a comma separated list). |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_AggBridge_BeneficialUses_fact_AggregatedAmounts_fact | Core.AggregatedAmounts_fact | Core.AggBridge_BeneficialUses_fact | AggregatedAmountID | AggregatedAmountID |
(none)
| Diagram Name |
| 3_AggregatedAmounts |