Diagrams

Table

Access Control

DynamicsDocs.comAccess Control«Table 2000000053»Access ControlUser Security ID [PK]Role ID [PK]Company Name [PK]User NameRole NameScope; [System,Tenant] [PK]App ID [PK]App Name«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 2000000006»CompanyName [PK]Evaluation Company<User Security ID><Company Name>

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

Fields

# Name Type
1 User Security ID (User Security ID) GUID
2 Role ID (Role ID) Code20
3 Company Name (Company Name) Text30
5 User Name (User Name) Code50 FlowField
7 Role Name (Role Name) Text30 FlowField
8 Scope (Scope) Option
9 App ID (App ID) GUID
10 App Name (App Name) Text250 FlowField

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
App ID (App ID) Aggregate Permission Set App ID (App ID) 1..n
Company Name (Company Name) Company Name (Name) 1..n
User Security ID (User Security ID) User User Security ID (User Security ID) 1..n

Table Relations From Other Tables

From Table From Field