WaterSources_dim - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: WaterSources_dim

WaterSources including the source type (groundwater or surface water) and its quality

Columns

PKNameData TypeNULLAutoDefaultCommentFK

WaterSourceIDBigInt

Primary internal key unique identifier for water source records.
WaterSourceUUIDNVarChar(250) Foreign key unique identifier to WaterSource_dim table.
GeometryGeometry

The GIS objects / shape written in Well-Known Text (WKT) format.
GNISFeatureNameCVNVarChar(250)

The water source name as recognized by the data provider.

WaterQualityIndicatorCVNVarChar(100) Description of the water quality (e.g., fresh, saline, mixed quality, etc.).

WaterSourceNameNVarChar(250)

The water source name as in the data provider record
WaterSourceNativeIDNVarChar(250)

The water source native ID used by the data provider.
WaterSourceTypeCVNVarChar(100) The high level description of the water source type (e.g., surface water, groundwater, mixed, reuse, etc.)


Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_WaterSources_dim_GNISFeatureNameCVs.GNISFeatureNameCore.WaterSources_dimNameGNISFeatureNameCV
fk_WaterSources_dim_WaterQualityIndicatorCVs.WaterQualityIndicatorCore.WaterSources_dimNameWaterQualityIndicatorCV
fk_WaterSources_dim_WaterSourceTypeCVs.WaterSourceTypeCore.WaterSources_dimNameWaterSourceTypeCV

Triggers

(none)


Used in Diagrams

Diagram Name
1_WaterAllocations
2_SiteSpecificAmounts
3_AggregatedAmounts