| id |
int(10)
|
|
|
|
| entities_id |
int(10)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| date |
timestamp
|
|
|
|
| closedate |
timestamp
|
|
|
|
| solvedate |
timestamp
|
|
|
|
| takeintoaccountdate |
timestamp
|
|
|
|
| date_mod |
timestamp
|
|
|
|
| users_id_lastupdater |
int(10)
|
|
|
|
| status |
int(11)
|
|
|
|
| users_id_recipient |
int(10)
|
|
|
|
| requesttypes_id |
int(10)
|
|
|
|
| content |
longtext
|
utf8mb4_unicode_ci
|
|
|
| urgency |
int(11)
|
|
|
|
| impact |
int(11)
|
|
|
|
| priority |
int(11)
|
|
|
|
| itilcategories_id |
int(10)
|
|
|
|
| type |
int(11)
|
|
|
|
| global_validation |
int(11)
|
|
|
|
| slas_id_ttr |
int(10)
|
|
|
|
| slas_id_tto |
int(10)
|
|
|
|
| slalevels_id_ttr |
int(10)
|
|
|
|
| time_to_resolve |
timestamp
|
|
|
|
| time_to_own |
timestamp
|
|
|
|
| begin_waiting_date |
timestamp
|
|
|
|
| sla_waiting_duration |
int(11)
|
|
|
|
| ola_waiting_duration |
int(11)
|
|
|
|
| olas_id_tto |
int(10)
|
|
|
|
| olas_id_ttr |
int(10)
|
|
|
|
| olalevels_id_ttr |
int(10)
|
|
|
|
| ola_ttr_begin_date |
timestamp
|
|
|
|
| internal_time_to_resolve |
timestamp
|
|
|
|
| internal_time_to_own |
timestamp
|
|
|
|
| waiting_duration |
int(11)
|
|
|
|
| close_delay_stat |
int(11)
|
|
|
|
| solve_delay_stat |
int(11)
|
|
|
|
| takeintoaccount_delay_stat |
int(11)
|
|
|
|
| actiontime |
int(11)
|
|
|
|
| is_deleted |
tinyint(4)
|
|
|
|
| locations_id |
int(10)
|
|
|
|
| validation_percent |
int(11)
|
|
|
|
| date_creation |
timestamp
|
|
|
|