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 |
|
|
resource_id |
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 |
|
|
team_id |
char |
36 |
√ |
|
null |
|
teams.id
|
Defined in XML R |
|
team_set_id |
char |
36 |
√ |
|
null |
|
|
acl_team_set_id |
char |
36 |
√ |
|
null |
|
|