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