ext_rtc_scada_x_data - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table that stores volume of water billed for each period from each water source.
Fields:
| Column name | Data type | Description | Mandatory | Example |
|---|---|---|---|---|
| node_id | varchar(16) | Id of node, related to node invetory table and to ext_rtc_scada.node_id | TRUE | Value from node.node_id field |
| value_date | timestamp | Date of data collection | TRUE | 2015-05-01 00:00:00 |
| value | double | Value | TRUE | 300.98 |
| value_type | integer | Type of the collected data | FALSE | RELIABLE, APPROXIMATE, CALCULATED... |
| value_status | integer | Status of the collected data | FALSE | COMPLETE, PARTIAL, OBSOLETE |
| data_type | text | Type of data that may be introduced | FALSE |