Diagrams

Table

User Group Plan

DynamicsDocs.comUser Group Plan«Table 9007»User Group PlanPlan ID [PK]User Group Code [PK]Plan NameUser Group Name«Table 9004»PlanPlan ID [PK]NameRole Center ID«Table 9000»User GroupCode [PK,NN]NameDefault Profile IDAssign to All New Users<Plan ID><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 Plan ID (Plan ID) GUID
2 User Group Code (User Group Code) Code20
10 Plan Name (Plan Name) Text50 FlowField
11 User Group Name (User Group Name) Text50 FlowField

Keys

# Fields
0 Plan ID,User Group Code (Plan ID,User Group Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Plan ID (Plan ID) Plan Plan ID (Plan ID) 1..n
User Group Code (User Group Code) User Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field