bgrel

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

Mapping table between users and groups. One row per membership.

1. Columns

Name Type Length Description

Name	Type	Length	Description
`benutzer_id`	`int`	—	User ID. Foreign key to `benutzer.id`.
`gruppen_id`	`int`	—	Group ID. Foreign key to `gruppen.id`.
`osuserguid`	`nvarchar`	32	GUID of the user (denormalised). Corresponds to `benutzer.osguid`.
`osgroupguid`	`nvarchar`	32	GUID of the group (denormalised). Corresponds to `gruppen.osguid`.
`new`	`int`	—	New marker (internal synchronisation).

benutzer_id

int

—

User ID. Foreign key to benutzer.id.

gruppen_id

int

—

Group ID. Foreign key to gruppen.id.

osuserguid

nvarchar

GUID of the user (denormalised). Corresponds to benutzer.osguid.

osgroupguid

nvarchar

GUID of the group (denormalised). Corresponds to gruppen.osguid.

new

int

—

New marker (internal synchronisation).