Annotations that belong to messages are stored in this extra table.
Column Name |
Con- |
Column Type |
Description |
MessageId |
P,I |
nvarchar(36) |
Message Id to which the annotation belongs. |
OrderNumber |
P,I |
int(4) |
Order number of the annotation. |
Id |
P,I |
nvarchar(36) |
Unique Id of an annotation. |
Text |
|
nText(16) |
Text attribute of an annotation. |
UserOfAnnotation |
|
nvarchar(1024) |
User who created the annotation. |
TimeCreated |
|
int(4) |
Time when the annotation was created. Format: in seconds since 00:00 GMT on 1 Jan 1970 |
TimeCreatedTimeStamp |
|
datetime(8) |
Can be used for queries
instead of TimeCreated.
Format: YYYY-MM-DD
HH:MM:SS.ttt
|
P :Primary Key
I :Index
N :NULL values possible
F :Foreign Key