Diagrams


Table

User Task

Fields

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

Keys

# Fields
0 ID Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field