PODSite_POUSite_fact - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: PODSite_POUSite_fact

Columns

PKNameData TypeNULLAutoDefaultCommentFK

PODSitePOUSiteFactIDInteger
PODSiteIDBigInt

Primary internal key unique identifier for POD site records from the site table.

POUSiteIDBigInt

Primary internal key unique identifier for POU site records from the site table.

StartDateDate Start date when the water right can legally access the assigned water. Format of MM/DD.
EndDateDate End date when the water right no longer can legally access the assigned water. Format of MM/DD.

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_PODSite_POUSite_fact_Sites_dim_PODCore.Sites_dimCore.PODSite_POUSite_factSiteIDPODSiteID
fk_PODSite_POUSite_fact_Sites_dim_POUCore.Sites_dimCore.PODSite_POUSite_factSiteIDPOUSiteID

Triggers

(none)


Used in Diagrams

Diagram Name
2_SiteSpecificAmounts