Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_AggBridge_BeneficialUses_fact_AggregatedAmounts_fact	Core.AggregatedAmounts_fact	Core.AggBridge_BeneficialUses_fact	AggregatedAmountID	AggregatedAmountID
fk_AggregatedAmounts_Date_dim_end	Core.Date_dim	Core.AggregatedAmounts_fact	DateID	TimeframeEndID
fk_AggregatedAmounts_Date_dim_end_pub	Core.Date_dim	Core.AggregatedAmounts_fact	DateID	DataPublicationDateID
fk_AggregatedAmounts_Date_dim_start	Core.Date_dim	Core.AggregatedAmounts_fact	DateID	TimeframeStartID
fk_AggregatedAmounts_fact_BeneficialUseCategory	CVs.BeneficialUse	Core.AggregatedAmounts_fact	Name	PrimaryUseCategoryCV
fk_AggregatedAmounts_fact_CropType	CVs.CropType	Core.AggregatedAmounts_fact	Name	CropTypeCV
fk_AggregatedAmounts_fact_CustomerTypeCV	CVs.CustomerTypeCV	Core.AggregatedAmounts_fact	Name	CustomerTypeCV
fk_AggregatedAmounts_fact_IrrigationMethod	CVs.IrrigationMethod	Core.AggregatedAmounts_fact	Name	IrrigationMethodCV
fk_AggregatedAmounts_fact_Methods_dim	Core.Methods_dim	Core.AggregatedAmounts_fact	MethodID	MethodID
fk_AggregatedAmounts_fact_Organizations_dim	Core.Organizations_dim	Core.AggregatedAmounts_fact	OrganizationID	OrganizationID
fk_AggregatedAmounts_fact_ReportingUnits_dim	Core.ReportingUnits_dim	Core.AggregatedAmounts_fact	ReportingUnitID	ReportingUnitID
fk_AggregatedAmounts_fact_ReportYearCV	CVs.ReportYearCV	Core.AggregatedAmounts_fact	Name	ReportYearCV
fk_AggregatedAmounts_fact_SDWISIdentifier	CVs.SDWISIdentifier	Core.AggregatedAmounts_fact	Name	SDWISIdentifierCV
fk_AggregatedAmounts_fact_Variables_dim	Core.Variables_dim	Core.AggregatedAmounts_fact	VariableSpecificID	VariableSpecificID
fk_AggregatedAmounts_fact_WaterSources_dim	Core.WaterSources_dim	Core.AggregatedAmounts_fact	WaterSourceID	WaterSourceID
fk_AllocationAmounts_fact_BeneficialUseCategory	CVs.BeneficialUse	Core.AllocationAmounts_fact	Name	PrimaryUseCategoryCV
fk_AllocationAmounts_fact_CustomerTypeCV	CVs.CustomerTypeCV	Core.AllocationAmounts_fact	Name	CustomerTypeCV
fk_AllocationAmounts_fact_Date_dim_appl	Core.Date_dim	Core.AllocationAmounts_fact	DateID	AllocationApplicationDateID
fk_AllocationAmounts_fact_Date_dim_expir	Core.Date_dim	Core.AllocationAmounts_fact	DateID	AllocationExpirationDateID
fk_AllocationAmounts_fact_Date_dim_priority	Core.Date_dim	Core.AllocationAmounts_fact	DateID	AllocationPriorityDateID
fk_AllocationAmounts_fact_Date_dim_pub	Core.Date_dim	Core.AllocationAmounts_fact	DateID	DataPublicationDateID
fk_AllocationAmounts_fact_LegalStatus	CVs.LegalStatus	Core.AllocationAmounts_fact	Name	AllocationLegalStatusCV
fk_AllocationAmounts_fact_Methods_dim	Core.Methods_dim	Core.AllocationAmounts_fact	MethodID	MethodID
fk_AllocationAmounts_fact_Organizations_dim	Core.Organizations_dim	Core.AllocationAmounts_fact	OrganizationID	OrganizationID
fk_AllocationAmounts_fact_SDWISIdentifier	CVs.SDWISIdentifier	Core.AllocationAmounts_fact	Name	SDWISIdentifierCV
fk_AllocationAmounts_fact_Variables_dim	Core.Variables_dim	Core.AllocationAmounts_fact	VariableSpecificID	VariableSpecificID
fk_AllocationAmounts_fact_WaterAllocationBasis	CVs.WaterAllocationBasis	Core.AllocationAmounts_fact	Name	AllocationBasisCV
fk_AllocationAmounts_fact_WaterRightType	CVs.WaterAllocationType	Core.AllocationAmounts_fact	Name	AllocationTypeCV
fk_AllocationBridge_BeneficialUses_fact_AllocationAmounts_fact	Core.AllocationAmounts_fact	Core.AllocationBridge_BeneficialUses_fact	AllocationAmountID	AllocationAmountID
fk_AllocationBridge_BeneficialUses_fact_BeneficialUseCategory	CVs.BeneficialUse	Core.AllocationBridge_BeneficialUses_fact	Name	BeneficialUseCategoryCV
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
fk_Methods_dim_ApplicableResourceTypeCV	CVs.ApplicableResourceType	Core.Methods_dim	Name	ApplicableResourceTypeCV
fk_Methods_dim_DataQualityValue	CVs.DataQualityValue	Core.Methods_dim	Name	DataQualityValueCV
fk_Methods_dim_MethodType	CVs.MethodType	Core.Methods_dim	Name	MethodTypeCV
fk_PODSite_POUSite_fact_Sites_dim_POD	Core.Sites_dim	Core.PODSite_POUSite_fact	SiteID	PODSiteID
fk_PODSite_POUSite_fact_Sites_dim_POU	Core.Sites_dim	Core.PODSite_POUSite_fact	SiteID	POUSiteID
fk_RegulatoryOverlay_dim_RegulatoryOverlayTypeCV	CVs.RegulatoryOverlayTypeCV	Core.RegulatoryOverlay_dim	Name	RegulatoryOverlayTypeCV
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
fk_RegulatoryReportingUnits_fact_Date_dim	Core.Date_dim	Core.RegulatoryReportingUnits_fact	DateID	DataPublicationDateID
fk_RegulatoryReportingUnits_fact_Organizations_dim	Core.Organizations_dim	Core.RegulatoryReportingUnits_fact	OrganizationID	OrganizationID
fk_RegulatoryReportingUnits_fact_RegulatoryOverlay_dim	Core.RegulatoryOverlay_dim	Core.RegulatoryReportingUnits_fact	RegulatoryOverlayID	RegulatoryOverlayID
fk_RegulatoryReportingUnits_fact_ReportingUnits_dim	Core.ReportingUnits_dim	Core.RegulatoryReportingUnits_fact	ReportingUnitID	ReportingUnitID
fk_ReportingUnits_dim_EPSGCode	CVs.EPSGCode	Core.ReportingUnits_dim	Name	EPSGCodeCV
fk_ReportingUnits_dim_ReportingUnitType	CVs.ReportingUnitType	Core.ReportingUnits_dim	Name	ReportingUnitTypeCV
fk_ReportingUnits_dim_State	CVs.States	Core.ReportingUnits_dim	Name	StateCV
fk_Sites_dim_CoordinateMethod	CVs.CoordinateMethod	Core.Sites_dim	Name	CoordinateMethodCV
fk_Sites_dim_EPSGCode	CVs.EPSGCode	Core.Sites_dim	Name	EPSGCodeCV
fk_Sites_dim_GNISFeatureName	CVs.GNISFeatureName	Core.Sites_dim	Name	GNISCodeCV
fk_Sites_dim_NHDNetworkStatus	CVs.NHDNetworkStatus	Core.Sites_dim	Name	NHDNetworkStatusCV
fk_Sites_dim_NHDProduct	CVs.NHDProduct	Core.Sites_dim	Name	NHDProductCV
fk_Sites_dim_SiteType	CVs.SiteType	Core.Sites_dim	Name	SiteTypeCV
fk_Sites_dim_States	CVs.States	Core.Sites_dim	Name	StateCV
fk_SitesAllocationAmountsBridge_fact_AllocationAmounts_fact	Core.AllocationAmounts_fact	Core.SitesAllocationAmountsBridge_fact	AllocationAmountID	AllocationAmountID
fk_SitesAllocationAmountsBridge_fact_Sites_dim	Core.Sites_dim	Core.SitesAllocationAmountsBridge_fact	SiteID	SiteID
fk_SitesBridge_BeneficialUses_fact_BeneficialUseCategory	CVs.BeneficialUse	Core.SitesBridge_BeneficialUses_fact	Name	BeneficialUseCV
fk_SitesBridge_BeneficialUses_fact_SiteVariableAmounts_fact	Core.VariableAmounts_fact	Core.SitesBridge_BeneficialUses_fact	VariableAmountID	SiteVariableAmountID
fk_SiteVariableAmounts_Date_dim_end	Core.Date_dim	Core.VariableAmounts_fact	DateID	TimeframeEndID
fk_SiteVariableAmounts_Date_dim_pub	Core.Date_dim	Core.VariableAmounts_fact	DateID	DataPublicationDateID
fk_SiteVariableAmounts_Date_dim_start	Core.Date_dim	Core.VariableAmounts_fact	DateID	TimeframeStartID
fk_SiteVariableAmounts_fact_BeneficialUseCategory	CVs.BeneficialUse	Core.VariableAmounts_fact	Name	PrimaryUseCategoryCV
fk_SiteVariableAmounts_fact_CropType	CVs.CropType	Core.VariableAmounts_fact	Name	CropTypeCV
fk_SiteVariableAmounts_fact_CustomerTypeCV	CVs.CustomerTypeCV	Core.VariableAmounts_fact	Name	CustomerTypeCV
fk_SiteVariableAmounts_fact_IrrigationMethod	CVs.IrrigationMethod	Core.VariableAmounts_fact	Name	IrrigationMethodCV
fk_SiteVariableAmounts_fact_Methods_dim	Core.Methods_dim	Core.VariableAmounts_fact	MethodID	MethodID
fk_SiteVariableAmounts_fact_Organizations_dim	Core.Organizations_dim	Core.VariableAmounts_fact	OrganizationID	OrganizationID
fk_SiteVariableAmounts_fact_ReportYearCV	CVs.ReportYearCV	Core.VariableAmounts_fact	Name	ReportYearCV
fk_SiteVariableAmounts_fact_SDWISIdentifier	CVs.SDWISIdentifier	Core.VariableAmounts_fact	Name	SDWISIdentifierCV
fk_SiteVariableAmounts_fact_Variables_dim	Core.Variables_dim	Core.VariableAmounts_fact	VariableSpecificID	VariableSpecificID
fk_VariableAmounts_fact_Sites_dim	Core.Sites_dim	Core.VariableAmounts_fact	SiteID	SiteID
fk_Variables_dim_AggregationStatistic	CVs.AggregationStatistic	Core.Variables_dim	Name	AggregationStatisticCV
fk_Variables_dim_ReportYearType	CVs.ReportYearType	Core.Variables_dim	Name	ReportYearTypeCV
fk_Variables_dim_Units	CVs.Units	Core.Variables_dim	Name	AmountUnitCV
fk_Variables_dim_Units_interval	CVs.Units	Core.Variables_dim	Name	AggregationIntervalUnitCV
fk_Variables_dim_Units_max	CVs.Units	Core.Variables_dim	Name	MaximumAmountUnitCV
fk_Variables_dim_Variable	CVs.Variable	Core.Variables_dim	Name	VariableCV
fk_Variables_dim_VariableSpecific	CVs.VariableSpecific	Core.Variables_dim	Name	VariableSpecificCV
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
fk_WaterSources_dim_GNISFeatureName	CVs.GNISFeatureName	Core.WaterSources_dim	Name	GNISFeatureNameCV
fk_WaterSources_dim_WaterQualityIndicator	CVs.WaterQualityIndicator	Core.WaterSources_dim	Name	WaterQualityIndicatorCV
fk_WaterSources_dim_WaterSourceType	CVs.WaterSourceType	Core.WaterSources_dim	Name	WaterSourceTypeCV
fk_BeneficialUse_AggBridge_BeneficialUses_fact	Core.AggBridge_BeneficialUses_fact	CVs.BeneficialUse	BeneficialUseCategoryCV	Name