# Workflows

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

## oswfworkflows

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

Workflow models (definition) — reference `oswfpackages`, carry version and lock information.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `workflowid` | `nvarchar` | 32 |  |
| `state` | `int` | — |  |
| `creatorid` | `nvarchar` | 32 |  |
| `creationtime` | `int` | — |  |
| `packageid` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `description` | `nvarchar` | 255 |  |
| `version` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |
| `family_id` | `nvarchar` | 32 |  |
| `lock_id` | `nvarchar` | 32 |  |
| `locktime` | `int` | — |  |
| `iconid` | `int` | — |  |

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

## oswfpackages

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

Workflow packages — versioned container for workflow models (model BLOB).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `packageid` | `nvarchar` | 32 |  |
| `packagedata` | `image` | — |  |
| `creatorid` | `nvarchar` | 32 |  |
| `creationtime` | `int` | — |  |
| `state` | `int` | — |  |
| `name` | `nvarchar` | 255 |  |
| `description` | `nvarchar` | 255 |  |
| `org_id` | `nvarchar` | 32 |  |

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

## oswfprojects

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

Workflow projects — group workflow models thematically or organisationally.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `nvarchar` | 32 |  |
| `org_id` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `description` | `nvarchar` | 255 |  |
| `ostype` | `int` | — |  |
| `creatorid` | `nvarchar` | 32 |  |
| `creationtime` | `int` | — |  |
| `proccount` | `int` | — |  |
| `versioncount` | `int` | — |  |
| `priority` | `int` | — |  |

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

## oswfprojectsrel

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

Parent/child relations between workflow projects (hierarchy).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `parent_id` | `nvarchar` | 32 |  |
| `project_id` | `nvarchar` | 32 |  |
| `org_id` | `nvarchar` | 32 |  |

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

## oswfmodactivities

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

Model activities of a workflow model (before instantiation as `oswfactivities`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `workflowid` | `nvarchar` | 32 |  |
| `activityid` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `org_id` | `nvarchar` | 32 |  |

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

## oswfmodctrel

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

Mapping of workflow models to client types.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `workflowid` | `nvarchar` | 32 |  |
| `org_id` | `nvarchar` | 32 |  |
| `clienttypeid` | `nvarchar` | 32 |  |

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

## oswfmodrolerel

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

Mapping of workflow models to roles.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `workflowid` | `nvarchar` | 32 |  |
| `roleid` | `nvarchar` | 32 |  |
| `org_id` | `nvarchar` | 32 |  |

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

## oswfdatatypes

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

Data-type definitions of the workflow data fields per workflow model (BLOB-encoded).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `workflowid` | `nvarchar` | 32 |  |
| `datafieldid` | `nvarchar` | 32 |  |
| `datatype` | `image` | — |  |
| `org_id` | `nvarchar` | 32 |  |

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

## oswfevents

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

Definitions of workflow events at workflow or activity level, with parameters and client-type reference.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `activityid` | `nvarchar` | 32 |  |
| `eventtype` | `int` | — |  |
| `params` | `nvarchar` | 255 |  |
| `description` | `nvarchar` | 255 |  |
| `creationtime` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |
| `clienttypeid` | `nvarchar` | 32 |  |

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

## oswfeventtypes

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

Master data of the known workflow event types (e.g. `onStart`, `onEnd`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `eventtype` | `int` | — |  |
| `name` | `nvarchar` | 255 |  |
| `description` | `nvarchar` | 255 |  |

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

## oswfevtscrrel

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

Mapping of events (`oswfevents`) to scripts (`oswfscripts`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `eventid` | `nvarchar` | 32 |  |
| `scriptid` | `nvarchar` | 32 |  |
| `creationtime` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |

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

## oswffieldvals

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

Global field-value definitions (selection lists) per workflow model.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `nvarchar` | 32 |  |
| `fieldvalue` | `image` | — |  |
| `org_id` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `flags` | `int` | — |  |

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

## oswfscripts

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

Workflow scripts — script code (BLOB), language ID, versioning per workflow model.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `description` | `nvarchar` | 255 |  |
| `code` | `image` | — |  |
| `currentscriptid` | `nvarchar` | 32 |  |
| `creationtime` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `ostype` | `int` | — |  |
| `scriptlangid` | `int` | — |  |

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

## oswfmasks

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

Workflow masks (containers for mask fields), including frame size and workflow reference.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `flags` | `int` | — |  |
| `frame_width` | `int` | — |  |
| `frame_height` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `internalname` | `nvarchar` | 255 |  |

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

## oswfmaskfields

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

Mask-field definitions — layout, tooltips, data type, position and value lists of the workflow mask fields.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `maskid` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `internalname` | `nvarchar` | 255 |  |
| `flags` | `int` | — |  |
| `flags1` | `int` | — |  |
| `flags2` | `int` | — |  |
| `inp_left` | `int` | — |  |
| `inp_top` | `int` | — |  |
| `inp_right` | `int` | — |  |
| `inp_bottom` | `int` | — |  |
| `field_left` | `int` | — |  |
| `field_top` | `int` | — |  |
| `field_right` | `int` | — |  |
| `field_bottom` | `int` | — |  |
| `tab_order` | `int` | — |  |
| `tooltip` | `nvarchar` | 255 |  |
| `org_id` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `init` | `nvarchar` | 255 |  |
| `datatype` | `nvarchar` | 1 |  |
| `inp_len` | `int` | — |  |
| `valuesid` | `nvarchar` | 32 |  |
| `fieldname` | `nvarchar` | 100 |  |
| `id` | `nvarchar` | 32 |  |
| `pageid` | `nvarchar` | 32 |  |
| `defaulturl` | `nvarchar` | max |  |
| `regexp` | `nvarchar` | max |  |

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

## oswfctrlpages

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

Mask pages / tab pages of a workflow model — containers for mask fields (`oswfmaskfields.pageid`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `pageid` | `nvarchar` | 32 |  |
| `parentfieldid` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `pagenumber` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `iconid` | `int` | — |  |
| `internalname` | `nvarchar` | 255 |  |

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

## oswflistctrl

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

Column configuration of list controls in workflow masks.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `org_id` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `maskfieldid` | `nvarchar` | 32 |  |
| `colpos` | `int` | — |  |
| `name` | `nvarchar` | 100 |  |
| `ostype` | `nvarchar` | 1 |  |
| `fieldname` | `nvarchar` | 100 |  |
| `length` | `int` | — |  |
| `colwidth` | `int` | — |  |
| `textalign` | `int` | — |  |
| `color` | `int` | — |  |
| `valuesid` | `nvarchar` | 32 |  |
| `readonly` | `int` | — |  |
| `internalname` | `nvarchar` | 255 |  |
| `osguid` | `nvarchar` | 32 |  |

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

## oswflocalization

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

Global localisation strings per workflow model — value pair `(oskey, oslocname)` → `osvalue`.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `oskey` | `nvarchar` | 440 |  |
| `oslocname` | `nvarchar` | 10 |  |
| `osvalue` | `nvarchar` | max |  |

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

## oswfprocesses

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

Runtime workflow processes — state, locks, counters, reference to workflow model and (optional) DMS object.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `processid` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `creatorid` | `nvarchar` | 32 |  |
| `creationtime` | `int` | — |  |
| `state` | `int` | — |  |
| `finishingtime` | `int` | — |  |
| `parentractivityid` | `nvarchar` | 32 |  |
| `roleid` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `org_id` | `nvarchar` | 32 |  |
| `lockcount` | `int` | — |  |
| `locktime` | `int` | — |  |
| `serverid` | `int` | — |  |
| `threadid` | `int` | — |  |
| `activitycounter` | `int` | — |  |
| `subject` | `nvarchar` | 255 |  |
| `numescalations` | `int` | — |  |
| `priority` | `int` | — |  |
| `objectid` | `int` | — |  |

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

## oswfactivities

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

Runtime activities of an active workflow process — state, timing, looping, escalation and reminder management per activity instance (`ractivityid`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ractivityid` | `nvarchar` | 32 |  |
| `activityid` | `nvarchar` | 32 |  |
| `processid` | `nvarchar` | 32 |  |
| `state` | `int` | — |  |
| `substate` | `int` | — |  |
| `loopcounter` | `int` | — |  |
| `activitynr` | `int` | — |  |
| `ostype` | `int` | — |  |
| `creatorid` | `nvarchar` | 32 |  |
| `creationtime` | `int` | — |  |
| `reminderperiod` | `int` | — |  |
| `reminderstate` | `int` | — |  |
| `endtime` | `int` | — |  |
| `wakeuptime` | `int` | — |  |
| `starttime` | `int` | — |  |
| `rloopid` | `nvarchar` | 32 |  |
| `loopstate` | `int` | — |  |
| `lastcheckpoint` | `int` | — |  |
| `targetstate` | `int` | — |  |
| `suspendstatebefore` | `int` | — |  |
| `suspendstateafter` | `int` | — |  |
| `name` | `nvarchar` | 255 |  |
| `numescalations` | `int` | — |  |
| `containerid` | `nvarchar` | 32 |  |
| `mainadhocid` | `nvarchar` | 32 |  |
| `resourceflags` | `int` | — |  |

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

## oswftransitions

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

Active transitions between activities — state, wake-up time, start and end activity.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `transitionid` | `nvarchar` | 32 |  |
| `state` | `int` | — |  |
| `wakeuptime` | `int` | — |  |
| `ractivityend` | `nvarchar` | 32 |  |
| `loopstate` | `int` | — |  |
| `ractivitystart` | `nvarchar` | 32 |  |
| `processid` | `nvarchar` | 32 |  |

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

## oswfloops

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

Loop configuration of active activities (`rloopid` → `ractivityid`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `rloopid` | `nvarchar` | 32 |  |
| `ractivityid` | `nvarchar` | 32 |  |
| `state` | `int` | — |  |
| `loopcount` | `int` | — |  |

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

## oswfdatafields

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

Current data-field values (variables) of an activity instance — text, BLOB and object reference per `(ractivityid, datafieldid)`.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ractivityid` | `nvarchar` | 32 |  |
| `datafieldid` | `nvarchar` | 32 |  |
| `datavalue` | `nvarchar` | max |  |
| `datavalueblob` | `image` | — |  |
| `datatype` | `int` | — |  |
| `vartype` | `int` | — |  |
| `displayvar` | `int` | — |  |
| `objectid` | `int` | — |  |
| `objecttype` | `int` | — |  |
| `field` | `nvarchar` | 255 |  |
| `resourceflags` | `int` | — |  |

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

## oswfworkitems

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

Workflow work items (inbox entries of a performer for an activity).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ractivityid` | `nvarchar` | 32 |  |
| `state` | `int` | — |  |
| `ownerid` | `nvarchar` | 32 |  |
| `accesstime` | `int` | — |  |
| `creationtime` | `int` | — |  |
| `ignoresubst` | `int` | — |  |

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

## oswfworkitemsrel

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

Work-item / organisation-object mapping (which user/role a work item is assigned to).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `workitemid` | `nvarchar` | 32 |  |
| `orgobject_id` | `nvarchar` | 32 |  |
| `creationtime` | `int` | — |  |
| `reason` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |

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

## oswfworkerqueue

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

Worker queue for asynchronous workflow operations — locks, action type, data BLOB.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ractivityid` | `nvarchar` | 32 |  |
| `state` | `int` | — |  |
| `targetstate` | `int` | — |  |
| `actiontype` | `int` | — |  |
| `creationtime` | `int` | — |  |
| `serverid` | `int` | — |  |
| `lockstate` | `int` | — |  |
| `data` | `image` | — |  |
| `creationserverid` | `int` | — |  |
| `locktime` | `int` | — |  |
| `processid` | `nvarchar` | 32 |  |
| `priority` | `int` | — |  |
| `itemid` | `nvarchar` | 32 |  |

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

## oswflockedprocs

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

Active locks on running workflow processes (server/thread assignment).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `processid` | `nvarchar` | 32 |  |
| `lockcount` | `int` | — |  |
| `serverid` | `int` | — |  |
| `threadid` | `int` | — |  |
| `locktime` | `int` | — |  |

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

## oswfdrel

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

Links between DMS objects and workflow processes — one relation per `(object_id, processid)` with location and variant status.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `object_id` | `int` | — |  |
| `zeitstempel` | `int` | — |  |
| `objecttype` | `int` | — |  |
| `processid` | `nvarchar` | 32 |  |
| `flags` | `int` | — |  |
| `location` | `int` | — |  |
| `workflowid` | `nvarchar` | 32 |  |
| `creationractivity` | `nvarchar` | 32 |  |
| `org_id` | `nvarchar` | 32 |  |
| `original_id` | `int` | — |  |
| `activevariant` | `int` | — |  |
| `display` | `int` | — |  |

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

## oswftray

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

Workflow tray — document inbox for running workflow processes (analogous to the portfolio).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `object_id` | `int` | — |  |
| `objecttype` | `int` | — |  |
| `maintype` | `int` | — |  |
| `creationtime` | `int` | — |  |
| `pagecount` | `int` | — |  |
| `creator` | `nvarchar` | 255 |  |
| `deleted` | `int` | — |  |
| `server_id` | `int` | — |  |
| `filesize` | `bigint` | — |  |
| `mimetypeid` | `int` | — |  |
| `docpagecount` | `int` | — |  |

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

## oswfroles

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

Workflow roles per process (no org-wide master — per-process definition).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `processid` | `nvarchar` | 32 |  |
| `roleid` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `ostype` | `int` | — |  |

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

## oswfrolesrel

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

Parent/child relations between workflow roles.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `processid` | `nvarchar` | 32 |  |
| `roleid` | `nvarchar` | 32 |  |
| `childid` | `nvarchar` | 32 |  |
| `ostype` | `int` | — |  |

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

## oswfperformers

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

Current performer assignments of an activity (performer ID + item ID).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `processid` | `nvarchar` | 32 |  |
| `activityid` | `nvarchar` | 32 |  |
| `performerid` | `nvarchar` | 32 |  |
| `flags` | `int` | — |  |
| `itemid` | `nvarchar` | 32 |  |

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

## oswfmultiactivs

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

Multi-performer assignments of an activity (multiple users per `ractivityid`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ractivityid` | `nvarchar` | 32 |  |
| `userid` | `nvarchar` | 32 |  |

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

## oswfprocresp

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

Process responsibles per workflow process.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `processid` | `nvarchar` | 32 |  |
| `orgobject_id` | `nvarchar` | 32 |  |
| `org_id` | `nvarchar` | 32 |  |

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

## oswfabsence

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

Absence markers for workflow organisation objects (users/roles).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `orgobject_id` | `nvarchar` | 32 |  |
| `org_id` | `nvarchar` | 32 |  |

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

## oswfsubstitutes

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

Substitution rules for workflow organisation objects.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `orgobject_id` | `nvarchar` | 32 |  |
| `substitute_id` | `nvarchar` | 32 |  |
| `resource_type` | `int` | — |  |
| `substitute_type` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |

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

## osorganisations

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

Organisation master data (tenants / organisational units).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `layout` | `image` | 2147483647 |  |
| `active` | `int` | — |  |

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

## osorgobjects

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

Organisation objects (users, roles, departments) — abstract master data.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `nvarchar` | 32 |  |
| `class_id` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `org_id` | `nvarchar` | 32 |  |
| `system` | `smallint` | — |  |

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

## osorgobjrel

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

Relations between organisation objects.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `parent_id` | `nvarchar` | 32 |  |
| `object_id` | `nvarchar` | 32 |  |
| `org_id` | `nvarchar` | 32 |  |
| `parentclass_id` | `nvarchar` | 32 |  |
| `objectclass_id` | `nvarchar` | 32 |  |

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

## osorgobjattrib

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

Attribute values of organisation objects.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `object_id` | `nvarchar` | 32 |  |
| `attrib_id` | `nvarchar` | 32 |  |
| `attrib_value` | `nvarchar` | 255 |  |
| `attrib_blob` | `image` | 2147483647 |  |
| `attrib_flags` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |
| `class_id` | `nvarchar` | 32 |  |

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

## osorgattribrel

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

Organisation-object ↔ attribute mapping.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `orgclass_id` | `nvarchar` | 32 |  |
| `attrib_name` | `nvarchar` | 255 |  |
| `attribclass_id` | `nvarchar` | 32 |  |
| `attrib_id` | `nvarchar` | 32 |  |
| `attrib_flags` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |
| `defaultvalue` | `nvarchar` | 255 |  |
| `defaultvalueblob` | `image` | 2147483647 |  |

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

## osorgclasses

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

Class definitions of organisation objects.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `ostype` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |
| `classimage` | `image` | 2147483647 |  |

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

## osorgclassrel

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

Organisation-class hierarchy.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `parent_id` | `nvarchar` | 32 |  |
| `class_id` | `nvarchar` | 32 |  |
| `default_rel` | `int` | — |  |
| `org_id` | `nvarchar` | 32 |  |

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

## oswftimerconfigs

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

Timer configurations (master data of the timers planned between activities).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `processid` | `nvarchar` | 32 |  |
| `orgid` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `fromactivityid` | `nvarchar` | 32 |  |
| `toactivityid` | `nvarchar` | 32 |  |
| `destinationtime` | `int` | — |  |
| `destinationtype` | `int` | — |  |
| `Looptype` | `int` | — |  |
| `timertype` | `int` | — |  |
| `actions` | `image` | — |  |
| `timerconfigid` | `nvarchar` | 32 |  |
| `timetype` | `int` | — |  |
| `timername` | `nvarchar` | 255 |  |
| `starttype` | `int` | — |  |

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

## oswftimers

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

Active timer instances — planned transitions with state, target time and loop type.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `timerid` | `nvarchar` | 32 |  |
| `processid` | `nvarchar` | 32 |  |
| `orgid` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `fromactivityid` | `nvarchar` | 32 |  |
| `toactivityid` | `nvarchar` | 32 |  |
| `timertype` | `int` | — |  |
| `destinationtime` | `int` | — |  |
| `destinationtype` | `int` | — |  |
| `looptype` | `int` | — |  |
| `actions` | `image` | — |  |
| `timerstate` | `int` | — |  |
| `starttime` | `int` | — |  |
| `timerconfigid` | `nvarchar` | 32 |  |
| `fromractivityid` | `nvarchar` | 32 |  |

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

## oswfroutinglists

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

Routing-list entries of a workflow process — order, status, timer and remark per item.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `itemid` | `nvarchar` | 32 |  |
| `modactivityid` | `nvarchar` | 32 |  |
| `processid` | `nvarchar` | 32 |  |
| `routinglistid` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `itemstate` | `int` | — |  |
| `entrynr` | `int` | — |  |
| `ractivityid` | `nvarchar` | 32 |  |
| `remark` | `nvarchar` | 255 |  |
| `timerid` | `nvarchar` | 32 |  |
| `timerduration` | `int` | — |  |
| `durationtype` | `int` | — |  |
| `flags` | `int` | — |  |

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

## oswfrltemplates

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

Routing-list templates — reusable routing definitions per user / organisation.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `templateid` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `osmode` | `int` | — |  |
| `orgid` | `nvarchar` | 32 |  |
| `userid` | `nvarchar` | 32 |  |
| `template` | `image` | — |  |

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

## oswfrlitemusers

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

Item / user mapping in routing lists (recipients per list item).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `itemid` | `nvarchar` | 32 |  |
| `orgobjectid` | `nvarchar` | 32 |  |

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

## oswfrconfigs

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

Report configurations (analysis templates) as BLOB.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `creationtime` | `int` | — |  |
| `creatorid` | `nvarchar` | 32 |  |
| `ostype` | `int` | — |  |
| `configdata` | `image` | — |  |
| `orgid` | `nvarchar` | 32 |  |

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

## oswfrconffamilies

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

Mapping of report configurations to workflow families.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `configid` | `nvarchar` | 32 |  |
| `familyid` | `nvarchar` | 32 |  |
| `orgid` | `nvarchar` | 32 |  |

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

## oswfreports

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

Generated report instances — status, data BLOB, configuration reference.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `reportid` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `configid` | `nvarchar` | 32 |  |
| `creatorid` | `nvarchar` | 32 |  |
| `creationtime` | `int` | — |  |
| `state` | `int` | — |  |
| `reportdata` | `image` | — |  |
| `orgid` | `nvarchar` | 32 |  |

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

## oswfrrights

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

Permissions on report families per organisation/object.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `orgid` | `nvarchar` | 32 |  |
| `familyid` | `nvarchar` | 32 |  |
| `objectid` | `nvarchar` | 32 |  |

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

## oswfhistory

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

Central history table — one row per history event of a workflow process (activity start/end, routing, …).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histid` | `nvarchar` | 32 |  |
| `processid` | `nvarchar` | 32 |  |
| `ractivityid` | `nvarchar` | 32 |  |
| `histtype` | `int` | — |  |
| `ostime` | `int` | — |  |
| `orgid` | `nvarchar` | 32 |  |
| `userid` | `nvarchar` | 32 |  |
| `username` | `nvarchar` | 255 |  |
| `serverid` | `nvarchar` | 32 |  |
| `servername` | `nvarchar` | 255 |  |
| `entrynr` | `int` | — |  |

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

## oswfhactivities

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

Historised activity master data — written to history on activity completion.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ractivityid` | `nvarchar` | 32 |  |
| `activityid` | `nvarchar` | 32 |  |
| `activityname` | `nvarchar` | 255 |  |
| `resourceflags` | `int` | — |  |
| `histid` | `nvarchar` | 32 |  |

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

## oswfhdatafields

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

Historised data-field values for a history entry (`histid`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histid` | `nvarchar` | 32 |  |
| `datafieldid` | `nvarchar` | 32 |  |
| `datavaluech` | `nvarchar` | max |  |
| `datavaluetype` | `int` | — |  |
| `datavalue` | `image` | — |  |
| `vartype` | `int` | — |  |
| `resourceflags` | `int` | — |  |

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

## oswfhentrydelayed

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

History entries for delayed activations (reason timer + detect history ID).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histid` | `nvarchar` | 32 |  |
| `reasontimerid` | `nvarchar` | 32 |  |
| `detecthistid` | `nvarchar` | 32 |  |

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

## oswfhentryscripts

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

History entries for script-triggered transitions.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histid` | `nvarchar` | 32 |  |
| `eventtype` | `int` | — |  |

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

## oswfhentrytimer

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

History entries for timer-triggered transitions.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histid` | `nvarchar` | 32 |  |
| `timerid` | `nvarchar` | 32 |  |

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

## oswfhfile

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

Historised file/object references for a history entry.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histid` | `nvarchar` | 32 |  |
| `objectid` | `int` | — |  |
| `objecttype` | `int` | — |  |
| `flags` | `int` | — |  |
| `location` | `int` | — |  |

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

## oswfhlocalization

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

Historised localisation strings per history entry (composite primary key `histid` + `oskey` + `oslocname`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histid` | `nvarchar` | 32 |  |
| `oskey` | `nvarchar` | 440 |  |
| `oslocname` | `nvarchar` | 10 |  |
| `osvalue` | `nvarchar` | max |  |

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

## oswfhmodactivities

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

Historised model activities at the time of a workflow version.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histworkflowid` | `nvarchar` | 32 |  |
| `activityid` | `nvarchar` | 32 |  |
| `activityname` | `nvarchar` | 255 |  |

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

## oswfhmoddatafields

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

Historised model data fields at the time of a workflow version.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histworkflowid` | `nvarchar` | 32 |  |
| `datafieldid` | `nvarchar` | 32 |  |
| `datafieldname` | `nvarchar` | 255 |  |
| `datatype` | `image` | — |  |

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

## oswfhperformers

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

Historised performer assignments of an activity.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histid` | `nvarchar` | 32 |  |
| `processid` | `nvarchar` | 32 |  |
| `activityid` | `nvarchar` | 32 |  |
| `performerid` | `nvarchar` | 32 |  |
| `flags` | `int` | — |  |
| `itemid` | `nvarchar` | 32 |  |
| `action` | `int` | — |  |

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

## oswfhprocesses

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

Historised process master data — written to history on process completion.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `processid` | `nvarchar` | 32 |  |
| `processname` | `nvarchar` | 255 |  |
| `histworkflowid` | `nvarchar` | 32 |  |
| `entrycount` | `int` | — |  |
| `lockcount` | `int` | — |  |
| `locktime` | `int` | — |  |
| `serverid` | `int` | — |  |
| `threadid` | `int` | — |  |
| `finalsubject` | `nvarchar` | 255 |  |
| `version` | `int` | — |  |
| `creationtime` | `int` | — |  |
| `endtime` | `int` | — |  |
| `username` | `nvarchar` | 255 |  |
| `state` | `int` | — |  |

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

## oswfhsentmails

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

History entries for sent mails (recipient, triggering user).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histid` | `nvarchar` | 32 |  |
| `emailaddress` | `nvarchar` | 255 |  |
| `orgid` | `nvarchar` | 32 |  |
| `userid` | `nvarchar` | 32 |  |
| `username` | `nvarchar` | 255 |  |

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

## oswfhtimers

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

Historised timer configurations for a workflow process.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `timerid` | `nvarchar` | 32 |  |
| `processid` | `nvarchar` | 32 |  |
| `fromactivityid` | `nvarchar` | 32 |  |
| `toactivityid` | `nvarchar` | 32 |  |
| `timertype` | `int` | — |  |
| `destinationtype` | `int` | — |  |
| `destinationtime` | `int` | — |  |
| `looptype` | `int` | — |  |

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

## oswfhworkflows

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

Historised workflow models (package data as BLOB).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `histworkflowid` | `nvarchar` | 32 |  |
| `orgid` | `nvarchar` | 32 |  |
| `workflowid` | `nvarchar` | 32 |  |
| `version` | `int` | — |  |
| `familyid` | `nvarchar` | 32 |  |
| `name` | `nvarchar` | 255 |  |
| `packagedata` | `image` | — |  |

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

## oswfhworkitemsrel

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

Historised work-item / organisation-object mapping.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ractivityid` | `nvarchar` | 32 |  |
| `orgid` | `nvarchar` | 32 |  |
| `orgobjectid` | `nvarchar` | 32 |  |
| `orgobjectname` | `nvarchar` | 255 |  |
| `reason` | `int` | — |  |
| `histid` | `nvarchar` | 32 |  |

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

## oswflockedhprocs

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

Lock counters for historised processes.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `processid` | `nvarchar` | 32 |  |
| `lockcount` | `int` | — |  |