Diagrams

Table

User Group

DynamicsDocs.comUser Group«Table 9000»User GroupCode [PK,NN]NameDefault Profile IDAssign to All New Users«Table 9001»User Group MemberUser Group Code [PK,NN]User Security ID [PK,NN]Company Name [PK]User NameUser Full NameUser Group Name«Table 9002»User Group Access ControlUser Group Code [PK]User Security ID [PK]Role ID [PK]Company Name [PK]User NameScope; [System,Tenant] [PK]App ID [PK]«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 9007»User Group PlanPlan ID [PK]User Group Code [PK]Plan NameUser Group Name«Table 2000000072»ProfileProfile ID [PK]DescriptionRole Center IDDefault Role CenterUse CommentsUse NotesUse Record NotesRecord NotebookUse Page NotesPage NotebookDisable Personalization<Default Profile ID><User Group Code><User Group Code><User Group Code><User Group Code>

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

Fields

# Name Type
1 Code (Code) Code20 NotBlank: Yes
2 Name (Name) Text50
3 Default Profile ID (Default Profile ID) Code30
4 Assign to All New Users (Assign to All New Users) Boolean

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Default Profile ID (Default Profile ID) Profile Profile ID (Profile ID) 1..n

Table Relations From Other Tables

From Table From Field
User Group Access Control User Group Code (User Group Code) 1..n
User Group Member User Group Code (User Group Code) 1..n
User Group Permission Set User Group Code (User Group Code) 1..n
User Group Plan User Group Code (User Group Code) 1..n