Core - Schema
HomeTablesSchemasDiagramsForeign KeysIndexes

Schema: Core

Tables

Table NameComment
AggBridge_BeneficialUses_fact
AggregatedAmounts_fact
AllocationAmounts_fact
AllocationBridge_BeneficialUses_fact
Allocations_dimWater Allocations, also known as water rights or permits
Allocations_dim_InputWater Allocations, also known as water rights or permits
AllocationsBridge_Sites_fact
Date_dim
Methods_dimspecific granular variables
Organizations_dimOrganization responsible for the data reported.
PODSite_POUSite_fact
RegulatoryOverlay_dim
RegulatoryOverlayBridge_Sites_fact
RegulatoryReportingUnits_fact
ReportingUnits_dimThe area for which the Allocation or Estimate is being reported
Sites_dimSite specific
SitesAllocationAmountsBridge_fact
SitesBridge_BeneficialUses_fact
VariableAmounts_fact
Variables_dimspecific granular variables
WaterSourceBridge_Sites_fact
WaterSources_dimWaterSources including the source type (groundwater or surface water) and its quality

Procedures

NameComment
[Core].[LoadWaterAllocation]

Views

(none)

Sequences

(none)