Diagrams

Table

User Task

DynamicsDocs.comUser Task«Table 1170»User TaskID [PK]TitleCreated ByCreated DateTimeAssigned ToCompleted ByCompleted DateTimeDue DateTimePercent CompleteStart DateTimePriority; [,Low,Normal,High]DescriptionCreated By User NameAssigned To User NameCompleted By User NameObject Type; [,,,Report,,,,,Page]Object IDParent ID«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<Created By><Assigned To><Completed By>

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

Fields

# Name Type
1 ID (ID) Integer AutoIncrement: Yes
Editable: No
2 Title (Title) Text250
3 Created By (Created By) GUID Editable: No
4 Created DateTime (Created DateTime) DateTime Editable: No
5 Assigned To (Assigned To) GUID
7 Completed By (Completed By) GUID
8 Completed DateTime (Completed DateTime) DateTime
9 Due DateTime (Due DateTime) DateTime
10 Percent Complete (Percent Complete) Integer
11 Start DateTime (Start DateTime) DateTime
12 Priority (Priority) Option
13 Description (Description) BLOB [Memo]
14 Created By User Name (Created By User Name) Code50 Editable: No
FlowField
15 Assigned To User Name (Assigned To User Name) Code50 Editable: No
FlowField
16 Completed By User Name (Completed By User Name) Code50 Editable: No
FlowField
17 Object Type (Object Type) Option
18 Object ID (Object ID) Integer
19 Parent ID (Parent ID) Integer

Keys

# Fields
0 ID (ID) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Object ID (Object ID) AllObj Object ID (Object ID) 1..n
Completed By (Completed By) User User Security ID (User Security ID) 1..n

Table Relations From Other Tables

From Table From Field