Historical databases reference
- Last UpdatedApr 24, 2025
- 1 minute read
This module lays out the inner structure of Historical tables.
The following table provides information on Aveva-defined data types that are used in Historical tables.
|
Data Type |
Definition |
|---|---|
|
boolType |
bit |
|
bytetype |
tinyint |
|
doasnameType |
varchar(256) |
|
devnameType |
varchar(40) |
|
eventDescType |
nvarchar(128) |
|
eventNameType |
nvarchar(96) |
|
eventStringType |
nvarchar(max) |
|
GMToffset |
smallint |
|
GMTtime |
int |
|
labelType |
varchar(8) |
|
ON_descType |
nvarchar(80) |
|
ON_headlineType |
nvarchar(150) |
|
ON_noteTextType |
nvarchar(max) |
|
ON_referInfoType |
nvarchar(150) |
|
pathType |
varchar(80) |
|
realType |
real |
|
statusType |
varchar(1) |
|
sysnameType |
varchar(30) |
|
tagIDType |
int |
|
unitsType |
varchar(7) |
Note: The default character length of Microsoft SQL Server data types can be found in their documentation. Data types that have custom character lengths set for use in AVEVA Enterprise SCADA are indicated within the brackets.