AggBridge_BeneficialUses_fact - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: AggBridge_BeneficialUses_fact

Columns

PKNameData TypeNULLAutoDefaultCommentFK

AggBridgeIDBigInt

Primary internal key unique identifier for the bridge table between beneficial use and aggregated amounts tables.
AggregatedAmountIDBigInt

Primary internal key unique identifier for aggregated amount records.

BeneficialUseCategoryCVNVarChar(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).

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_AggBridge_BeneficialUses_fact_AggregatedAmounts_factCore.AggregatedAmounts_factCore.AggBridge_BeneficialUses_factAggregatedAmountIDAggregatedAmountID

Triggers

(none)


Used in Diagrams

Diagram Name
3_AggregatedAmounts