| id |
int(10)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| password_last_update |
timestamp
|
|
|
|
| phone |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| phone2 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| mobile |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| realname |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| firstname |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| locations_id |
int(10)
|
|
|
|
| language |
char(10)
|
utf8mb4_unicode_ci
|
|
|
| use_mode |
int(11)
|
|
|
|
| list_limit |
int(11)
|
|
|
|
| is_active |
tinyint(4)
|
|
|
|
| comment |
text
|
utf8mb4_unicode_ci
|
|
|
| auths_id |
int(10)
|
|
|
|
| authtype |
int(11)
|
|
|
|
| last_login |
timestamp
|
|
|
|
| date_mod |
timestamp
|
|
|
|
| date_sync |
timestamp
|
|
|
|
| is_deleted |
tinyint(4)
|
|
|
|
| profiles_id |
int(10)
|
|
|
|
| entities_id |
int(10)
|
|
|
|
| usertitles_id |
int(10)
|
|
|
|
| usercategories_id |
int(10)
|
|
|
|
| date_format |
int(11)
|
|
|
|
| number_format |
int(11)
|
|
|
|
| names_format |
int(11)
|
|
|
|
| csv_delimiter |
char(1)
|
utf8mb4_unicode_ci
|
|
|
| is_ids_visible |
tinyint(4)
|
|
|
|
| use_flat_dropdowntree |
tinyint(4)
|
|
|
|
| use_flat_dropdowntree_on_search_result |
tinyint(4)
|
|
|
|
| show_jobs_at_login |
tinyint(4)
|
|
|
|
| priority_1 |
char(20)
|
utf8mb4_unicode_ci
|
|
|
| priority_2 |
char(20)
|
utf8mb4_unicode_ci
|
|
|
| priority_3 |
char(20)
|
utf8mb4_unicode_ci
|
|
|
| priority_4 |
char(20)
|
utf8mb4_unicode_ci
|
|
|
| priority_5 |
char(20)
|
utf8mb4_unicode_ci
|
|
|
| priority_6 |
char(20)
|
utf8mb4_unicode_ci
|
|
|
| followup_private |
tinyint(4)
|
|
|
|
| task_private |
tinyint(4)
|
|
|
|
| default_requesttypes_id |
int(10)
|
|
|
|
| password_forget_token |
char(40)
|
utf8mb4_unicode_ci
|
|
|
| password_forget_token_date |
timestamp
|
|
|
|
| user_dn |
text
|
utf8mb4_unicode_ci
|
|
|
| user_dn_hash |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| registration_number |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| show_count_on_tabs |
tinyint(4)
|
|
|
|
| refresh_views |
int(11)
|
|
|
|
| set_default_tech |
tinyint(4)
|
|
|
|
| personal_token |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| personal_token_date |
timestamp
|
|
|
|
| api_token |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| api_token_date |
timestamp
|
|
|
|
| cookie_token |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| cookie_token_date |
timestamp
|
|
|
|
| display_count_on_home |
int(11)
|
|
|
|
| notification_to_myself |
tinyint(4)
|
|
|
|
| duedateok_color |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| duedatewarning_color |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| duedatecritical_color |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| duedatewarning_less |
int(11)
|
|
|
|
| duedatecritical_less |
int(11)
|
|
|
|
| duedatewarning_unit |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| duedatecritical_unit |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| display_options |
text
|
utf8mb4_unicode_ci
|
|
|
| is_deleted_ldap |
tinyint(4)
|
|
|
|
| pdffont |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| picture |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| begin_date |
timestamp
|
|
|
|
| end_date |
timestamp
|
|
|
|
| keep_devices_when_purging_item |
tinyint(4)
|
|
|
|
| privatebookmarkorder |
longtext
|
utf8mb4_unicode_ci
|
|
|
| backcreated |
tinyint(4)
|
|
|
|
| task_state |
int(11)
|
|
|
|
| palette |
char(20)
|
utf8mb4_unicode_ci
|
|
|
| page_layout |
char(20)
|
utf8mb4_unicode_ci
|
|
|
| fold_menu |
tinyint(4)
|
|
|
|
| fold_search |
tinyint(4)
|
|
|
|
| savedsearches_pinned |
text
|
utf8mb4_unicode_ci
|
|
|
| timeline_order |
char(20)
|
utf8mb4_unicode_ci
|
|
|
| itil_layout |
text
|
utf8mb4_unicode_ci
|
|
|
| richtext_layout |
char(20)
|
utf8mb4_unicode_ci
|
|
|
| set_default_requester |
tinyint(4)
|
|
|
|
| lock_autolock_mode |
tinyint(4)
|
|
|
|
| lock_directunlock_notification |
tinyint(4)
|
|
|
|
| date_creation |
timestamp
|
|
|
|
| highcontrast_css |
tinyint(4)
|
|
|
|
| plannings |
text
|
utf8mb4_unicode_ci
|
|
|
| sync_field |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| groups_id |
int(10)
|
|
|
|
| users_id_supervisor |
int(10)
|
|
|
|
| timezone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| default_dashboard_central |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| default_dashboard_assets |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| default_dashboard_helpdesk |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| default_dashboard_mini_ticket |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| default_central_tab |
tinyint(4)
|
|
|
|
| nickname |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| timeline_action_btn_layout |
tinyint(4)
|
|
|
|
| timeline_date_format |
tinyint(4)
|
|
|
|
