| id |
char |
36 |
|
|
|
| calls.parent_id
|
Defined in XML R |
| emails.parent_id
|
Defined in XML R |
| meetings.parent_id
|
Defined in XML R |
| notes.parent_id
|
Defined in XML R |
| tasks.parent_id
|
Defined in XML R |
|
|
| date_entered |
datetime |
19 |
√ |
|
null |
|
|
| date_modified |
datetime |
19 |
√ |
|
null |
|
|
| project_id |
char |
36 |
|
|
|
|
|
| project_task_id |
int |
11 |
√ |
|
null |
|
|
| name |
varchar |
50 |
√ |
|
null |
|
|
| status |
varchar |
255 |
√ |
|
null |
|
|
| description |
text |
65535 |
√ |
|
null |
|
|
| predecessors |
text |
65535 |
√ |
|
null |
|
|
| date_start |
date |
10 |
√ |
|
null |
|
|
| time_start |
int |
11 |
√ |
|
null |
|
|
| time_finish |
int |
11 |
√ |
|
null |
|
|
| date_finish |
date |
10 |
√ |
|
null |
|
|
| duration |
int |
11 |
√ |
|
null |
|
|
| duration_unit |
text |
65535 |
√ |
|
null |
|
|
| actual_duration |
int |
11 |
√ |
|
null |
|
|
| percent_complete |
int |
11 |
√ |
|
null |
|
|
| date_due |
date |
10 |
√ |
|
null |
|
|
| time_due |
time |
8 |
√ |
|
null |
|
|
| parent_task_id |
int |
11 |
√ |
|
null |
|
|
| assigned_user_id |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| modified_user_id |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| priority |
varchar |
255 |
√ |
|
null |
|
|
| created_by |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| milestone_flag |
bit |
1 |
√ |
|
0 |
|
|
| order_number |
int |
11 |
√ |
|
1 |
|
|
| task_number |
int |
11 |
√ |
|
null |
|
|
| estimated_effort |
int |
11 |
√ |
|
null |
|
|
| actual_effort |
int |
11 |
√ |
|
null |
|
|
| deleted |
bit |
1 |
√ |
|
0 |
|
|
| utilization |
int |
11 |
√ |
|
100 |
|
|
