mappe

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

Portfolio master data. A portfolio is a logical, cross-user collection of DMS objects — comparable to a favourites list or a working folder.

1. Columns

Name Type Length Description

id

int

—

Portfolio ID (primary key).

loeschen

smallint

—

Delete marker (for staged deletion).

zeitstempel

int

—

Timestamp of the last change (UNIX time).

angelegt

datetime

—

Creation date.

anleger

nvarchar

255

User name of the creator.

empfaenger

nvarchar

255

Recipient/addressee of the portfolio (for handover portfolios).

thema

nvarchar

32

Subject/title of the portfolio.

typ

smallint

—

Portfolio type.

links

smallint

—

Link count.

anleger_id

int

—

ID of the creator. References benutzer.id.

empfaenger_id

int

—

ID of the recipient. References benutzer.id.

deleted

int

—

Final delete marker.

osobjtypeguid

nvarchar

32

GUID of the portfolio object type.

usercol

nvarchar

255

User-defined column for free data.

2. Related tables

  • mdrel — assignment of documents to the portfolio.

3. Usage by Server-API jobs