WaterSourceBridge_Sites_fact - Table

WaDE2.0 [WaDE2.01.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: WaterSourceBridge_Sites_fact

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	WaterSourceBridgeSiteID	BigInt
	SiteID	BigInt				Primary internal key unique identifier for site records.
	WaterSourceID	BigInt				Primary internal key unique identifier for water source records.

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_WaterSourceBridge_Sites_fact_Sites_dim	Core.Sites_dim	Core.WaterSourceBridge_Sites_fact	SiteID	SiteID
fk_WaterSourceBridge_Sites_fact_WaterSources_dim	Core.WaterSources_dim	Core.WaterSourceBridge_Sites_fact	WaterSourceID	WaterSourceID

Triggers

(none)

Used in Diagrams

1_WaterAllocations

2_SiteSpecificAmounts