# Remarks and texts

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

## remarks

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

Remarks / notes on DMS objects — see [std.StoreRemark](../std.md#std.StoreRemark).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `parent` | `int` | — |  |
| `parenttype` | `int` | — |  |
| `medium` | `int` | — |  |
| `type` | `int` | — |  |
| `stamp1` | `int` | — |  |
| `user1` | `int` | — |  |
| `stamp2` | `int` | — |  |
| `user2` | `int` | — |  |
| `textid` | `nvarchar` | 32 |  |

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

## osremarktext

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

Remark texts (lookup table for `remarks`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ostext` | `nvarchar` | max |  |
| `textid` | `nvarchar` | 32 |  |
| `ostype` | `int` | — |  |
| `osclass` | `int` | — |  |

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

## osreltext

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

Relation texts (for hyperlinks and cross-references — see [hyplnk](locks_and_links.md#database.hyplnk)).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `osreltextid` | `nvarchar` | 32 |  |
| `oslangid` | `int` | — |  |
| `osshortrel` | `nvarchar` | 32 |  |
| `active` | `int` | — |  |
| `objtype1` | `int` | — |  |
| `objtype2` | `int` | — |  |
| `textto` | `nvarchar` | 248 |  |
| `textreverse` | `nvarchar` | 248 |  |

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

## osstringtable

Part of the DMS object definition — stores the multilingual labels for the entries of the
other definition tables. Holds one row per combination of `osguid` (GUID of the translated
element) and `langid` (language) with the display name, tooltip and optional image/URL
references.

Sources for the `osguid` values:

* [`osobjdef.osguid`](dms_object_types_index_fields_and_structures.md#database.osobjdef) — object types (folders, registers,
document types)
* [`osobjfields.osguid`](dms_object_types_index_fields_and_structures.md#database.osobjfields) — index fields
* [`osctrlpages.pageid`](dms_object_types_index_fields_and_structures.md#database.osctrlpages) — tab pages
* [`oslistctrl.osguid`](dms_object_types_index_fields_and_structures.md#database.oslistctrl) — columns of table fields

In the [object definition XML](../xsd/DMSObjDef.md), the rows correspond to the
`<name lang_id="...">…</name>` elements inside the `<names>` blocks of the respective
structures.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `osguid` | `nvarchar` | 32 | GUID of the translated element (object type, field, tab page or table column). |
| `langid` | `int` | — | Language ID (`lang_id` attribute in the XML). Known values: `7` = German, `9` = English,<br>`10` = Spanish, `12` = French, `14` = Hungarian, `16` = Italian, `19` = Dutch, `20`<br>= Norwegian (Bokmål), `21` = Polish, `29` = Swedish. |
| `name` | `nvarchar` | 255 | Language-specific display name of the element (text content of the `<name>` element in<br>the XML). |
| `tooltip` | `nvarchar` | 255 | Tooltip text in the respective language (`tooltip` attribute). |
| `imageid` | `nvarchar` | 32 | GUID/ID of an optional image for the element (`imageid` attribute). |
| `newurl` | `nvarchar` | max | URL for the create context (`newurl` attribute). |
| `updurl` | `nvarchar` | max | URL for the edit/update context (`updateurl` attribute in the XML). |
| `requesturl` | `nvarchar` | max | URL for the request context (`requesturl` attribute). |
| `readonlyurl` | `nvarchar` | max | URL for the read-only context (`readonlyurl` attribute). |
| `defaulturl` | `nvarchar` | max | Default URL of the element (`defaulturl` attribute). |

### Related Tables

* [osobjdef](dms_object_types_index_fields_and_structures.md#database.osobjdef) — object types whose labels are translated.
* [osobjfields](dms_object_types_index_fields_and_structures.md#database.osobjfields) — index fields whose labels are translated.
* [osctrlpages](dms_object_types_index_fields_and_structures.md#database.osctrlpages) — tab pages whose labels are translated.
* [oslistctrl](dms_object_types_index_fields_and_structures.md#database.oslistctrl) — columns of table fields whose labels are
translated.

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

## ostemplate

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

Templates table (document templates, mask templates).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `app_id` | `int` | — |  |
| `viewer_id` | `int` | — |  |
| `namespace_id` | `int` | — |  |
| `alias_id` | `int` | — |  |
| `flags` | `int` | — |  |
| `name` | `nvarchar` | 260 |  |
| `extension` | `nvarchar` | 255 |  |
| `checkoutdir` | `nvarchar` | 260 |  |
| `checkoutstation` | `nvarchar` | 255 |  |
| `checkoutuser_id` | `int` | — |  |