# Annotations and collaboration

<a id="database.osannotations"></a>

## osannotations

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Database master data of annotations (companion to `annotations`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `annotationid` | `nvarchar` | 32 |  |
| `objectid` | `int` | — |  |
| `objecttype` | `int` | — |  |
| `annotationtype` | `int` | — |  |
| `page` | `int` | — |  |
| `pagexstart` | `real` | — |  |
| `pageystart` | `real` | — |  |
| `pagexend` | `real` | — |  |
| `pageyend` | `real` | — |  |
| `backgroundcolor` | `int` | — |  |
| `creatorid` | `int` | — |  |
| `creator` | `nvarchar` | 255 |  |
| `creationtime` | `int` | — |  |
| `modifierid` | `int` | — |  |
| `modifier` | `nvarchar` | 255 |  |
| `modificationtime` | `int` | — |  |
| `annotationtext` | `nvarchar` | max |  |
| `annotationblob` | `image` | 2147483647 |  |

<a id="database.osdoccollaboration"></a>

## osdoccollaboration

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Collaboration document metadata (link to Microsoft 365 / third-party systems).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `doc_id` | `int` | — |  |
| `doc_type` | `int` | — |  |
| `from_user` | `int` | — |  |
| `to_user` | `int` | — |  |
| `valid_from` | `datetime` | — |  |
| `valid_to` | `datetime` | — |  |
| `rights` | `nvarchar` | 10 |  |
| `remark` | `nvarchar` | max |  |