AggregationStatistic - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: AggregationStatistic

A term for describing the statistical action used to calculate over recorded time series values within a time interval. For example, 100 cfs of delivery target to a demand site is a "cumulative" aggregation statistic calculated over a time interval like a month.

Columns

PKNameData TypeNULLAutoDefaultCommentFK

NameNVarChar(50) Internal unique identifier string used for term name. Name / listing of the term as noted from the data provider from the source data.
TermNVarChar(250) Unique string of the term. Name / listing of the term as noted from the data provider from the source data.
DefinitionNVarChar(5000)

Definition of the term as noted from the data provider from the source data.
SourceVocabularyURI NVarChar(250)

Web link to source glossary / index of where the data provider provides the term and it's definition.
StateNVarChar(250)

Two digit state abbreviation where the term was provided from. If multiple, use comma separated list.
WaDENameNVarChar(150)

WaDE specific term used to group and categorize similar beneficial uses and facilitate data visualizations and queries across state boundaries.

Indexes

(none)


Foreign Keys

(none)


Triggers

(none)


Used in Diagrams

Diagram Name
5_ContreolledVocabulary