Previous Topic: Wgn3JobStateNext Topic: Wgn3RelatedEvent

Database Schema and Views Reference Guide › Database Tables › Wgn3MgmtGroup

Wgn3MgmtGroup

Defines the groups that a user is allowed to manage or review. This is an extension to the previous schema, which limited users to only a management group and its subgroups.

Column

Primary Key

Datatype

Length

Notes

UserIDM

Part-key that uniquely identifies a CA DataMinder user.

Yes

INTEGER

4

Foreign key: WgnUser

UserID

Part-key that uniquely identifies a CA DataMinder user.

Yes

INTEGER

4

Foreign key: Wgn3User

GroupIDM

Part-key identifying the group that the user can manage.

 

INTEGER

4

Foreign key: WgnGroup

GroupID

Part-key identifying the group that the user can manage.

 

INTEGER

4

Foreign key: WgnGroup

IncludeChildren

Currently unused.

 

BIT

1