Format of the data table |
|
Archive Server -> Evacuating to SQL database -> Database structure -> Format of the data table |
   Show
all  Hide
all |
Format of the data table |
|
Archive Server -> Evacuating to SQL database -> Database structure -> Format of the data table |
| Show
all Hide
all |
|
Column |
Type |
Meaning |
|---|---|---|
|
VARIABLE |
int[4] |
numerical variable ID |
|
CALCULATION |
int[4] |
Type of data reduction in following
archives: |
|
TIMESTAMP_S |
int[4] |
Time stamp in UNIX time format |
|
TIMESTAMP_MS |
int[4] |
Milliseconds for the time stamp |
|
VALUE |
float[8] |
Value |
|
STATUS |
int[4] |
Status flag of the value (zenon Status) |
The name of the cross reference table is combined from the project name and the "Term" of the archive. The two parts are connected with an underscore character. So if the project name is "ARV_IN_DB" ant the archive term is "A1", the table name will be "ARV_IN_DB_A1".