RegulatoryOverlayBridge_Sites_fact - Table

WaDE2.0 [WaDE2.01.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: RegulatoryOverlayBridge_Sites_fact

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	RegulatoryOverlayBridgeID	BigInt				Primary internal key unique identifier for the bridge table between regulatory overlays and sites tables.
	SiteID	BigInt				Internal unique identifier integer
	RegulatoryOverlayID	BigInt				Internal unique identifier

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Site_RegulatoryOverlays_RegulatoryOverlay_dim	Core.RegulatoryOverlay_dim	Core.RegulatoryOverlayBridge_Sites_fact	RegulatoryOverlayID	RegulatoryOverlayID
fk_Site_RegulatoryOverlays_Sites_dim	Core.Sites_dim	Core.RegulatoryOverlayBridge_Sites_fact	SiteID	SiteID

Triggers

(none)

Used in Diagrams

1_WaterAllocations

4_RegulatoryInfo