| id | int(11) |
|
|
|
| name | varchar(255) |
|
|
|
| entities_id | int(11) |
|
|
0
|
| is_recursive | tinyint(1) |
|
|
0
|
| is_deleted | tinyint(1) |
|
|
0
|
| status | int(11) |
|
|
1
|
| content | longtext |
|
|
|
| date_mod | datetime |
|
|
|
| date | datetime |
|
|
|
| solvedate | datetime |
|
|
|
| closedate | datetime |
|
|
|
| time_to_resolve | datetime |
|
|
|
| users_id_recipient | int(11) |
|
|
0
|
| users_id_lastupdater | int(11) |
|
|
0
|
| urgency | int(11) |
|
|
1
|
| impact | int(11) |
|
|
1
|
| priority | int(11) |
|
|
1
|
| itilcategories_id | int(11) |
|
|
0
|
| impactcontent | longtext |
|
|
|
| controlistcontent | longtext |
|
|
|
| rolloutplancontent | longtext |
|
|
|
| backoutplancontent | longtext |
|
|
|
| checklistcontent | longtext |
|
|
|
| global_validation | int(11) |
|
|
1
|
| validation_percent | int(11) |
|
|
0
|
| actiontime | int(11) |
|
|
0
|
| begin_waiting_date | datetime |
|
|
|
| waiting_duration | int(11) |
|
|
0
|
| close_delay_stat | int(11) |
|
|
0
|
| solve_delay_stat | int(11) |
|
|
0
|
| date_creation | datetime |
|
|
|