ReportingUnits_dim - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: ReportingUnits_dim

The area for which the Allocation or Estimate is being reported

Columns

PKNameData TypeNULLAutoDefaultCommentFK

ReportingUnitIDBigInt

Primary internal key unique identifier for reporting units records.
ReportingUnitUUIDNVarChar(250) Foreign key unique identifier to ReportingUnits_dim table.
EPSGCodeCVNVarChar(50) EPSG Code for projection used for WaDE (e.g., EPSG:4326).

GeometryGeometry

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

Recognized name of the data reporting area by the data provider.
ReportingUnitNativeIDNVarChar(250) Unique identifier code / ID used by the data provider to distinguish the reporting area in the source data set.
ReportingUnitProductVersionNVarChar(100)

The product version of the reporting area (e.g., ver 1, 2, etc). Similar to ReportingUnitTypeCV.
ReportingUnitTypeCVNVarChar(50) The high level description of the reporting area type recognized by the data provider (e.g., HUC, County, Basin, etc.).

ReportingUnitUpdateDateDate

Date that the ReportingUnitProductVersion was released.
StateCVBigInt Two digit state abbreviation where the data site is.


Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_ReportingUnits_dim_EPSGCodeCVs.EPSGCodeCore.ReportingUnits_dimNameEPSGCodeCV
fk_ReportingUnits_dim_ReportingUnitTypeCVs.ReportingUnitTypeCore.ReportingUnits_dimNameReportingUnitTypeCV
fk_ReportingUnits_dim_StateCVs.StatesCore.ReportingUnits_dimNameStateCV

Triggers

(none)


Used in Diagrams

Diagram Name
3_AggregatedAmounts
4_RegulatoryInfo