WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
This table stores data values of single numeric parameters like an elevation of 45.5 that could have a unit of meter
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| SeasonalNumericValueID | Integer |
| Primary key identifier | |||
| SeasonName | VarChar(255) | text value of the season names as used in the source | |||||
| SeasonDateFormate | DateTime |
| isoformat %Y/%m/%d where the year value is fixed to 1999. this is used in HydraPlatfom and Open Agua @ http://openagua.org or http://docs.openagua.org/ http://umwrg.github.io/HydraPlatform/devdocs/techdocs/timeseries.html?highlight=seasonal | ||||
| SeasonOrder | Integer | incremental integer to preserve the order of seasons within the same attribute | |||||
| SeasonNameCV | VarChar(255) |
| CV term to a universal season name |
|
|||
| SeasonNumericValue | Float | a numeric value for the season like 100 that corresponds to the Summer season | |||||
| ValuesMapperID | Integer | Foreign key identifier for a DataValueMapper record |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_SeasonalNumericValues_CV_SeasonName | CVs.CV_SeasonName | DataValues.SeasonalNumericValues | Name | SeasonNameCV |
| fk_SeasonalNumericValues_ValuesMapper | DataValues.ValuesMapper | DataValues.SeasonalNumericValues | ValuesMapperID | ValuesMapperID |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |