| id |
int(11)
|
|
|
|
| tracker_id |
int(11)
|
|
|
|
| project_id |
int(11)
|
|
|
|
| subject |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| description |
longtext
|
utf8mb4_unicode_ci
|
|
|
| due_date |
date
|
|
|
|
| category_id |
int(11)
|
|
|
|
| status_id |
int(11)
|
|
|
|
| assigned_to_id |
int(11)
|
|
|
|
| priority_id |
int(11)
|
|
|
|
| fixed_version_id |
int(11)
|
|
|
|
| author_id |
int(11)
|
|
|
|
| lock_version |
int(11)
|
|
|
|
| created_on |
timestamp
|
|
|
|
| updated_on |
timestamp
|
|
|
|
| start_date |
date
|
|
|
|
| done_ratio |
int(11)
|
|
|
|
| estimated_hours |
float
|
|
|
|
| parent_id |
int(11)
|
|
|
|
| root_id |
int(11)
|
|
|
|
| lft |
int(11)
|
|
|
|
| rgt |
int(11)
|
|
|
|
| is_private |
tinyint(1)
|
|
|
|
| closed_on |
datetime
|
|
|
|
