| id |
int(10)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| code |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| priority |
int(11)
|
|
|
|
| entities_id |
int(10)
|
|
|
|
| is_recursive |
tinyint(4)
|
|
|
|
| projects_id |
int(10)
|
|
|
|
| projectstates_id |
int(10)
|
|
|
|
| projecttypes_id |
int(10)
|
|
|
|
| date |
timestamp
|
|
|
|
| date_mod |
timestamp
|
|
|
|
| users_id |
int(10)
|
|
|
|
| groups_id |
int(10)
|
|
|
|
| plan_start_date |
timestamp
|
|
|
|
| plan_end_date |
timestamp
|
|
|
|
| real_start_date |
timestamp
|
|
|
|
| real_end_date |
timestamp
|
|
|
|
| percent_done |
int(11)
|
|
|
|
| auto_percent_done |
tinyint(4)
|
|
|
|
| show_on_global_gantt |
tinyint(4)
|
|
|
|
| content |
longtext
|
utf8mb4_unicode_ci
|
|
|
| comment |
longtext
|
utf8mb4_unicode_ci
|
|
|
| is_deleted |
tinyint(4)
|
|
|
|
| date_creation |
timestamp
|
|
|
|
| projecttemplates_id |
int(10)
|
|
|
|
| is_template |
tinyint(4)
|
|
|
|
| template_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
