WaDE2.0 [WaDE2.01.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| AllocationBridgeID | BigInt |
| Primary internal key unique identifier for the bridge table between beneficial uses and allocation amount tables. | |||
| AllocationAmountID | BigInt | Primary internal key unique identifier for allocation 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_AllocationBridge_BeneficialUses_fact_AllocationAmounts_fact | Core.AllocationAmounts_fact | Core.AllocationBridge_BeneficialUses_fact | AllocationAmountID | AllocationAmountID |
| fk_AllocationBridge_BeneficialUses_fact_BeneficialUseCategory | CVs.BeneficialUse | Core.AllocationBridge_BeneficialUses_fact | Name | BeneficialUseCategoryCV |
(none)
| Diagram Name |
| 1_WaterAllocations |