# Versions, hashes and signatures

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

## osdocver

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

Document-version table.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `doc_id` | `int` | — |  |
| `doc_parent` | `int` | — |  |
| `doc_act` | `int` | — |  |
| `doc_ver` | `nvarchar` | 50 |  |
| `doc_root` | `int` | — |  |

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

## osdochash

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

Hashes of document files (for deduplication and integrity checks).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `object_id` | `int` | — |  |
| `object_type` | `int` | — |  |
| `osguid` | `nvarchar` | 32 |  |
| `oshash` | `nvarchar` | 128 |  |
| `ossignature` | `image` | 2147483647 |  |
| `last_check_time` | `int` | — |  |
| `last_check_state` | `int` | — |  |
| `oshashdia` | `nvarchar` | 128 |  |

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

## osdigsigs

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

Digital signatures — signature metadata per document.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `osid` | `nvarchar` | 32 |  |
| `ossignature` | `image` | 2147483647 |  |
| `ossigheader` | `image` | 2147483647 |  |
| `ossigtext` | `image` | 2147483647 |  |
| `osuserid` | `int` | — |  |
| `ostrust` | `nvarchar` | 100 |  |
| `ostimestamp` | `int` | — |  |
| `osstation` | `nvarchar` | 255 |  |
| `osname` | `nvarchar` | 100 |  |
| `osfirstname` | `nvarchar` | 100 |  |
| `osobjtype` | `int` | — |  |
| `osobjclass` | `nvarchar` | 32 |  |
| `osobjid` | `int` | — |  |

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

## ossigtext

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

Signature texts / signature descriptions.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ostextid` | `nvarchar` | 32 |  |
| `oslabel` | `nvarchar` | 100 |  |
| `ostext` | `image` | 2147483647 |  |
| `osdeleted` | `int` | — |  |

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

## osdias

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

Slide/preview master data of document previews.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `objekttyp` | `int` | — |  |
| `diatype` | `int` | — |  |
| `dia` | `image` | 2147483647 |  |