AllocationsBridge_Sites_fact - Table

WaDE2.0 [WaDE2.01.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: AllocationsBridge_Sites_fact

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	SiteAllocationID	BigInt
	SiteID	BigInt				Internal unique identifier integer
	AllocationAmountID	BigInt				Internal unique identifier integer

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Sites_WaterAllocations_fact_AllocationAmounts_fact	Core.AllocationAmounts_fact	Core.AllocationsBridge_Sites_fact	AllocationAmountID	AllocationAmountID
fk_Sites_WaterAllocations_fact_Sites_dim	Core.Sites_dim	Core.AllocationsBridge_Sites_fact	SiteID	SiteID

Triggers

(none)

Used in Diagrams

1_WaterAllocations