Data Access
Data access
Current values
Basic current values are sorted out by a value type in the following five tables.
1. AnalogPoints - real values and relative time values.
COLUMN NAME | VALUE TYPE | SIZE |
|---|---|---|
NAME | CHAR | 64 |
DESCRIPT | CHAR | 50 |
VALUE | DOUBLE | 8 |
STATUS | INTEGER | 4 |
WEAK | INTEGER | 4 |
DEFAULT | INTEGER | 4 |
LIMITS | INTEGER | 4 |
FLAGS | INTEGER | 4 |
2. IntegerPoints - integer values.
COLUMN NAME | VALUE TYPE | SIZE |
|---|---|---|
NAME | CHAR | 64 |
DESCRIPT | CHAR | 50 |
VALUE | INTEGER | 4 |
STATUS | INTEGER | 4 |
WEAK | INTEGER | 4 |
DEFAULT | INTEGER | 4 |
LIMITS | INTEGER | 4 |
FLAGS | INTEGER | 4 |
3. EnumPoints - enumerated types including Boolean type.
COLUMN NAME | VALUE TYPE | SIZE |
|---|---|---|
NAME | CHAR | 64 |
DESCRIPT | CHAR | 50 |
VALUE | INTEGER | 4 |
STATUS | INTEGER | 4 |
WEAK | INTEGER | 4 |
DEFAULT | INTEGER | 4 |
LIMITS | INTEGER | 4 |
FLAGS | INTEGER | 4 |
4. TimePoints - absolute time values.
COLUMN NAME | VALUE TYPE | SIZE |
|---|---|---|
NAME | CHAR | 64 |
DESCRIPT | CHAR | 50 |
VALUE | TIMESTAMP |
|
STATUS | INTEGER | 4 |
WEAK | INTEGER | 4 |
DEFAULT | INTEGER | 4 |
LIMITS | INTEGER | 4 |
FLAGS | INTEGER | 4 |
5. TextPoints
COLUMN NAME | VALUE TYPE | SIZE |
|---|---|---|
NAME | CHAR | 64 |
DESCRIPT | CHAR | 50 |
VALUE | CHAR | 254 |
STATUS | INTEGER | 4 |
WEAK | INTEGER | 4 |
DEFAULT | INTEGER | 4 |
LIMITS | INTEGER | 4 |
FLAGS | INTEGER | 4 |
Variables of the types Value array and Structured variable are in separated tables. The table name is derived from the name of the variable so that the dot character "." is substituted by the underscore character "_" in the name.
Each object of the Value array type creates a table of the following format:
COLUMN NAME | VALUE TYPE | SIZE |
|---|---|---|
TIME | TIMESTAMP |
|
VALUE | DOUBLE | 8 |
STATUS | INTEGER | 4 |
ROW_ID | INTEGER | 4 |
WEAK | INTEGER | 4 |
DEFAULT | INTEGER | 4 |
LIMITS | INTEGER | 4 |
FLAGS | INTEGER | 4 |
Each object of the Structured variable type creates a table of the format corresponding to a form of the structure variable. In addition, ROW_ID column, determining an order number - structured variable row, is added to this table.
Historical data
The variables of Historical value type create separated tables. The table name is derived from the name of the historical variable so that the dot character "." is substituted by the underscore character "_" in the name.
Each variable of the Historical value type creates a table in the following format:
COLUMN NAME | VALUE TYPE | SIZE |
|---|---|---|
TIME | TIMESTAMP |
|
VALUE | DOUBLE | 8 |
STATUS | INTEGER | 4 |
STEP | INTEGER | 4 |
WEAK | INTEGER | 4 |
DEFAULT | INTEGER | 4 |
LIMITS | INTEGER | 4 |
FLAGS | INTEGER | 4 |
ARCH_FLAGS | INTEGER | 4 |
There is implemented in the table ArchivValues which enables getting the values of several archive objects at the same time. By a selection from this table, it is possible to enter several names of archive objects within one command.
For example:
SELECT TIME,VALUE01,STATUS01,VALUE02,STATUS02 FROM ArchivValues WHERE TIME >{ts '2000-04-11 10:00:00'} and TIME <{ts '2000-04-11 12:00:00'} and NAME01="H.AAA1" and NAME02="H.AAA2" and STEP=60
The structure of the table ArchivValues:
COLUMN NAME | VALUE TYPE | SIZE |
|---|---|---|
TIME | TIMESTAMP |
|
STEP | INTEGER | 4 |
NAME01 | CHAR | 64 |
VALUE01 | DOUBLE | 8 |
STATUS01 | INTEGER | 4 |
WEAK01 | INTEGER | 4 |
DEFAULT01 | INTEGER | 4 |
LIMITS01 | INTEGER | 4 |
FLAGS01 | INTEGER | 4 |
ARCH_FLAGS01 | INTEGER | 4 |
NAME02 | CHAR | 64 |
VALUE02 | DOUBLE | 8 |
STATUS02 | INTEGER | 4 |
WEAK02 | INTEGER | 4 |
DEFAULT02 | INTEGER | 4 |
LIMITS02 | INTEGER | 4 |
FLAGS02 | INTEGER | 4 |
ARCH_FLAGS02 | INTEGER | 4 |
... |
|
|
NAMEn | CHAR | 64 |
VALUEn | DOUBLE | 8 |
STATUSn | INTEGER | 4 |
WEAKn | INTEGER | 4 |
DEFAULTn | INTEGER | 4 |
LIMITSn | INTEGER | 4 |
FLAGSn | INTEGER | 4 |
ARCH_FLAGSn | INTEGER |