| id |
char(36)
|
utf8_general_ci
|
|
|
| name |
varchar(255)
|
utf8_general_ci
|
|
|
| date_entered |
datetime
|
|
|
|
| date_modified |
datetime
|
|
|
|
| modified_user_id |
char(36)
|
utf8_general_ci
|
|
|
| created_by |
char(36)
|
utf8_general_ci
|
|
|
| description |
text
|
utf8_general_ci
|
|
|
| deleted |
tinyint(1)
|
|
|
|
| assigned_user_id |
char(36)
|
utf8_general_ci
|
|
|
| status |
varchar(100)
|
utf8_general_ci
|
|
|
| priority |
varchar(100)
|
utf8_general_ci
|
|
|
| percent_complete |
int(255)
|
|
|
|
| predecessors |
int(255)
|
|
|
|
| milestone_flag |
tinyint(1)
|
|
|
|
| relationship_type |
varchar(100)
|
utf8_general_ci
|
|
|
| task_number |
int(255)
|
|
|
|
| order_number |
int(255)
|
|
|
|
| estimated_effort |
int(255)
|
|
|
|
| utilization |
varchar(100)
|
utf8_general_ci
|
|
|
| duration |
int(255)
|
|
|
|
