benutzer

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

Master-data table of enaio® user accounts. Holds login credentials (user name, password), profile reference, MFA configuration, external-ID mapping and status information.

1. Columns

Name Type Length Description

id

int

—

User ID (primary key, internal). Often referenced from other tables as user_id — see References from other tables.

supervisor

smallint

—

Supervisor flag (1 = supervisor with full rights).

benutzer

nvarchar

255

User name (login ID). Often referenced from other tables as anleger, archivar, modifyuser, osowner or lockuser — see References from other tables.

passwort

nvarchar

255

Password (hashed).

station

nvarchar

255

Assigned station.

logintime

int

—

Time of the last login as a UNIX timestamp (seconds). NULL if the user has never logged in.

server_id

int

—

Home server of the user (0 = no server assigned). Foreign key to server.id.

profil

int

—

benutzer.id of the user serving as the profile user for this user (reference to benutzer.id). Special values:

* -1 — no profile user assigned. * 0 — the user is themselves a profile user. * otherwise — benutzer.id of another user whose settings are inherited.

The profile configuration (which setting categories are active for the profile user) lives in osprofile — resolved in two steps: first look up the benutzer.osguid of the profile user, then match it against osprofile.userid.

geaendert

int

—

Modified marker.

flags

int

—

Status flags (bitmask).

name

nvarchar

255

Full name (display name).

bemerkung

nvarchar

248

Free-text remark.

logincount

int

—

Number of successful logins.

locked

int

—

Lock status of the account (boolean as integer). 0 = unlocked, 1 = locked.

loginstation

nvarchar

255

Last login station.

osguid

nvarchar

32

External GUID of the user. Often referenced from other tables as osuserguid — see References from other tables.

osemail

nvarchar

248

Email address.

account_type

int

—

Type of the user account:

* NULL — regular user. * 1 — technical server user (automatically created). * 2 — anonymous user (automatically created). * 4 — installation root user (automatically created).

langid

int

—

Preferred language of the user. Foreign key to oslanguages.langid. NULL if no language was selected — in that case the language marked as the active default in oslanguages (active = 2) applies.

validfrom

nvarchar

32

Start of validity of the user account. Date-time format YYYY/MM/DD HH:MM:SS (e.g. 2026/05/24 15:36:07) as text.

validto

nvarchar

32

End of validity of the user account. Date-time format YYYY/MM/DD HH:MM:SS (e.g. 2026/05/24 15:36:07) as text.

osdeptguid

nvarchar

32

GUID of the assigned department.

pwd_changed

int

—

Timestamp of last password change (UNIX time).

never_expire

int

—

Flag: password does not expire.

changepwd

int

—

Flag: user must change password on next login.

mfauthflag

smallint

—

MFA activation flag.

mfauthsecret

nvarchar

255

MFA secret (TOTP seed or similar).

loginname

nvarchar

255

Login name (may differ from benutzer, e.g. AD login).

externid

nvarchar

255

External ID (for SSO / identity-provider mapping).

2. Related tables

  • gruppen — the groups users belong to.

  • bgrel — user/group mapping (bgrel.benutzer_id → benutzer.id, bgrel.osuserguid → benutzer.osguid).

3. References from other tables

The user table is referenced across the entire schema — under varying column names and via three different keys. The following conventions occur frequently:

Key Typical column names Examples

benutzer.id (int)

user_id, benutzer_id, anleger_id, empfaenger_id, lockuser

doclock.user_id, annotations.user_id, bgrel.benutzer_id, mappe.anleger_id / mappe.empfaenger_id

benutzer.osguid (nvarchar(32))

osuserguid, osowner

bgrel.osuserguid, objectX.osowner / stammX.osowner / registerX.osowner (see Document objects). The principal value (value) in the objectXr/stammXr/registerXr rights tables can also be a user GUID.

benutzer.benutzer (nvarchar(255), login name)

anleger, archivar, modifyuser, osowner, lockuser

objectX.anleger, objectX.archivar, objectX.modifyuser (see Document objects); mappe.anleger / mappe.empfaenger; annotations via user_id
The columns osowner and lockuser appear under both the GUID and the login-name references because they can take on either meaning in different tables or display contexts. The decisive criterion is the column length: nvarchar(32) for GUIDs, nvarchar(255) for login names, int for IDs.

4. Usage by Server-API jobs