CIRCUTOR SQL Data Export - Manual (Page 27)

SQL Data Export for PS/PSS
27
3.2.- Structure of the database
The database is basically comprised of three types of tables:
• Devices table. A single table where we will store the information
on the devices
• Variables table. Single table where we will store the information
on the different variables contained in the devices
• Values table. There is a values table for each of the devices from
which data are downloaded. In addition, a device may have more
than one values table, precisely, it will have a values table for
each variable type (STD, WATT, SUC, CLW,…) the device has.
Devices table:
• Table name: <IP>:<PORT>_Devices (e.g. 127.0.0.1:80_Devices)
• Fields:
o id: Single device identifier. Main key field of the table
o name: Name of the device.
o description: Brief description of the device.
o class: Device type.
o download: Y/N type filed to indicate whether this device must
be downloaded or not. By using this field it will be possible for
the client to temporarily disable the downloading of values from
a device, without losing the data that has already been
downloaded.
o obsolete: Y/N type field, will only be Y (true) when the device
is removed from the PSS engine, thus the data already
downloaded will be retained for future use
Variables table:
• Table name: <IP>:<PORT>_Variables (e.g.
127.0.0.1:80_Variables)
• Fields:
o idDevice: Identifier of the device to which the variable belongs,
will correspond to the id field of the devices table. Main key
field of the table
o id: Identifier of the variable, for example VI1. Main key field of
the table
o description: Brief description of the variable.
o type: Variable type. Using this field one can differentiate which
variables go in each of the different devices values tables.
o units: Units in which the value of the variables are expressed.
o format: Format of the variable (integer, double, date, …).
Values table:
There is a values table for each of the variable types that a device
contains.
• Table name: <IP>:<PORT>_<idDevice>.<type> (e.g. 127.0.0.1:80_
F91FBB31-8587-4253-AC9E-93D354112B57.STD)