| rowid | int(11) |
|
|
|
| entity | int(11) |
|
|
1
|
| ref | varchar(128) |
|
|
|
| track_id | varchar(128) |
|
|
|
| fk_soc | int(11) |
|
|
0
|
| fk_project | int(11) |
|
|
0
|
| origin_email | varchar(128) |
|
|
|
| fk_user_create | int(11) |
|
|
|
| fk_user_assign | int(11) |
|
|
|
| subject | varchar(255) |
|
|
|
| message | text |
|
|
|
| fk_statut | int(11) |
|
|
|
| resolution | int(11) |
|
|
|
| progress | varchar(100) |
|
|
|
| timing | varchar(20) |
|
|
|
| type_code | varchar(32) |
|
|
|
| category_code | varchar(32) |
|
|
|
| severity_code | varchar(32) |
|
|
|
| datec | datetime |
|
|
2026-09-27 01:06:34.000000
|
| date_read | datetime |
|
|
2026-09-27 01:06:34.000000
|
| date_close | datetime |
|
|
2026-09-27 01:06:34.000000
|
| notify_tiers_at_create | tinyint(4) |
|
|
|
| tms | timestamp |
|
|
current_timestamp()
|
| import_key | varchar(14) |
|
|
|