Diagrams

Table

User Group Permission Set

DynamicsDocs.comUser Group Permission Set«Table 9003»User Group Permission SetUser Group Code [PK]Role ID [PK]User Group NameRole NameApp ID [PK]Scope; [System,Tenant] [PK]Extension Name«Table 9000»User GroupCode [PK,NN]NameDefault Profile IDAssign to All New UsersCustomizedDefault Profile App IDDefault Profile Scope; [System,Tenant]«Table 2000000004»Permission SetRole ID [PK]Name<User Group Code><Role ID>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field