WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
This table stores metadata that are fixed for all the block of data values of a time series.
PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
| TimeSeriesID | Integer |
| Primary key identifier | |||
YearType | VarChar(50) | The term U.S.Geological Survey "water year" in reports that deal with surface-water supply is defined as the 12-month period October 1, for any given year through September 30, of the following year. The water year is designated by the calendar year in which it ends and which includes 9 of the 12 months. Thus, the year ending September 30, 1999 is called the "1999" water year. | |||||
AggregationStatisticCV | VarChar(255) | CV term to an aggregation statistic (e.g., average, min, max) |
|
||||
AggregationInterval | Double | The interval referes to time support which is the time interval when statistical aggregation applies to a set of measurement and then the aggregated value is reported (e.g., hourly measurement values are averaged over a day to report daily values) | |||||
IntervalTimeUnitCV | VarChar(255) | CV term to a unit name |
|
||||
BeginDateTime | DateTime |
| A derived date (queried) referes to the begining of time series data (e.g., 1960). It helps to identify the time extent of a block of time sereis data | ||||
EndDateTime | DateTime |
| A derived date (queried) referes to the end of time series data (e.g., 2000). It helps to identify the time extent of a block of time sereis data | ||||
IsRegular | Boolean |
| Boolean field of either 1 that indicates the time sereis is regular or 0 that indicates the time series is irregular | ||||
NoDataValue | VarChar(50) |
| a code that indicates there is no data value, e.g., 9999 | ||||
Description | Text |
| a text description of the block of time series data | ||||
ValuesMapperID | Integer | Foreign key identifier for a DataValueMapper record |
|
(none)
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_TimeSeries_CV_AggregationStatistic | CVs.CV_AggregationStatistic | DataValues.TimeSeries | Name | AggregationStatisticCV |
fk_TimeSeries_CV_Units | CVs.CV_Units | DataValues.TimeSeries | Name | IntervalTimeUnitCV |
fk_TimeSeries_ValuesMapper | DataValues.ValuesMapper | DataValues.TimeSeries | ValuesMapperID | ValuesMapperID |
(none)
Diagram Name |
01_WaMDaM |
02_WaMDaM_WCVs |