# Portfolios (OS variant)

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

## portfolio

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

Portfolio master data (alternative portfolio implementation).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `server_id` | `int` | — |  |
| `user_id` | `int` | — |  |

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

## pfrel

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

Portfolio relation table.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `portfolio_id` | `int` | — |  |
| `doc_id` | `int` | — |  |
| `doc_type` | `int` | — |  |
| `doc_modul` | `int` | — |  |
| `doc_count` | `int` | — |  |
| `user_id` | `int` | — |  |
| `check_in` | `int` | — |  |

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

## osportobjects

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

Objects in portfolios — analogous to `mdrel` but for the portfolio variant.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `userid` | `nvarchar` | 32 |  |
| `confid` | `nvarchar` | 32 |  |
| `objectid` | `int` | — |  |
| `objecttype` | `int` | — |  |

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

## osportobjrel

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

Portfolio-object relations.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `userid` | `nvarchar` | 32 |  |
| `confid` | `nvarchar` | 32 |  |
| `osobjguid` | `nvarchar` | 32 |  |
| `oscabguid` | `nvarchar` | 32 |  |

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

## osportobjright

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

Portfolio permissions.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `userid` | `nvarchar` | 32 |  |
| `confid` | `nvarchar` | 32 |  |
| `osobjguid` | `nvarchar` | 32 |  |
| `objright` | `int` | — |  |
| `objrightvalue` | `int` | — |  |

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

## osportconfig

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

Portfolio configuration.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `userid` | `nvarchar` | 32 |  |
| `confid` | `nvarchar` | 32 |  |
| `modifyuser` | `nvarchar` | 250 |  |
| `modifydatetime` | `nvarchar` | 50 |  |
| `createuser` | `nvarchar` | 250 |  |
| `createdatetime` | `nvarchar` | 50 |  |
| `confstate` | `int` | — |  |
| `confinfo` | `nvarchar` | 250 |  |
| `confname` | `nvarchar` | 50 |  |
| `confversion` | `int` | — |  |
| `showmask` | `int` | — |  |

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

## osportfieldrel

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

Portfolio-field relations.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `userid` | `nvarchar` | 32 |  |
| `confid` | `nvarchar` | 32 |  |
| `osobjguid` | `nvarchar` | 32 |  |
| `osfieldguid` | `nvarchar` | 32 |  |

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

## osportmedien

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

Portfolio-media relations.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `userid` | `nvarchar` | 32 |  |
| `confid` | `nvarchar` | 32 |  |
| `exportpath` | `nvarchar` | 255 |  |
| `mediumname` | `nvarchar` | 50 |  |
| `mediumnumber` | `int` | — |  |
| `mediumsize` | `int` | — |  |

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

## osportbasisfields

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

Basis-field definitions for portfolios.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `userid` | `nvarchar` | 32 |  |
| `confid` | `nvarchar` | 32 |  |
| `objecttype` | `int` | — |  |
| `fieldtype` | `int` | — |  |