WaDE2.0 [WaDE2.01.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| SiteBridgeID | BigInt | Primary internal key unique identifier for the bridge table between sites variable amounts and beneficial use tables. | ||||
| SiteVariableAmountID | BigInt | Foreign key identifier for the site variable amount |
|
||||
| BeneficialUseCV | NVarChar(250) |
| The state recognized stated purpose for the water allocation (e.g., irrigation, power, etc) (if multiple, provide as a comma separated list). |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_SitesBridge_BeneficialUses_fact_BeneficialUseCategory | CVs.BeneficialUse | Core.SitesBridge_BeneficialUses_fact | Name | BeneficialUseCV |
| fk_SitesBridge_BeneficialUses_fact_SiteVariableAmounts_fact | Core.VariableAmounts_fact | Core.SitesBridge_BeneficialUses_fact | VariableAmountID | SiteVariableAmountID |
(none)
| Diagram Name |
| 2_SiteSpecificAmounts |