Appendix A. Relational Database Tables (names may be case sensitive for non-Windows installations)
| Table Name |
Table Contents |
| Alarmactions |
Up to 31 alarm actions can be specified. This table contains the executable program for each action. For example, warning_email.exe, warning_control.exe, etc.. |
| Alarms |
Information on active and historical alarms. The type of alarm (e.g., water level above flood stage), the date / time of the alarm, etc. |
| Alarmsettings |
The actual alarm settings for each sensor (e.g., max value, min value). |
| Availableactions |
All executables that can be invoked when an alarm occurs. |
| Categories |
The categories of sensor types that can be displayed on a map (e.g., Rainfall, Water Level, Road Surface Conditions) |
| Cat_members |
Contains the sensor types in each map category. |
| Currentdata |
For each defined sensor, a timestamp of the most recent data, the most recent data in engineering units and, if data is received in raw form (e.g., Legacy ALERT and others), the corresponding raw data value. |
| DataBankCalib |
Timeseries data (time stamp, data value) for all defined sensors in engineering units |
| DataBankRaw |
Timeseries data for all defined sensors in raw form if the data for a sensor is acquired in raw form. |
| EmailInfo |
Email / cell phone numbers to deliver alarms to. |
| GoesID |
Meta-data about GOES DCP's to receive and decode. |
| ReportGroups |
Sensor groupings for statistical analysis displays. |
| Sensors |
Meta-data for each sensor being stored in the database. |
| SensorTypes |
Meta-data for each type of sensor that can be defined. |
| ShefGroups |
SHEF (Standard Hydrologic Data Exchange Format) product generation specifications. |
| ShefSensors |
Sensors and sensor Meta-data to be sent in SHEF-encoded format. |
| SignificantInfo |
Sensor benchmarks and associated colors to display on maps and charts and text when sensor readings are in this range. |
| SMTPInfo |
SSMTP server information for sending email / text alarms. |
| Stations |
Station ID's, types, names, and time of last communications with the station. |
| StationType1 |
Legacy ALERT Stations. |
| StationType2 |
ALERT2 Stations. |
| StationType3 |
Low Water Crossing Stations. |
| StationType4 |
GOES Handar ASCII. |
| StationType5 |
GOES Sutron ASCII. |
| StationType6 |
GOES Synergetics ASCII. |
| StationType7 |
GOES Generic ASCII. |
| StationType8 |
GOES Generic Pseudo-binary. |
| StationType9 |
Sutron 8200 Satlink. |
| StationType10 |
VX1004_8004_Binary. |
| StationType11 |
WMO Synop GOES. |
| StationType12 |
Sutron 8200 SHEF |
| StationType13 |
GOES ASCII Positional |
| StationType14 |
GOES Unevenly Spaced Binary |
| StationType15 |
GOES CREX Format |
| StationType16 |
GOES DECODES Decoding |
| StationType17 |
IceSight2020E Stations |
| StationType18 |
NTCIP Stations |
| StationType19 |
HSE_3306 Stations |
| StationType20 |
Handar555RT Stations |
| StationType25 |
Modbus Stations |
| StatusTypes |
Status bit definitions for each sensor defined as a status sensor. |
| users |
Username, password (encripted), and permission levels. |