Annotation
- Last UpdatedMar 10, 2025
- 1 minute read
Contains one row for each user annotation about a tag value. Users can make personal (or public) notes about a tag value. This information is stored with the tag value and timestamp to which the annotation applies. Each annotation in this view is linked to a database user.
|
Column |
Data Type |
Description |
|---|---|---|
|
(PK) AnnotationKey |
int NOT NULL |
The unique numerical identifier for the annotation. This value is automatically generated by the system when the annotation is added. |
|
(FK) UserKey |
int NOT NULL |
The unique numerical identifier for a database user as defined in the UserDetail table. UserKey is a foreign key from the UserDetail table. |
|
(FK) TagName |
TagNameType |
The unique name of the tag within the AVEVA Historian system. TagName is a foreign key from the Tag table. |
|
DateCreated |
datetime(2)7 NULL |
The date that the annotation was created. |
|
Content |
nvarchar(1000) NOT NULL |
The annotation text. |
|
DateTime |
datetime2(7) NOT NULL |
The timestamp of the tag value for which the user has made an annotation. |
|
Value |
float NULL |
The value of the tag at the time of the annotation. |