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