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 |