The notations table contains infromation about
all of the annotations stored for the system's users. This includes items such
as highlights, bookmarks, text notes and discussions. Some
other information, including the last set of tabs opened by each user and the
position and size of the browser window, are also stored here.
This table describes the columns in the annotations table.
Columns in the notations table
| Column Name |
Data type |
Description |
| id |
int |
A unique identifier for the annotation. See note on generation of these
ids below |
| url |
varchar(256) |
The URL of the content this annotation refers to |
| addressStart |
varchar(256) |
The starting address annotation's text anchor. See note on addresses below |
| addressEnd |
varchar(256) |
The ending address of the annotation's text anchor. |
| type |
varchar(32) |
The type of the annotation, such as text note, bookmark, etc. |
| author |
varchar(64) |
Who created the annotation? This should really contain the user id rather
than name |
| target |
varchar(32) |
A singleton field describing the target of the annotation, whose purpose
has been subsumed by the NotationModes table |
| viewableBy |
varchar(64) |
A singleton field describing who can view the annotation, whose purpose
has been subsumed by the NotationModes table |
| subject |
varchar(64) |
A user-generated subject for the annotation, generally used as a human-readable
identifier. Some exceptions to this exist. |
| discussionID |
int |
If this annotation is part of a discussion, a reference to the discussion
ID which correlates postings to a discussion together. If the annotation
is not part of a discussion, this field is null. |
| regarding |
int |
Another annotation in this table that this annotation refers to. Used
only by the discussion mechanism currently. |
| created |
datetime |
The date and time on which this annotation was created. Generally system
supplied. |
| modified |
datetime |
The date and time on which this annotation was last modified. Generally
system supplied. |
| body |
text |
The content of the annotation; usually user entered text, although exceptions
exist |
| rowguid |
uniqueidentifier |
A unique system generated identifier used for synchronization purposes |
| Diagram |
image |
If the annotation is a diagram (or an ink annotation), this field contains
the data associated with the diagram. |
| viewmode |
varchar(32) |
Specifies how the annotation should be displayed. |
| isReference |
varchar(8) |
If set to true, then the body of the annotation actually
contains a URL; the content stored at this URL is then the content of the
annotation. |