Diagrams

Table

User Group Member

DynamicsDocs.comUser Group Member«Table 9001»User Group MemberUser Group Code [PK,NN]User Security ID [PK,NN]Company Name [PK]User NameUser Full NameUser Group Name«Table 9000»User GroupCode [PK,NN]NameDefault Profile IDAssign to All New Users«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 Group Code><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 Group Code (User Group Code) Code20 NotBlank: Yes
2 User Security ID (User Security ID) GUID NotBlank: Yes
3 Company Name (Company Name) Text30
4 User Name (User Name) Code50 Editable: No
FlowField
5 User Full Name (User Full Name) Text80 Editable: No
FlowField
6 User Group Name (User Group Name) Text50 Editable: No
FlowField

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Company Name (Company Name) Company Name (Name) 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