# Audit and history

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

## osaccess

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

Logical access audit trail (who opened what and when).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `accessid` | `int` | — |  |
| `objtype` | `int` | — |  |
| `clausetype` | `int` | — |  |
| `clause` | `image` | 2147483647 |  |

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

## osadminhist

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

Administration history — logs admin actions.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `osid` | `int` | — |  |
| `timestamp` | `int` | — |  |
| `osuser` | `nvarchar` | 255 |  |
| `application` | `nvarchar` | 255 |  |
| `messageid` | `int` | — |  |
| `param0` | `nvarchar` | 255 |  |
| `param1` | `nvarchar` | 255 |  |
| `param2` | `nvarchar` | 255 |  |
| `param3` | `nvarchar` | 255 |  |
| `param4` | `nvarchar` | 255 |  |
| `param5` | `nvarchar` | 255 |  |
| `param6` | `nvarchar` | 255 |  |
| `param7` | `nvarchar` | 255 |  |
| `param8` | `nvarchar` | 255 |  |
| `param9` | `nvarchar` | 255 |  |

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

## oshistact

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

Action history on DMS objects.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `osaction` | `int` | — |  |
| `osinfo` | `nvarchar` | 50 |  |
| `osextinfo` | `nvarchar` | 248 |  |
| `langid` | `int` | — |  |

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

## osobjaccess

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

Object access audit.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ossd` | `nvarchar` | 32 |  |
| `osuid` | `nvarchar` | 32 |  |
| `isgroup` | `int` | — |  |
| `modifyindex` | `int` | — |  |
| `modifyobject` | `int` | — |  |
| `exportobject` | `int` | — |  |
| `deleteobject` | `int` | — |  |
| `modsecurity` | `int` | — |  |

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

## osobjhist

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

Object history (system events per DMS object).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `osguid` | `nvarchar` | 32 |  |
| `osid` | `int` | — |  |
| `ostype` | `int` | — |  |
| `osuser` | `int` | — |  |
| `ostime` | `int` | — |  |
| `osaction` | `int` | — |  |
| `osstation` | `nvarchar` | 100 |  |
| `osinfo` | `nvarchar` | 248 |  |

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

## osuseraccess

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

Detail user access matrix.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `userid` | `int` | — |  |
| `accessid` | `int` | — |  |

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

## osverhist

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

Version history at DMS object level (analogous to `objectXs`, but for version metadata).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `osverid` | `nvarchar` | 32 |  |
| `installed` | `datetime` | — |  |
| `version` | `nvarchar` | 32 |  |
| `majorversion` | `int` | — |  |
| `minorversion` | `int` | — |  |
| `setupversion` | `int` | — |  |

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

## protokoll

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

Protocol table (audit log).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `zeitstempel` | `int` | — |  |
| `benutzer_id` | `int` | — |  |
| `ordnertyp` | `int` | — |  |
| `objekttyp` | `int` | — |  |
| `ordner_id` | `int` | — |  |
| `register_id` | `int` | — |  |
| `objekt_id` | `int` | — |  |
| `flag` | `smallint` | — |  |
| `bearbeiter_id` | `int` | — |  |
| `art_exp_zeit` | `int` | — |  |
| `arbeitsplatz` | `nvarchar` | 20 |  |