Diagrams


Table

User Group Access Control

Fields

# Name Type
1 User Group Code (User Group Code) Code20
2 User Security ID (User Security ID) GUID
3 Role ID (Role ID) Code20 Editable: No
4 Company Name (Company Name) Text30
5 User Name (User Name) Code50 Editable: No
FlowField
6 Scope (Scope) Option
7 App ID (App ID) GUID

Keys

# Fields
0 User Group Code,User Security ID,Role ID,Company Name,Scope,App ID (User Group Code,User Security ID,Role ID,Company Name,Scope,App ID) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Company Name (Company Name) Company Name (Name) 1..n
Role ID (Role ID) Permission Set Role ID (Role ID) 1..n
User Security ID (User Security ID) User User Security ID (User Security ID) 1..n
User Group Code (User Group Code) User Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field