CIRCUTOR SQL Data Export - Manual (Page 28)

SQL Data Export for PS/PSS
28
For the table name the device id will be used (corresponding to the
id field of the device table) and the variables type that the file
contains (corresponding to the type field of the variables table).
By using the device id field instead of the name, treatment will be
facilitated when a user changes the device name, as the id field is
unique and does not change once created.
• Fields. The fields of the table will depend on the type of variables that
they contain. For example, for an STD type, the fields will be:
o dateTime: Date and time of the record in CUT. Main key field of
the table
o dateTimeLocal: Date and time at local time of the PC where the
application is installed.
o idVariable1: Identifier of the first variable stored, corresponding to
the id field in the variables table
o …
o idVariableN: A field will be created for each of the STD type
variables that the device contains
<IP>:<PORT>_Devices
PK
id
name
class
description
download
obsolete
<IP>:<PORT>_<idDevice>.<type>
PK dateTime
dateTimeLocal
VI1
VI2
…
<IP>:<PORT>_Variables
PK, FK1 idDevice
PK id
description
type
units
format