|
id
|
char(36)
|
|
|
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
project_id
|
char(36)
|
|
|
|
|
project_task_id
|
int(11)
|
|
|
|
|
name
|
varchar(50)
|
|
|
|
|
status
|
varchar(255)
|
|
|
|
|
relationship_type
|
varchar(255)
|
|
|
|
|
description
|
text
|
|
|
|
|
predecessors
|
text
|
|
|
|
|
date_start
|
date
|
|
|
|
|
time_start
|
int(11)
|
|
|
|
|
time_finish
|
int(11)
|
|
|
|
|
date_finish
|
date
|
|
|
|
|
duration
|
int(11)
|
|
|
|
|
duration_unit
|
text
|
|
|
|
|
actual_duration
|
int(11)
|
|
|
|
|
percent_complete
|
int(11)
|
|
|
|
|
date_due
|
date
|
|
|
|
|
time_due
|
time
|
|
|
|
|
parent_task_id
|
int(11)
|
|
|
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
priority
|
varchar(255)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
milestone_flag
|
tinyint(1)
|
|
|
|
|
order_number
|
int(11)
|
|
|
1
|
|
task_number
|
int(11)
|
|
|
|
|
estimated_effort
|
int(11)
|
|
|
|
|
actual_effort
|
int(11)
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
utilization
|
int(11)
|
|
|
100
|