| id |
int(10)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| entities_id |
int(10)
|
|
|
|
| completename |
text
|
utf8mb4_unicode_ci
|
|
|
| comment |
text
|
utf8mb4_unicode_ci
|
|
|
| level |
int(11)
|
|
|
|
| sons_cache |
longtext
|
utf8mb4_unicode_ci
|
|
|
| ancestors_cache |
longtext
|
utf8mb4_unicode_ci
|
|
|
| registration_number |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| address |
text
|
utf8mb4_unicode_ci
|
|
|
| postcode |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| town |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| state |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| country |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| website |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| phonenumber |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| fax |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| admin_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| admin_email_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| from_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| from_email_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| noreply_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| noreply_email_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| replyto_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| replyto_email_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| notification_subject_tag |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| ldap_dn |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| tag |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| authldaps_id |
int(10)
|
|
|
|
| mail_domain |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| entity_ldapfilter |
text
|
utf8mb4_unicode_ci
|
|
|
| mailing_signature |
text
|
utf8mb4_unicode_ci
|
|
|
| cartridges_alert_repeat |
int(11)
|
|
|
|
| consumables_alert_repeat |
int(11)
|
|
|
|
| use_licenses_alert |
int(11)
|
|
|
|
| send_licenses_alert_before_delay |
int(11)
|
|
|
|
| use_certificates_alert |
int(11)
|
|
|
|
| send_certificates_alert_before_delay |
int(11)
|
|
|
|
| certificates_alert_repeat_interval |
int(11)
|
|
|
|
| use_contracts_alert |
int(11)
|
|
|
|
| send_contracts_alert_before_delay |
int(11)
|
|
|
|
| use_infocoms_alert |
int(11)
|
|
|
|
| send_infocoms_alert_before_delay |
int(11)
|
|
|
|
| use_reservations_alert |
int(11)
|
|
|
|
| use_domains_alert |
int(11)
|
|
|
|
| send_domains_alert_close_expiries_delay |
int(11)
|
|
|
|
| send_domains_alert_expired_delay |
int(11)
|
|
|
|
| autoclose_delay |
int(11)
|
|
|
|
| autopurge_delay |
int(11)
|
|
|
|
| notclosed_delay |
int(11)
|
|
|
|
| calendars_strategy |
tinyint(4)
|
|
|
|
| calendars_id |
int(10)
|
|
|
|
| auto_assign_mode |
int(11)
|
|
|
|
| tickettype |
int(11)
|
|
|
|
| max_closedate |
timestamp
|
|
|
|
| inquest_config |
int(11)
|
|
|
|
| inquest_rate |
int(11)
|
|
|
|
| inquest_delay |
int(11)
|
|
|
|
| inquest_URL |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| autofill_warranty_date |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| autofill_use_date |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| autofill_buy_date |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| autofill_delivery_date |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| autofill_order_date |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| tickettemplates_strategy |
tinyint(4)
|
|
|
|
| tickettemplates_id |
int(10)
|
|
|
|
| changetemplates_strategy |
tinyint(4)
|
|
|
|
| changetemplates_id |
int(10)
|
|
|
|
| problemtemplates_strategy |
tinyint(4)
|
|
|
|
| problemtemplates_id |
int(10)
|
|
|
|
| entities_strategy_software |
tinyint(4)
|
|
|
|
| entities_id_software |
int(10)
|
|
|
|
| default_contract_alert |
int(11)
|
|
|
|
| default_infocom_alert |
int(11)
|
|
|
|
| default_cartridges_alarm_threshold |
int(11)
|
|
|
|
| default_consumables_alarm_threshold |
int(11)
|
|
|
|
| delay_send_emails |
int(11)
|
|
|
|
| is_notif_enable_default |
int(11)
|
|
|
|
| inquest_duration |
int(11)
|
|
|
|
| date_mod |
timestamp
|
|
|
|
| date_creation |
timestamp
|
|
|
|
| autofill_decommission_date |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| suppliers_as_private |
int(11)
|
|
|
|
| anonymize_support_agents |
int(11)
|
|
|
|
| display_users_initials |
int(11)
|
|
|
|
| contracts_strategy_default |
tinyint(4)
|
|
|
|
| contracts_id_default |
int(10)
|
|
|
|
| enable_custom_css |
int(11)
|
|
|
|
| custom_css_code |
text
|
utf8mb4_unicode_ci
|
|
|
| latitude |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| longitude |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| altitude |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| transfers_strategy |
tinyint(4)
|
|
|
|
| transfers_id |
int(10)
|
|
|
|
| agent_base_url |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|