gruppen

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

Master-data table of enaio® user groups. Groups carry permissions and are linked to users via bgrel.

1. Columns

Name Type Length Description

id

int

—

Group ID (primary key, internal). Often referenced from other tables as gruppen_id (e.g. bgrel.gruppen_id, ann_groups.gruppen_id).

name

nvarchar

255

Group name.

profil

int

—

ID of the assigned profile.

osguid

nvarchar

32

External GUID of the group. Often referenced from other tables as osgroupguid (e.g. bgrel.osgroupguid) and used as the principal value in the objectXr/stammXr/registerXr rights tables (value column) for group-based permissions.

description

nvarchar

255

Description of the group.

osdeptguid

nvarchar

32

GUID of the assigned department.

2. Related tables

  • benutzer — the users who can belong to a group.

  • bgrel — user/group mapping (bgrel.gruppen_id → gruppen.id, bgrel.osgroupguid → gruppen.osguid).

  • ann_groups — assignment of annotations to groups (ann_groups.gruppen_id → gruppen.id).

  • objekte — rights clauses per group and object type (objekte.gruppen_id → gruppen.id).

3. Usage by Server-API jobs