AllocationBridge_BeneficialUses_fact - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: AllocationBridge_BeneficialUses_fact

Columns

PKNameData TypeNULLAutoDefaultCommentFK

AllocationBridgeIDBigInt

Primary internal key unique identifier for the bridge table between beneficial uses and allocation amount tables.
AllocationAmountIDBigInt Primary internal key unique identifier for allocation 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_AllocationBridge_BeneficialUses_fact_AllocationAmounts_factCore.AllocationAmounts_factCore.AllocationBridge_BeneficialUses_factAllocationAmountIDAllocationAmountID
fk_AllocationBridge_BeneficialUses_fact_BeneficialUseCategoryCVs.BeneficialUseCore.AllocationBridge_BeneficialUses_factNameBeneficialUseCategoryCV

Triggers

(none)


Used in Diagrams

Diagram Name
1_WaterAllocations