ext_rtc_scada - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table that stores scada components related with network nodes.
Fields:
| Column name | Data type | Description | Mandatory | Example |
|---|---|---|---|---|
| scada_id | varchar(30) | Id of SCADA | TRUE | Serial |
| source | varchar(30) | Name of the source where the scada data comes from. | FALSE | REMOTE CONTROL, ACCESS, ORACLE... |
| source_id | varchar(30) | Id of the device within the source. For example, in our REMOTE CONTROL this scada device could have id=40. Then this is the value to insert here. There is a UNIQUE constraint between source and source_id. Both fields can't be repeated. | FALSE | Usually an integer but alphabetic values are also allowed |
| node_id | varchar(30) | Node_id of the GIS node related to this device | TRUE | Value from node.node_id field |
| code | varchar(50) | Device code from another source if necessary. | FALSE | Usually an integer but alphabetic values are also allowed |
| type_id | varchar(50) | Relate with some scada type catalog | FALSE | |
| class_id | varchar(50) | Relate with some scada class catalog | FALSE | |
| category_id | varchar(50) | Relate with some scada category catalog | FALSE | |
| catalog_id | varchar(50) | Relate with some scada components catalog | FALSE | |
| descript | text | Accurated descrption of the scada device | FALSE |