Suelte aquí los archivos

Carga SQL ( 0 ) x -

Ajustes de página relacionada Pulse en la barra para deslizarse al tope de la página
Presione Ctrl+Enter para ejecutar la consulta Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar Expandir Mostrar rastro Ocultar rastro Cantidad : Tiempo necesario :
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Opciones
Definir predeterminado





Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :
Sin título *
v Mostrar/Ocultar lista de tablas Ver en pantalla completa Añadir tablas de otras bases de datos Nueva página Abrir página Guardar página Guardar página como Borrar páginas Crear tabla Crear relación Elegir la columna a mostrar Cargar nuevamente Ayuda Enlaces angulares / Enlaces directos Cuadrícula magnética v Pequeño/grande todos Alterne entre pequeño y grande Alternar líneas de relación Exportar estructura > Mover el Menú > Fijar texto
v v
Número de tablas: 0
v gpli glpi_agents
* id : int(10) unsigned
* deviceid : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* agenttypes_id : int(10) unsigned
* last_contact : timestamp
* version : varchar(255)
* locked : tinyint(4)
* itemtype : varchar(100)
* items_id : int(10) unsigned
* useragent : varchar(255)
* tag : varchar(255)
* port : varchar(6)
* remote_addr : varchar(255)
* threads_networkdiscovery : int(11)
* threads_networkinventory : int(11)
* timeout_networkdiscovery : int(11)
* timeout_networkinventory : int(11)
* use_module_wake_on_lan : tinyint(4)
* use_module_computer_inventory : tinyint(4)
* use_module_esx_remote_inventory : tinyint(4)
* use_module_remote_inventory : tinyint(4)
* use_module_network_inventory : tinyint(4)
* use_module_network_discovery : tinyint(4)
* use_module_package_deployment : tinyint(4)
* use_module_collect_data : tinyint(4)
v gpli glpi_agenttypes
* id : int(10) unsigned
* name : varchar(255)
v gpli glpi_alerts
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* type : int(11)
* date : timestamp
v gpli glpi_apiclients
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* is_active : tinyint(4)
* ipv4_range_start : bigint(20)
* ipv4_range_end : bigint(20)
* ipv6 : varchar(255)
* app_token : varchar(255)
* app_token_date : timestamp
* dolog_method : tinyint(4)
* comment : text
v gpli glpi_applianceenvironments
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v gpli glpi_appliances
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* is_deleted : tinyint(4)
* appliancetypes_id : int(10) unsigned
* comment : text
* locations_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* applianceenvironments_id : int(10) unsigned
* users_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id : int(10) unsigned
* groups_id_tech : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
* states_id : int(10) unsigned
* externalidentifier : varchar(255)
* serial : varchar(255)
* otherserial : varchar(255)
* contact : varchar(255)
* contact_num : varchar(255)
* is_helpdesk_visible : tinyint(4)
* pictures : text
v gpli glpi_appliances_items
* id : int(10) unsigned
* appliances_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
v gpli glpi_appliances_items_relations
* id : int(10) unsigned
* appliances_items_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v gpli glpi_appliancetypes
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* externalidentifier : varchar(255)
v gpli glpi_authldapreplicates
* id : int(10) unsigned
* authldaps_id : int(10) unsigned
* host : varchar(255)
* port : int(11)
* name : varchar(255)
* timeout : int(11)
v gpli glpi_authldaps
* id : int(10) unsigned
* name : varchar(255)
* host : varchar(255)
* basedn : varchar(255)
* rootdn : varchar(255)
* port : int(11)
* condition : text
* login_field : varchar(255)
* sync_field : varchar(255)
* use_tls : tinyint(4)
* group_field : varchar(255)
* group_condition : text
* group_search_type : int(11)
* group_member_field : varchar(255)
* email1_field : varchar(255)
* realname_field : varchar(255)
* firstname_field : varchar(255)
* phone_field : varchar(255)
* phone2_field : varchar(255)
* mobile_field : varchar(255)
* comment_field : varchar(255)
* use_dn : tinyint(4)
* time_offset : int(11)
* deref_option : int(11)
* title_field : varchar(255)
* category_field : varchar(255)
* language_field : varchar(255)
* entity_field : varchar(255)
* entity_condition : text
* date_mod : timestamp
* comment : text
* is_default : tinyint(4)
* is_active : tinyint(4)
* rootdn_passwd : varchar(255)
* registration_number_field : varchar(255)
* email2_field : varchar(255)
* email3_field : varchar(255)
* email4_field : varchar(255)
* location_field : varchar(255)
* responsible_field : varchar(255)
* pagesize : int(11)
* ldap_maxlimit : int(11)
* can_support_pagesize : tinyint(4)
* picture_field : varchar(255)
* date_creation : timestamp
* inventory_domain : varchar(255)
* tls_certfile : text
* tls_keyfile : text
* use_bind : tinyint(4)
* timeout : int(11)
v gpli glpi_authmails
* id : int(10) unsigned
* name : varchar(255)
* connect_string : varchar(255)
* host : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* comment : text
* is_active : tinyint(4)
v gpli glpi_autoupdatesystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v gpli glpi_blacklistedmailcontents
* id : int(10) unsigned
* name : varchar(255)
* content : text
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_blacklists
* id : int(10) unsigned
* type : int(11)
* name : varchar(255)
* value : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_budgets
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
* is_deleted : tinyint(4)
* begin_date : date
* end_date : date
* value : decimal(20,4)
* is_template : tinyint(4)
* template_name : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* locations_id : int(10) unsigned
* budgettypes_id : int(10) unsigned
v gpli glpi_budgettypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_businesscriticities
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
* businesscriticities_id : int(10) unsigned
* completename : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
v gpli glpi_cables
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* itemtype_endpoint_a : varchar(255)
* itemtype_endpoint_b : varchar(255)
* items_id_endpoint_a : int(10) unsigned
* items_id_endpoint_b : int(10) unsigned
* socketmodels_id_endpoint_a : int(10) unsigned
* socketmodels_id_endpoint_b : int(10) unsigned
* sockets_id_endpoint_a : int(10) unsigned
* sockets_id_endpoint_b : int(10) unsigned
* cablestrands_id : int(10) unsigned
* color : varchar(255)
* otherserial : varchar(255)
* states_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* cabletypes_id : int(10) unsigned
* comment : text
* date_mod : timestamp
* date_creation : timestamp
* is_deleted : tinyint(4)
v gpli glpi_cablestrands
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_cabletypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_calendars
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
* date_mod : timestamp
* cache_duration : text
* date_creation : timestamp
v gpli glpi_calendarsegments
* id : int(10) unsigned
* calendars_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* day : tinyint(4)
* begin : time
* end : time
v gpli glpi_calendars_holidays
* id : int(10) unsigned
* calendars_id : int(10) unsigned
* holidays_id : int(10) unsigned
v gpli glpi_cartridgeitems
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* ref : varchar(255)
* locations_id : int(10) unsigned
* cartridgeitemtypes_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_deleted : tinyint(4)
* comment : text
* alarm_threshold : int(11)
* stock_target : int(11)
* date_mod : timestamp
* date_creation : timestamp
* pictures : text
v gpli glpi_cartridgeitems_printermodels
* id : int(10) unsigned
* cartridgeitems_id : int(10) unsigned
* printermodels_id : int(10) unsigned
v gpli glpi_cartridgeitemtypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_cartridges
* id : int(10) unsigned
* entities_id : int(10) unsigned
* cartridgeitems_id : int(10) unsigned
* printers_id : int(10) unsigned
* date_in : date
* date_use : date
* date_out : date
* pages : int(11)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_certificates
* id : int(10) unsigned
* name : varchar(255)
* serial : varchar(255)
* otherserial : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
* is_deleted : tinyint(4)
* is_template : tinyint(4)
* template_name : varchar(255)
* certificatetypes_id : int(10) unsigned
* dns_name : varchar(255)
* dns_suffix : varchar(255)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* locations_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* contact : varchar(255)
* contact_num : varchar(255)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* is_autosign : tinyint(4)
* date_expiration : date
* states_id : int(10) unsigned
* command : text
* certificate_request : text
* certificate_item : text
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_certificates_items
* id : int(10) unsigned
* certificates_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_certificatetypes
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_changecosts
* id : int(10) unsigned
* changes_id : int(10) unsigned
* name : varchar(255)
* comment : text
* begin_date : date
* end_date : date
* actiontime : int(11)
* cost_time : decimal(20,4)
* cost_fixed : decimal(20,4)
* cost_material : decimal(20,4)
* budgets_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v gpli glpi_changes
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* is_deleted : tinyint(4)
* status : int(11)
* content : longtext
* date_mod : timestamp
* date : timestamp
* solvedate : timestamp
* closedate : timestamp
* time_to_resolve : timestamp
* users_id_recipient : int(10) unsigned
* users_id_lastupdater : int(10) unsigned
* urgency : int(11)
* impact : int(11)
* priority : int(11)
* itilcategories_id : int(10) unsigned
* impactcontent : longtext
* controlistcontent : longtext
* rolloutplancontent : longtext
* backoutplancontent : longtext
* checklistcontent : longtext
* 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) unsigned
v gpli glpi_changes_groups
* id : int(10) unsigned
* changes_id : int(10) unsigned
* groups_id : int(10) unsigned
* type : int(11)
v gpli glpi_changes_items
* id : int(10) unsigned
* changes_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v gpli glpi_changes_problems
* id : int(10) unsigned
* changes_id : int(10) unsigned
* problems_id : int(10) unsigned
v gpli glpi_changes_suppliers
* id : int(10) unsigned
* changes_id : int(10) unsigned
* suppliers_id : int(10) unsigned
* type : int(11)
* use_notification : tinyint(4)
* alternative_email : varchar(255)
v gpli glpi_changes_tickets
* id : int(10) unsigned
* changes_id : int(10) unsigned
* tickets_id : int(10) unsigned
v gpli glpi_changes_users
* id : int(10) unsigned
* changes_id : int(10) unsigned
* users_id : int(10) unsigned
* type : int(11)
* use_notification : tinyint(4)
* alternative_email : varchar(255)
v gpli glpi_changetasks
* id : int(10) unsigned
* uuid : varchar(255)
* changes_id : int(10) unsigned
* taskcategories_id : int(10) unsigned
* state : int(11)
* date : timestamp
* begin : timestamp
* end : timestamp
* users_id : int(10) unsigned
* users_id_editor : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* content : longtext
* actiontime : int(11)
* date_mod : timestamp
* date_creation : timestamp
* tasktemplates_id : int(10) unsigned
* timeline_position : tinyint(4)
* is_private : tinyint(4)
v gpli glpi_changetemplatehiddenfields
* id : int(10) unsigned
* changetemplates_id : int(10) unsigned
* num : int(11)
v gpli glpi_changetemplatemandatoryfields
* id : int(10) unsigned
* changetemplates_id : int(10) unsigned
* num : int(11)
v gpli glpi_changetemplatepredefinedfields
* id : int(10) unsigned
* changetemplates_id : int(10) unsigned
* num : int(11)
* value : text
v gpli glpi_changetemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v gpli glpi_changevalidations
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* users_id : int(10) unsigned
* changes_id : int(10) unsigned
* users_id_validate : int(10) unsigned
* comment_submission : text
* comment_validation : text
* status : int(11)
* submission_date : timestamp
* validation_date : timestamp
* timeline_position : tinyint(4)
v gpli glpi_clusters
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* uuid : varchar(255)
* version : varchar(255)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_deleted : tinyint(4)
* states_id : int(10) unsigned
* comment : text
* clustertypes_id : int(10) unsigned
* autoupdatesystems_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_clustertypes
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_computerantiviruses
* id : int(10) unsigned
* computers_id : int(10) unsigned
* name : varchar(255)
* manufacturers_id : int(10) unsigned
* antivirus_version : varchar(255)
* signature_version : varchar(255)
* is_active : tinyint(4)
* is_deleted : tinyint(4)
* is_uptodate : tinyint(4)
* is_dynamic : tinyint(4)
* date_expiration : timestamp
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_computermodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* weight : int(11)
* required_units : int(11)
* depth : float
* power_connections : int(11)
* power_consumption : int(11)
* is_half_rack : tinyint(4)
* picture_front : text
* picture_rear : text
* pictures : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_computers
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* serial : varchar(255)
* otherserial : varchar(255)
* contact : varchar(255)
* contact_num : varchar(255)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* comment : text
* date_mod : timestamp
* autoupdatesystems_id : int(10) unsigned
* locations_id : int(10) unsigned
* networks_id : int(10) unsigned
* computermodels_id : int(10) unsigned
* computertypes_id : int(10) unsigned
* is_template : tinyint(4)
* template_name : varchar(255)
* manufacturers_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* states_id : int(10) unsigned
* ticket_tco : decimal(20,4)
* uuid : varchar(255)
* date_creation : timestamp
* is_recursive : tinyint(4)
* last_inventory_update : timestamp
* last_boot : timestamp
v gpli glpi_computers_items
* id : int(10) unsigned
* items_id : int(10) unsigned
* computers_id : int(10) unsigned
* itemtype : varchar(100)
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
v gpli glpi_computertypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_computervirtualmachines
* id : int(10) unsigned
* entities_id : int(10) unsigned
* computers_id : int(10) unsigned
* name : varchar(255)
* virtualmachinestates_id : int(10) unsigned
* virtualmachinesystems_id : int(10) unsigned
* virtualmachinetypes_id : int(10) unsigned
* uuid : varchar(255)
* vcpu : int(11)
* ram : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_configs
* id : int(10) unsigned
* context : varchar(150)
* name : varchar(150)
* value : text
v gpli glpi_consumableitems
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* ref : varchar(255)
* locations_id : int(10) unsigned
* consumableitemtypes_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_deleted : tinyint(4)
* comment : text
* alarm_threshold : int(11)
* stock_target : int(11)
* date_mod : timestamp
* date_creation : timestamp
* otherserial : varchar(255)
* pictures : text
v gpli glpi_consumableitemtypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_consumables
* id : int(10) unsigned
* entities_id : int(10) unsigned
* consumableitems_id : int(10) unsigned
* date_in : date
* date_out : date
* itemtype : varchar(100)
* items_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_contacts
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* firstname : varchar(255)
* registration_number : varchar(255)
* phone : varchar(255)
* phone2 : varchar(255)
* mobile : varchar(255)
* fax : varchar(255)
* email : varchar(255)
* contacttypes_id : int(10) unsigned
* comment : text
* is_deleted : tinyint(4)
* usertitles_id : int(10) unsigned
* address : text
* postcode : varchar(255)
* town : varchar(255)
* state : varchar(255)
* country : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* pictures : text
v gpli glpi_contacts_suppliers
* id : int(10) unsigned
* suppliers_id : int(10) unsigned
* contacts_id : int(10) unsigned
v gpli glpi_contacttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_contractcosts
* id : int(10) unsigned
* contracts_id : int(10) unsigned
* name : varchar(255)
* comment : text
* begin_date : date
* end_date : date
* cost : decimal(20,4)
* budgets_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v gpli glpi_contracts
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* num : varchar(255)
* contracttypes_id : int(10) unsigned
* locations_id : int(10) unsigned
* begin_date : date
* duration : int(11)
* notice : int(11)
* periodicity : int(11)
* billing : int(11)
* comment : text
* accounting_number : varchar(255)
* is_deleted : tinyint(4)
* week_begin_hour : time
* week_end_hour : time
* saturday_begin_hour : time
* saturday_end_hour : time
* use_saturday : tinyint(4)
* sunday_begin_hour : time
* sunday_end_hour : time
* use_sunday : tinyint(4)
* alert : int(11)
* renewal : int(11)
* template_name : varchar(255)
* is_template : tinyint(4)
* states_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_contracts_items
* id : int(10) unsigned
* contracts_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
v gpli glpi_contracts_suppliers
* id : int(10) unsigned
* suppliers_id : int(10) unsigned
* contracts_id : int(10) unsigned
v gpli glpi_contracttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_crontasklogs
* id : int(10) unsigned
* crontasks_id : int(10) unsigned
* crontasklogs_id : int(10) unsigned
* date : timestamp
* state : int(11)
* elapsed : float
* volume : int(11)
* content : varchar(255)
v gpli glpi_crontasks
* id : int(10) unsigned
* itemtype : varchar(100)
* name : varchar(150)
* frequency : int(11)
* param : int(11)
* state : int(11)
* mode : int(11)
* allowmode : int(11)
* hourmin : int(11)
* hourmax : int(11)
* logs_lifetime : int(11)
* lastrun : timestamp
* lastcode : int(11)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_dashboards_dashboards
* id : int(10) unsigned
* key : varchar(100)
* name : varchar(100)
* context : varchar(100)
* users_id : int(10) unsigned
v gpli glpi_dashboards_filters
* id : int(10) unsigned
* dashboards_dashboards_id : int(10) unsigned
* users_id : int(10) unsigned
* filter : longtext
v gpli glpi_dashboards_items
* id : int(10) unsigned
* dashboards_dashboards_id : int(10) unsigned
* gridstack_id : varchar(255)
* card_id : varchar(255)
* x : int(11)
* y : int(11)
* width : int(11)
* height : int(11)
* card_options : text
v gpli glpi_dashboards_rights
* id : int(10) unsigned
* dashboards_dashboards_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v gpli glpi_databaseinstancecategories
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_databaseinstances
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* version : varchar(255)
* port : varchar(10)
* path : varchar(255)
* size : int(11)
* databaseinstancetypes_id : int(10) unsigned
* databaseinstancecategories_id : int(10) unsigned
* locations_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* states_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* is_onbackup : tinyint(4)
* is_active : tinyint(4)
* is_deleted : tinyint(4)
* is_helpdesk_visible : tinyint(4)
* is_dynamic : tinyint(4)
* autoupdatesystems_id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
* date_lastboot : timestamp
* date_lastbackup : timestamp
* comment : text
v gpli glpi_databaseinstancetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_databases
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* size : int(11)
* databaseinstances_id : int(10) unsigned
* is_onbackup : tinyint(4)
* is_active : tinyint(4)
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* date_creation : timestamp
* date_mod : timestamp
* date_update : timestamp
* date_lastbackup : timestamp
v gpli glpi_datacenters
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* locations_id : int(10) unsigned
* is_deleted : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
* pictures : text
v gpli glpi_dcrooms
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* locations_id : int(10) unsigned
* vis_cols : int(11)
* vis_rows : int(11)
* blueprint : text
* datacenters_id : int(10) unsigned
* is_deleted : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicebatteries
* id : int(10) unsigned
* designation : varchar(255)
* comment : text
* manufacturers_id : int(10) unsigned
* voltage : int(11)
* capacity : int(11)
* devicebatterytypes_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicebatterymodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicebatterymodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicebatterytypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicecameramodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicecameras
* id : int(10) unsigned
* designation : varchar(255)
* flashunit : tinyint(4)
* lensfacing : varchar(255)
* orientation : varchar(255)
* focallength : varchar(255)
* sensorsize : varchar(255)
* comment : text
* manufacturers_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicecameramodels_id : int(10) unsigned
* support : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicecasemodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicecases
* id : int(10) unsigned
* designation : varchar(255)
* devicecasetypes_id : int(10) unsigned
* comment : text
* manufacturers_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicecasemodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicecasetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicecontrolmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicecontrols
* id : int(10) unsigned
* designation : varchar(255)
* is_raid : tinyint(4)
* comment : text
* manufacturers_id : int(10) unsigned
* interfacetypes_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicecontrolmodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicedrivemodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicedrives
* id : int(10) unsigned
* designation : varchar(255)
* is_writer : tinyint(4)
* speed : varchar(255)
* comment : text
* manufacturers_id : int(10) unsigned
* interfacetypes_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicedrivemodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicefirmwaremodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicefirmwares
* id : int(10) unsigned
* designation : varchar(255)
* comment : text
* manufacturers_id : int(10) unsigned
* date : date
* version : varchar(255)
* devicefirmwaretypes_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicefirmwaremodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicefirmwaretypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicegenericmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicegenerics
* id : int(10) unsigned
* designation : varchar(255)
* devicegenerictypes_id : int(10) unsigned
* comment : text
* manufacturers_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
* devicegenericmodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicegenerictypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v gpli glpi_devicegraphiccardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicegraphiccards
* id : int(10) unsigned
* designation : varchar(255)
* interfacetypes_id : int(10) unsigned
* comment : text
* manufacturers_id : int(10) unsigned
* memory_default : int(11)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicegraphiccardmodels_id : int(10) unsigned
* chipset : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_deviceharddrivemodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_deviceharddrives
* id : int(10) unsigned
* designation : varchar(255)
* rpm : varchar(255)
* interfacetypes_id : int(10) unsigned
* cache : varchar(255)
* comment : text
* manufacturers_id : int(10) unsigned
* capacity_default : int(11)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* deviceharddrivemodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicememories
* id : int(10) unsigned
* designation : varchar(255)
* frequence : varchar(255)
* comment : text
* manufacturers_id : int(10) unsigned
* size_default : int(11)
* devicememorytypes_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicememorymodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicememorymodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicememorytypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicemotherboardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicemotherboards
* id : int(10) unsigned
* designation : varchar(255)
* chipset : varchar(255)
* comment : text
* manufacturers_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicemotherboardmodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicenetworkcardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicenetworkcards
* id : int(10) unsigned
* designation : varchar(255)
* bandwidth : varchar(255)
* comment : text
* manufacturers_id : int(10) unsigned
* mac_default : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicenetworkcardmodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicepcimodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicepcis
* id : int(10) unsigned
* designation : varchar(255)
* comment : text
* manufacturers_id : int(10) unsigned
* devicenetworkcardmodels_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicepcimodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicepowersupplies
* id : int(10) unsigned
* designation : varchar(255)
* power : varchar(255)
* is_atx : tinyint(4)
* comment : text
* manufacturers_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicepowersupplymodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicepowersupplymodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_deviceprocessormodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_deviceprocessors
* id : int(10) unsigned
* designation : varchar(255)
* frequence : int(11)
* comment : text
* manufacturers_id : int(10) unsigned
* frequency_default : int(11)
* nbcores_default : int(11)
* nbthreads_default : int(11)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* deviceprocessormodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicesensormodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicesensors
* id : int(10) unsigned
* designation : varchar(255)
* devicesensortypes_id : int(10) unsigned
* devicesensormodels_id : int(10) unsigned
* comment : text
* manufacturers_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicesensortypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v gpli glpi_devicesimcards
* id : int(10) unsigned
* designation : varchar(255)
* comment : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* manufacturers_id : int(10) unsigned
* voltage : int(11)
* devicesimcardtypes_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
* allow_voip : tinyint(4)
v gpli glpi_devicesimcardtypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_devicesoundcardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v gpli glpi_devicesoundcards
* id : int(10) unsigned
* designation : varchar(255)
* type : varchar(255)
* comment : text
* manufacturers_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* devicesoundcardmodels_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_displaypreferences
* id : int(10) unsigned
* itemtype : varchar(100)
* num : int(11)
* rank : int(11)
* users_id : int(10) unsigned
v gpli glpi_documentcategories
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* documentcategories_id : int(10) unsigned
* completename : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_documents
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* filename : varchar(255)
* filepath : varchar(255)
* documentcategories_id : int(10) unsigned
* mime : varchar(255)
* date_mod : timestamp
* comment : text
* is_deleted : tinyint(4)
* users_id : int(10) unsigned
* tickets_id : int(10) unsigned
* sha1sum : char(40)
* is_blacklisted : tinyint(4)
* tag : varchar(255)
* date_creation : timestamp
v gpli glpi_documents_items
* id : int(10) unsigned
* documents_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* date_mod : timestamp
* users_id : int(10) unsigned
* timeline_position : tinyint(4)
* date_creation : timestamp
* date : timestamp
v gpli glpi_documenttypes
* id : int(10) unsigned
* name : varchar(255)
* ext : varchar(255)
* icon : varchar(255)
* mime : varchar(255)
* is_uploadable : tinyint(4)
* date_mod : timestamp
* comment : text
* date_creation : timestamp
v gpli glpi_domainrecords
* id : int(10) unsigned
* name : varchar(255)
* data : text
* data_obj : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* domains_id : int(10) unsigned
* domainrecordtypes_id : int(10) unsigned
* ttl : int(11)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_deleted : tinyint(4)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_domainrecordtypes
* id : int(10) unsigned
* name : varchar(255)
* fields : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v gpli glpi_domainrelations
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v gpli glpi_domains
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* domaintypes_id : int(10) unsigned
* date_expiration : timestamp
* date_domaincreation : timestamp
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_deleted : tinyint(4)
* comment : text
* is_template : tinyint(4)
* template_name : varchar(255)
* is_active : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_domains_items
* id : int(10) unsigned
* domains_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* domainrelations_id : int(10) unsigned
* is_dynamic : tinyint(4)
* is_deleted : tinyint(4)
v gpli glpi_domaintypes
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v gpli glpi_dropdowntranslations
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* language : varchar(10)
* field : varchar(100)
* value : text
v gpli glpi_enclosuremodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* weight : int(11)
* required_units : int(11)
* depth : float
* power_connections : int(11)
* power_consumption : int(11)
* is_half_rack : tinyint(4)
* picture_front : text
* picture_rear : text
* pictures : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_enclosures
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* locations_id : int(10) unsigned
* serial : varchar(255)
* otherserial : varchar(255)
* enclosuremodels_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_template : tinyint(4)
* template_name : varchar(255)
* is_deleted : tinyint(4)
* orientation : tinyint(4)
* power_supplies : tinyint(4)
* states_id : int(10) unsigned
* comment : text
* manufacturers_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_entities
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* completename : text
* comment : text
* level : int(11)
* sons_cache : longtext
* ancestors_cache : longtext
* registration_number : varchar(255)
* address : text
* postcode : varchar(255)
* town : varchar(255)
* state : varchar(255)
* country : varchar(255)
* website : varchar(255)
* phonenumber : varchar(255)
* fax : varchar(255)
* email : varchar(255)
* admin_email : varchar(255)
* admin_email_name : varchar(255)
* from_email : varchar(255)
* from_email_name : varchar(255)
* noreply_email : varchar(255)
* noreply_email_name : varchar(255)
* replyto_email : varchar(255)
* replyto_email_name : varchar(255)
* notification_subject_tag : varchar(255)
* ldap_dn : varchar(255)
* tag : varchar(255)
* authldaps_id : int(10) unsigned
* mail_domain : varchar(255)
* entity_ldapfilter : text
* mailing_signature : text
* 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) unsigned
* 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)
* autofill_warranty_date : varchar(255)
* autofill_use_date : varchar(255)
* autofill_buy_date : varchar(255)
* autofill_delivery_date : varchar(255)
* autofill_order_date : varchar(255)
* tickettemplates_strategy : tinyint(4)
* tickettemplates_id : int(10) unsigned
* changetemplates_strategy : tinyint(4)
* changetemplates_id : int(10) unsigned
* problemtemplates_strategy : tinyint(4)
* problemtemplates_id : int(10) unsigned
* entities_strategy_software : tinyint(4)
* entities_id_software : int(10) unsigned
* 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)
* 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) unsigned
* enable_custom_css : int(11)
* custom_css_code : text
* latitude : varchar(255)
* longitude : varchar(255)
* altitude : varchar(255)
* transfers_strategy : tinyint(4)
* transfers_id : int(10) unsigned
* agent_base_url : varchar(255)
v gpli glpi_entities_knowbaseitems
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v gpli glpi_entities_reminders
* id : int(10) unsigned
* reminders_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v gpli glpi_entities_rssfeeds
* id : int(10) unsigned
* rssfeeds_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v gpli glpi_events
* id : int(10) unsigned
* items_id : int(10) unsigned
* type : varchar(255)
* date : timestamp
* service : varchar(255)
* level : int(11)
* message : text
v gpli glpi_fieldblacklists
* id : int(10) unsigned
* name : varchar(255)
* field : varchar(255)
* value : varchar(255)
* itemtype : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_fieldunicities
* id : int(10) unsigned
* name : varchar(255)
* is_recursive : tinyint(4)
* itemtype : varchar(255)
* entities_id : int(10) unsigned
* fields : text
* is_active : tinyint(4)
* action_refuse : tinyint(4)
* action_notify : tinyint(4)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_filesystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_fqdns
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* fqdn : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_groups
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* ldap_field : varchar(255)
* ldap_value : text
* ldap_group_dn : text
* date_mod : timestamp
* groups_id : int(10) unsigned
* completename : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
* is_requester : tinyint(4)
* is_watcher : tinyint(4)
* is_assign : tinyint(4)
* is_task : tinyint(4)
* is_notify : tinyint(4)
* is_itemgroup : tinyint(4)
* is_usergroup : tinyint(4)
* is_manager : tinyint(4)
* date_creation : timestamp
v gpli glpi_groups_knowbaseitems
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* groups_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* no_entity_restriction : tinyint(4)
v gpli glpi_groups_problems
* id : int(10) unsigned
* problems_id : int(10) unsigned
* groups_id : int(10) unsigned
* type : int(11)
v gpli glpi_groups_reminders
* id : int(10) unsigned
* reminders_id : int(10) unsigned
* groups_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* no_entity_restriction : tinyint(4)
v gpli glpi_groups_rssfeeds
* id : int(10) unsigned
* rssfeeds_id : int(10) unsigned
* groups_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* no_entity_restriction : tinyint(4)
v gpli glpi_groups_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* groups_id : int(10) unsigned
* type : int(11)
v gpli glpi_groups_users
* id : int(10) unsigned
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* is_dynamic : tinyint(4)
* is_manager : tinyint(4)
* is_userdelegate : tinyint(4)
v gpli glpi_holidays
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
* begin_date : date
* end_date : date
* is_perpetual : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_imageformats
* id : int(10) unsigned
* name : varchar(255)
* date_mod : timestamp
* comment : text
* date_creation : timestamp
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v gpli glpi_imageresolutions
* id : int(10) unsigned
* name : varchar(255)
* is_video : tinyint(4)
* date_mod : timestamp
* comment : text
* date_creation : timestamp
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v gpli glpi_impactcompounds
* id : int(10) unsigned
* name : varchar(255)
* color : varchar(255)
v gpli glpi_impactcontexts
* id : int(10) unsigned
* positions : mediumtext
* zoom : float
* pan_x : float
* pan_y : float
* impact_color : varchar(255)
* depends_color : varchar(255)
* impact_and_depends_color : varchar(255)
* show_depends : tinyint(4)
* show_impact : tinyint(4)
* max_depth : int(11)
v gpli glpi_impactitems
* id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* parent_id : int(10) unsigned
* impactcontexts_id : int(10) unsigned
* is_slave : tinyint(4)
v gpli glpi_impactrelations
* id : int(10) unsigned
* itemtype_source : varchar(255)
* items_id_source : int(10) unsigned
* itemtype_impacted : varchar(255)
* items_id_impacted : int(10) unsigned
v gpli glpi_infocoms
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* buy_date : date
* use_date : date
* warranty_duration : int(11)
* warranty_info : varchar(255)
* suppliers_id : int(10) unsigned
* order_number : varchar(255)
* delivery_number : varchar(255)
* immo_number : varchar(255)
* value : decimal(20,4)
* warranty_value : decimal(20,4)
* sink_time : int(11)
* sink_type : int(11)
* sink_coeff : float
* comment : text
* bill : varchar(255)
* budgets_id : int(10) unsigned
* alert : int(11)
* order_date : date
* delivery_date : date
* inventory_date : date
* warranty_date : date
* date_mod : timestamp
* date_creation : timestamp
* decommission_date : timestamp
* businesscriticities_id : int(10) unsigned
v gpli glpi_interfacetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_ipaddresses
* id : int(10) unsigned
* entities_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* version : tinyint(3) unsigned
* name : varchar(255)
* binary_0 : int(10) unsigned
* binary_1 : int(10) unsigned
* binary_2 : int(10) unsigned
* binary_3 : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* mainitems_id : int(10) unsigned
* mainitemtype : varchar(255)
v gpli glpi_ipaddresses_ipnetworks
* id : int(10) unsigned
* ipaddresses_id : int(10) unsigned
* ipnetworks_id : int(10) unsigned
v gpli glpi_ipnetworks
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* ipnetworks_id : int(10) unsigned
* completename : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
* addressable : tinyint(4)
* version : tinyint(3) unsigned
* name : varchar(255)
* address : varchar(40)
* address_0 : int(10) unsigned
* address_1 : int(10) unsigned
* address_2 : int(10) unsigned
* address_3 : int(10) unsigned
* netmask : varchar(40)
* netmask_0 : int(10) unsigned
* netmask_1 : int(10) unsigned
* netmask_2 : int(10) unsigned
* netmask_3 : int(10) unsigned
* gateway : varchar(40)
* gateway_0 : int(10) unsigned
* gateway_1 : int(10) unsigned
* gateway_2 : int(10) unsigned
* gateway_3 : int(10) unsigned
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_ipnetworks_vlans
* id : int(10) unsigned
* ipnetworks_id : int(10) unsigned
* vlans_id : int(10) unsigned
v gpli glpi_items_clusters
* id : int(10) unsigned
* clusters_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v gpli glpi_items_devicebatteries
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicebatteries_id : int(10) unsigned
* manufacturing_date : date
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
* real_capacity : int(11)
v gpli glpi_items_devicecameras
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicecameras_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* locations_id : int(10) unsigned
v gpli glpi_items_devicecameras_imageformats
* id : int(10) unsigned
* items_devicecameras_id : int(10) unsigned
* imageformats_id : int(10) unsigned
* is_dynamic : tinyint(4)
* is_deleted : tinyint(4)
v gpli glpi_items_devicecameras_imageresolutions
* id : int(10) unsigned
* items_devicecameras_id : int(10) unsigned
* imageresolutions_id : int(10) unsigned
* is_dynamic : tinyint(4)
* is_deleted : tinyint(4)
v gpli glpi_items_devicecases
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicecases_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicecontrols
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicecontrols_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* busID : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicedrives
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicedrives_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* busID : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicefirmwares
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicefirmwares_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicegenerics
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicegenerics_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicegraphiccards
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicegraphiccards_id : int(10) unsigned
* memory : int(11)
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* busID : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_deviceharddrives
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* deviceharddrives_id : int(10) unsigned
* capacity : int(11)
* serial : varchar(255)
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* busID : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicememories
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicememories_id : int(10) unsigned
* size : int(11)
* serial : varchar(255)
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* busID : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicemotherboards
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicemotherboards_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicenetworkcards
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicenetworkcards_id : int(10) unsigned
* mac : varchar(255)
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* busID : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicepcis
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicepcis_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* busID : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicepowersupplies
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicepowersupplies_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_deviceprocessors
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* deviceprocessors_id : int(10) unsigned
* frequency : int(11)
* serial : varchar(255)
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* nbcores : int(11)
* nbthreads : int(11)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* busID : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicesensors
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicesensors_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_devicesimcards
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* devicesimcards_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* otherserial : varchar(255)
* states_id : int(10) unsigned
* locations_id : int(10) unsigned
* lines_id : int(10) unsigned
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* pin : varchar(255)
* pin2 : varchar(255)
* puk : varchar(255)
* puk2 : varchar(255)
* msin : varchar(255)
* comment : text
v gpli glpi_items_devicesoundcards
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicesoundcards_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* serial : varchar(255)
* busID : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
v gpli glpi_items_disks
* id : int(10) unsigned
* entities_id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* name : varchar(255)
* device : varchar(255)
* mountpoint : varchar(255)
* filesystems_id : int(10) unsigned
* totalsize : bigint(20)
* freesize : bigint(20)
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* encryption_status : int(11)
* encryption_tool : varchar(255)
* encryption_algorithm : varchar(255)
* encryption_type : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_items_enclosures
* id : int(10) unsigned
* enclosures_id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* position : int(11)
v gpli glpi_items_kanbans
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* users_id : int(10) unsigned
* state : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_items_operatingsystems
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* operatingsystems_id : int(10) unsigned
* operatingsystemversions_id : int(10) unsigned
* operatingsystemservicepacks_id : int(10) unsigned
* operatingsystemarchitectures_id : int(10) unsigned
* operatingsystemkernelversions_id : int(10) unsigned
* license_number : varchar(255)
* licenseid : varchar(255)
* operatingsystemeditions_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* install_date : date
* company : varchar(255)
* owner : varchar(255)
* hostid : varchar(255)
v gpli glpi_items_problems
* id : int(10) unsigned
* problems_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v gpli glpi_items_projects
* id : int(10) unsigned
* projects_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v gpli glpi_items_racks
* id : int(10) unsigned
* racks_id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* position : int(11)
* orientation : tinyint(4)
* bgcolor : varchar(7)
* hpos : tinyint(4)
* is_reserved : tinyint(4)
v gpli glpi_items_remotemanagements
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* remoteid : varchar(255)
* type : varchar(255)
* is_dynamic : tinyint(4)
* is_deleted : tinyint(4)
v gpli glpi_items_softwarelicenses
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* softwarelicenses_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
v gpli glpi_items_softwareversions
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* softwareversions_id : int(10) unsigned
* is_deleted_item : tinyint(4)
* is_template_item : tinyint(4)
* entities_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* date_install : date
v gpli glpi_items_tickets
* id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* tickets_id : int(10) unsigned
v gpli glpi_itilcategories
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* itilcategories_id : int(10) unsigned
* name : varchar(255)
* completename : text
* comment : text
* level : int(11)
* knowbaseitemcategories_id : int(10) unsigned
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* code : varchar(255)
* ancestors_cache : longtext
* sons_cache : longtext
* is_helpdeskvisible : tinyint(4)
* tickettemplates_id_incident : int(10) unsigned
* tickettemplates_id_demand : int(10) unsigned
* changetemplates_id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* is_incident : int(11)
* is_request : int(11)
* is_problem : int(11)
* is_change : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_itilfollowups
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* date : timestamp
* users_id : int(10) unsigned
* users_id_editor : int(10) unsigned
* content : longtext
* is_private : tinyint(4)
* requesttypes_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
* timeline_position : tinyint(4)
* sourceitems_id : int(10) unsigned
* sourceof_items_id : int(10) unsigned
v gpli glpi_itilfollowuptemplates
* id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* content : mediumtext
* requesttypes_id : int(10) unsigned
* is_private : tinyint(4)
* comment : text
v gpli glpi_itilsolutions
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* solutiontypes_id : int(10) unsigned
* solutiontype_name : varchar(255)
* content : longtext
* date_creation : timestamp
* date_mod : timestamp
* date_approval : timestamp
* users_id : int(10) unsigned
* user_name : varchar(255)
* users_id_editor : int(10) unsigned
* users_id_approval : int(10) unsigned
* user_name_approval : varchar(255)
* status : int(11)
* itilfollowups_id : int(10) unsigned
v gpli glpi_itils_projects
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* projects_id : int(10) unsigned
v gpli glpi_knowbaseitemcategories
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* knowbaseitemcategories_id : int(10) unsigned
* name : varchar(255)
* completename : text
* comment : text
* level : int(11)
* sons_cache : longtext
* ancestors_cache : longtext
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_knowbaseitems
* id : int(10) unsigned
* name : text
* answer : longtext
* is_faq : tinyint(4)
* users_id : int(10) unsigned
* view : int(11)
* date_creation : timestamp
* date_mod : timestamp
* begin_date : timestamp
* end_date : timestamp
v gpli glpi_knowbaseitems_comments
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* users_id : int(10) unsigned
* language : varchar(10)
* comment : text
* parent_comment_id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_knowbaseitems_items
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_knowbaseitems_knowbaseitemcategories
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* knowbaseitemcategories_id : int(10) unsigned
v gpli glpi_knowbaseitems_profiles
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* profiles_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* no_entity_restriction : tinyint(4)
v gpli glpi_knowbaseitems_revisions
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* revision : int(11)
* name : text
* answer : longtext
* language : varchar(10)
* users_id : int(10) unsigned
* date : timestamp
v gpli glpi_knowbaseitems_users
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* users_id : int(10) unsigned
v gpli glpi_knowbaseitemtranslations
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* language : varchar(10)
* name : text
* answer : longtext
* users_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_lineoperators
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* mcc : int(11)
* mnc : int(11)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_lines
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* is_deleted : tinyint(4)
* caller_num : varchar(255)
* caller_name : varchar(255)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* lineoperators_id : int(10) unsigned
* locations_id : int(10) unsigned
* states_id : int(10) unsigned
* linetypes_id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
* comment : text
v gpli glpi_linetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_locations
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* locations_id : int(10) unsigned
* completename : text
* comment : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
* address : text
* postcode : varchar(255)
* town : varchar(255)
* state : varchar(255)
* country : varchar(255)
* building : varchar(255)
* room : varchar(255)
* latitude : varchar(255)
* longitude : varchar(255)
* altitude : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_lockedfields
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* field : varchar(50)
* value : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* is_global : tinyint(4)
v gpli glpi_logs
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* linked_action : int(11)
* user_name : varchar(255)
* date_mod : timestamp
* id_search_option : int(11)
* old_value : varchar(255)
* new_value : varchar(255)
v gpli glpi_mailcollectors
* id : int(10) unsigned
* name : varchar(255)
* host : varchar(255)
* login : varchar(255)
* filesize_max : int(11)
* is_active : tinyint(4)
* date_mod : timestamp
* comment : text
* passwd : varchar(255)
* accepted : varchar(255)
* refused : varchar(255)
* errors : int(11)
* use_mail_date : tinyint(4)
* date_creation : timestamp
* requester_field : int(11)
* add_cc_to_observer : tinyint(4)
* collect_only_unread : tinyint(4)
* last_collect_date : timestamp
v gpli glpi_manufacturers
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_monitormodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* weight : int(11)
* required_units : int(11)
* depth : float
* power_connections : int(11)
* power_consumption : int(11)
* is_half_rack : tinyint(4)
* picture_front : text
* picture_rear : text
* pictures : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_monitors
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* date_mod : timestamp
* contact : varchar(255)
* contact_num : varchar(255)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* comment : text
* serial : varchar(255)
* otherserial : varchar(255)
* size : decimal(5,2)
* have_micro : tinyint(4)
* have_speaker : tinyint(4)
* have_subd : tinyint(4)
* have_bnc : tinyint(4)
* have_dvi : tinyint(4)
* have_pivot : tinyint(4)
* have_hdmi : tinyint(4)
* have_displayport : tinyint(4)
* locations_id : int(10) unsigned
* monitortypes_id : int(10) unsigned
* monitormodels_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* is_global : tinyint(4)
* is_deleted : tinyint(4)
* is_template : tinyint(4)
* template_name : varchar(255)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* states_id : int(10) unsigned
* ticket_tco : decimal(20,4)
* is_dynamic : tinyint(4)
* autoupdatesystems_id : int(10) unsigned
* uuid : varchar(255)
* date_creation : timestamp
* is_recursive : tinyint(4)
v gpli glpi_monitortypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkaliases
* id : int(10) unsigned
* entities_id : int(10) unsigned
* networknames_id : int(10) unsigned
* name : varchar(255)
* fqdns_id : int(10) unsigned
* comment : text
v gpli glpi_networkequipmentmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* weight : int(11)
* required_units : int(11)
* depth : float
* power_connections : int(11)
* power_consumption : int(11)
* is_half_rack : tinyint(4)
* picture_front : text
* picture_rear : text
* pictures : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkequipments
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* ram : int(10) unsigned
* serial : varchar(255)
* otherserial : varchar(255)
* contact : varchar(255)
* contact_num : varchar(255)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* date_mod : timestamp
* comment : text
* locations_id : int(10) unsigned
* networks_id : int(10) unsigned
* networkequipmenttypes_id : int(10) unsigned
* networkequipmentmodels_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_template : tinyint(4)
* template_name : varchar(255)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* states_id : int(10) unsigned
* ticket_tco : decimal(20,4)
* is_dynamic : tinyint(4)
* uuid : varchar(255)
* date_creation : timestamp
* autoupdatesystems_id : int(10) unsigned
* sysdescr : text
* cpu : int(11)
* uptime : varchar(255)
* last_inventory_update : timestamp
* snmpcredentials_id : int(10) unsigned
v gpli glpi_networkequipmenttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkinterfaces
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v gpli glpi_networknames
* id : int(10) unsigned
* entities_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* name : varchar(255)
* comment : text
* fqdns_id : int(10) unsigned
* ipnetworks_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkportaggregates
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* networkports_id_list : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkportaliases
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* networkports_id_alias : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkportconnectionlogs
* id : int(10) unsigned
* date : timestamp
* connected : tinyint(4)
* networkports_id_source : int(10) unsigned
* networkports_id_destination : int(10) unsigned
v gpli glpi_networkportdialups
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkportethernets
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* items_devicenetworkcards_id : int(10) unsigned
* type : varchar(10)
* speed : int(11)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkportfiberchannels
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* items_devicenetworkcards_id : int(10) unsigned
* networkportfiberchanneltypes_id : int(10) unsigned
* wwn : varchar(50)
* speed : int(11)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkportfiberchanneltypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkportlocals
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networkportmetrics
* id : int(10) unsigned
* date : date
* ifinbytes : bigint(20)
* ifinerrors : bigint(20)
* ifoutbytes : bigint(20)
* ifouterrors : bigint(20)
* networkports_id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_networkports
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* logical_number : int(11)
* name : varchar(255)
* instantiation_type : varchar(255)
* mac : varchar(255)
* comment : text
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
* ifmtu : int(11)
* ifspeed : bigint(20)
* ifinternalstatus : varchar(255)
* ifconnectionstatus : int(11)
* iflastchange : varchar(255)
* ifinbytes : bigint(20)
* ifinerrors : bigint(20)
* ifoutbytes : bigint(20)
* ifouterrors : bigint(20)
* ifstatus : varchar(255)
* ifdescr : varchar(255)
* ifalias : varchar(255)
* portduplex : varchar(255)
* trunk : tinyint(4)
* lastup : timestamp
v gpli glpi_networkports_networkports
* id : int(10) unsigned
* networkports_id_1 : int(10) unsigned
* networkports_id_2 : int(10) unsigned
v gpli glpi_networkports_vlans
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* vlans_id : int(10) unsigned
* tagged : tinyint(4)
v gpli glpi_networkporttypes
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* value_decimal : int(11)
* name : varchar(255)
* comment : text
* is_importable : tinyint(4)
* instantiation_type : varchar(255)
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_networkportwifis
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* items_devicenetworkcards_id : int(10) unsigned
* wifinetworks_id : int(10) unsigned
* networkportwifis_id : int(10) unsigned
* version : varchar(20)
* mode : varchar(20)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_networks
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_notepads
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
* users_id : int(10) unsigned
* users_id_lastupdater : int(10) unsigned
* content : longtext
v gpli glpi_notifications
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* itemtype : varchar(100)
* event : varchar(255)
* comment : text
* is_recursive : tinyint(4)
* is_active : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
* allow_response : tinyint(4)
v gpli glpi_notifications_notificationtemplates
* id : int(10) unsigned
* notifications_id : int(10) unsigned
* mode : varchar(20)
* notificationtemplates_id : int(10) unsigned
v gpli glpi_notificationtargets
* id : int(10) unsigned
* items_id : int(10) unsigned
* type : int(11)
* notifications_id : int(10) unsigned
v gpli glpi_notificationtemplates
* id : int(10) unsigned
* name : varchar(255)
* itemtype : varchar(100)
* date_mod : timestamp
* comment : text
* css : text
* date_creation : timestamp
v gpli glpi_notificationtemplatetranslations
* id : int(10) unsigned
* notificationtemplates_id : int(10) unsigned
* language : varchar(10)
* subject : varchar(255)
* content_text : text
* content_html : text
v gpli glpi_notimportedemails
* id : int(10) unsigned
* from : varchar(255)
* to : varchar(255)
* mailcollectors_id : int(10) unsigned
* date : timestamp
* subject : text
* messageid : varchar(255)
* reason : int(11)
* users_id : int(10) unsigned
v gpli glpi_objectlocks
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* users_id : int(10) unsigned
* date : timestamp
v gpli glpi_olalevelactions
* id : int(10) unsigned
* olalevels_id : int(10) unsigned
* action_type : varchar(255)
* field : varchar(255)
* value : varchar(255)
v gpli glpi_olalevelcriterias
* id : int(10) unsigned
* olalevels_id : int(10) unsigned
* criteria : varchar(255)
* condition : int(11)
* pattern : varchar(255)
v gpli glpi_olalevels
* id : int(10) unsigned
* name : varchar(255)
* olas_id : int(10) unsigned
* execution_time : int(11)
* is_active : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* match : char(10)
* uuid : varchar(255)
v gpli glpi_olalevels_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* olalevels_id : int(10) unsigned
* date : timestamp
v gpli glpi_olas
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* type : int(11)
* comment : text
* number_time : int(11)
* use_ticket_calendar : tinyint(4)
* calendars_id : int(10) unsigned
* date_mod : timestamp
* definition_time : varchar(255)
* end_of_working_day : tinyint(4)
* date_creation : timestamp
* slms_id : int(10) unsigned
v gpli glpi_operatingsystemarchitectures
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_operatingsystemeditions
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_operatingsystemkernels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_operatingsystemkernelversions
* id : int(10) unsigned
* operatingsystemkernels_id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_operatingsystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_operatingsystemservicepacks
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_operatingsystemversions
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_passivedcequipmentmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* weight : int(11)
* required_units : int(11)
* depth : float
* power_connections : int(11)
* power_consumption : int(11)
* is_half_rack : tinyint(4)
* picture_front : text
* picture_rear : text
* pictures : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_passivedcequipments
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* locations_id : int(10) unsigned
* serial : varchar(255)
* otherserial : varchar(255)
* passivedcequipmentmodels_id : int(10) unsigned
* passivedcequipmenttypes_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_template : tinyint(4)
* template_name : varchar(255)
* is_deleted : tinyint(4)
* states_id : int(10) unsigned
* comment : text
* manufacturers_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_passivedcequipmenttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_pcivendors
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* vendorid : varchar(4)
* deviceid : varchar(4)
* name : varchar(255)
* comment : text
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_pdumodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* weight : int(11)
* required_units : int(11)
* depth : float
* power_connections : int(11)
* max_power : int(11)
* is_half_rack : tinyint(4)
* picture_front : text
* picture_rear : text
* pictures : text
* is_rackable : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_pdus
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* locations_id : int(10) unsigned
* serial : varchar(255)
* otherserial : varchar(255)
* pdumodels_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_template : tinyint(4)
* template_name : varchar(255)
* is_deleted : tinyint(4)
* states_id : int(10) unsigned
* comment : text
* manufacturers_id : int(10) unsigned
* pdutypes_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_pdus_plugs
* id : int(10) unsigned
* plugs_id : int(10) unsigned
* pdus_id : int(10) unsigned
* number_plugs : int(11)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_pdus_racks
* id : int(10) unsigned
* racks_id : int(10) unsigned
* pdus_id : int(10) unsigned
* side : int(11)
* position : int(11)
* bgcolor : varchar(7)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_pdutypes
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_pendingreasons
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* followup_frequency : int(11)
* followups_before_resolution : int(11)
* itilfollowuptemplates_id : int(10) unsigned
* solutiontemplates_id : int(10) unsigned
* comment : text
v gpli glpi_pendingreasons_items
* id : int(10) unsigned
* pendingreasons_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* followup_frequency : int(11)
* followups_before_resolution : int(11)
* bump_count : int(11)
* last_bump_date : timestamp
* previous_status : int(11)
v gpli glpi_peripheralmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* weight : int(11)
* required_units : int(11)
* depth : float
* power_connections : int(11)
* power_consumption : int(11)
* is_half_rack : tinyint(4)
* picture_front : text
* picture_rear : text
* pictures : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_peripherals
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* date_mod : timestamp
* contact : varchar(255)
* contact_num : varchar(255)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* comment : text
* serial : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* peripheraltypes_id : int(10) unsigned
* peripheralmodels_id : int(10) unsigned
* brand : varchar(255)
* manufacturers_id : int(10) unsigned
* is_global : tinyint(4)
* is_deleted : tinyint(4)
* is_template : tinyint(4)
* template_name : varchar(255)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* states_id : int(10) unsigned
* ticket_tco : decimal(20,4)
* is_dynamic : tinyint(4)
* autoupdatesystems_id : int(10) unsigned
* uuid : varchar(255)
* date_creation : timestamp
* is_recursive : tinyint(4)
v gpli glpi_peripheraltypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_phonemodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* picture_front : text
* picture_rear : text
* pictures : text
v gpli glpi_phonepowersupplies
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_phones
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* date_mod : timestamp
* contact : varchar(255)
* contact_num : varchar(255)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* comment : text
* serial : varchar(255)
* otherserial : varchar(255)
* locations_id : int(10) unsigned
* phonetypes_id : int(10) unsigned
* phonemodels_id : int(10) unsigned
* brand : varchar(255)
* phonepowersupplies_id : int(10) unsigned
* number_line : varchar(255)
* have_headset : tinyint(4)
* have_hp : tinyint(4)
* manufacturers_id : int(10) unsigned
* is_global : tinyint(4)
* is_deleted : tinyint(4)
* is_template : tinyint(4)
* template_name : varchar(255)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* states_id : int(10) unsigned
* ticket_tco : decimal(20,4)
* is_dynamic : tinyint(4)
* autoupdatesystems_id : int(10) unsigned
* uuid : varchar(255)
* date_creation : timestamp
* is_recursive : tinyint(4)
* last_inventory_update : timestamp
v gpli glpi_phonetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_planningeventcategories
* id : int(10) unsigned
* name : varchar(255)
* color : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_planningexternalevents
* id : int(10) unsigned
* uuid : varchar(255)
* planningexternaleventtemplates_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* date : timestamp
* users_id : int(10) unsigned
* users_id_guests : text
* groups_id : int(10) unsigned
* name : varchar(255)
* text : text
* begin : timestamp
* end : timestamp
* rrule : text
* state : int(11)
* planningeventcategories_id : int(10) unsigned
* background : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_planningexternaleventtemplates
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* text : mediumtext
* comment : text
* duration : int(11)
* before_time : int(11)
* rrule : text
* state : int(11)
* planningeventcategories_id : int(10) unsigned
* background : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_planningrecalls
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* users_id : int(10) unsigned
* before_time : int(11)
* when : timestamp
v gpli glpi_plugins
* id : int(10) unsigned
* directory : varchar(255)
* name : varchar(255)
* version : varchar(255)
* state : int(11)
* author : varchar(255)
* homepage : varchar(255)
* license : varchar(255)
v gpli glpi_plugin_formcreator_answers
* id : int(10) unsigned
* plugin_formcreator_formanswers_id : int(10) unsigned
* plugin_formcreator_questions_id : int(10) unsigned
* answer : longtext
v gpli glpi_plugin_formcreator_categories
* id : int(10) unsigned
* name : varchar(255)
* comment : mediumtext
* completename : varchar(255)
* plugin_formcreator_categories_id : int(10) unsigned
* level : int(11)
* sons_cache : longtext
* ancestors_cache : longtext
* knowbaseitemcategories_id : int(10) unsigned
v gpli glpi_plugin_formcreator_conditions
* id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* plugin_formcreator_questions_id : int(10) unsigned
* show_condition : int(11)
* show_value : mediumtext
* show_logic : int(11)
* order : int(11)
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_entityconfigs
* id : int(10) unsigned
* entities_id : int(10) unsigned
* replace_helpdesk : int(11)
* default_form_list_mode : int(11)
* sort_order : int(11)
* is_kb_separated : int(11)
* is_search_visible : int(11)
* is_dashboard_visible : int(11)
* is_header_visible : int(11)
* is_search_issue_visible : int(11)
* tile_design : int(11)
* header : text
* service_catalog_home : int(11)
v gpli glpi_plugin_formcreator_formanswers
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* plugin_formcreator_forms_id : int(10) unsigned
* requester_id : int(10) unsigned
* users_id_validator : int(10) unsigned
* groups_id_validator : int(10) unsigned
* request_date : timestamp
* status : int(11)
* comment : mediumtext
v gpli glpi_plugin_formcreator_forms
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* icon : varchar(255)
* icon_color : varchar(255)
* background_color : varchar(255)
* access_rights : tinyint(1)
* description : varchar(255)
* content : longtext
* plugin_formcreator_categories_id : int(10) unsigned
* is_active : tinyint(1)
* language : varchar(255)
* helpdesk_home : tinyint(1)
* is_deleted : tinyint(1)
* validation_required : tinyint(1)
* usage_count : int(11)
* is_default : tinyint(1)
* is_captcha_enabled : tinyint(1)
* show_rule : int(11)
* formanswer_name : varchar(255)
* is_visible : tinyint(4)
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_forms_groups
* id : int(10) unsigned
* plugin_formcreator_forms_id : int(10) unsigned
* groups_id : int(10) unsigned
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_forms_languages
* id : int(10) unsigned
* plugin_formcreator_forms_id : int(10) unsigned
* name : varchar(255)
* comment : text
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_forms_profiles
* id : int(10) unsigned
* plugin_formcreator_forms_id : int(10) unsigned
* profiles_id : int(10) unsigned
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_forms_users
* id : int(10) unsigned
* plugin_formcreator_forms_id : int(10) unsigned
* users_id : int(10) unsigned
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_forms_validators
* id : int(10) unsigned
* plugin_formcreator_forms_id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_issues
* id : int(10) unsigned
* name : varchar(255)
* display_id : varchar(255)
* items_id : int(10) unsigned
* itemtype : varchar(255)
* status : varchar(255)
* date_creation : timestamp
* date_mod : timestamp
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* requester_id : int(10) unsigned
* comment : longtext
* users_id_recipient : int(10) unsigned
v gpli glpi_plugin_formcreator_items_targettickets
* id : int(10) unsigned
* plugin_formcreator_targettickets_id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_questiondependencies
* id : int(10) unsigned
* plugin_formcreator_questions_id : int(10) unsigned
* plugin_formcreator_questions_id_2 : int(10) unsigned
* fieldname : varchar(255)
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_questionranges
* id : int(10) unsigned
* plugin_formcreator_questions_id : int(10) unsigned
* range_min : varchar(255)
* range_max : varchar(255)
* fieldname : varchar(255)
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_questionregexes
* id : int(10) unsigned
* plugin_formcreator_questions_id : int(10) unsigned
* regex : mediumtext
* fieldname : varchar(255)
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_questions
* id : int(10) unsigned
* name : varchar(255)
* plugin_formcreator_sections_id : int(10) unsigned
* fieldtype : varchar(30)
* required : tinyint(1)
* show_empty : tinyint(1)
* default_values : mediumtext
* itemtype : varchar(255)
* values : mediumtext
* description : mediumtext
* row : int(11)
* col : int(11)
* width : int(11)
* show_rule : int(11)
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_sections
* id : int(10) unsigned
* name : varchar(255)
* plugin_formcreator_forms_id : int(10) unsigned
* order : int(11)
* show_rule : int(11)
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_targetchanges
* id : int(10) unsigned
* name : varchar(255)
* plugin_formcreator_forms_id : int(10) unsigned
* target_name : varchar(255)
* changetemplates_id : int(10) unsigned
* content : longtext
* impactcontent : longtext
* controlistcontent : longtext
* rolloutplancontent : longtext
* backoutplancontent : longtext
* checklistcontent : longtext
* due_date_rule : int(11)
* due_date_question : int(10) unsigned
* due_date_value : tinyint(4)
* due_date_period : int(11)
* urgency_rule : int(11)
* urgency_question : int(10) unsigned
* validation_followup : tinyint(1)
* destination_entity : int(11)
* destination_entity_value : int(10) unsigned
* tag_type : int(11)
* tag_questions : varchar(255)
* tag_specifics : varchar(255)
* category_rule : int(11)
* category_question : int(10) unsigned
* commonitil_validation_rule : int(11)
* commonitil_validation_question : varchar(255)
* show_rule : int(11)
* sla_rule : int(11)
* sla_question_tto : int(10) unsigned
* sla_question_ttr : int(10) unsigned
* ola_rule : int(11)
* ola_question_tto : int(10) unsigned
* ola_question_ttr : int(10) unsigned
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_targetproblems
* id : int(10) unsigned
* name : varchar(255)
* plugin_formcreator_forms_id : int(10) unsigned
* target_name : varchar(255)
* problemtemplates_id : int(10) unsigned
* content : longtext
* impactcontent : longtext
* causecontent : longtext
* symptomcontent : longtext
* urgency_rule : int(11)
* urgency_question : int(10) unsigned
* destination_entity : int(11)
* destination_entity_value : int(10) unsigned
* tag_type : int(11)
* tag_questions : varchar(255)
* tag_specifics : varchar(255)
* category_rule : int(11)
* category_question : int(10) unsigned
* show_rule : int(11)
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_targets_actors
* id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* actor_role : int(11)
* actor_type : int(11)
* actor_value : int(10) unsigned
* use_notification : tinyint(1)
* uuid : varchar(255)
v gpli glpi_plugin_formcreator_targettickets
* id : int(10) unsigned
* name : varchar(255)
* plugin_formcreator_forms_id : int(10) unsigned
* target_name : varchar(255)
* source_rule : int(11)
* source_question : int(11)
* type_rule : int(11)
* type_question : int(10) unsigned
* tickettemplates_id : int(10) unsigned
* content : longtext
* due_date_rule : int(11)
* due_date_question : int(10) unsigned
* due_date_value : tinyint(4)
* due_date_period : int(11)
* urgency_rule : int(11)
* urgency_question : int(10) unsigned
* validation_followup : tinyint(1)
* destination_entity : int(11)
* destination_entity_value : int(10) unsigned
* tag_type : int(11)
* tag_questions : varchar(255)
* tag_specifics : varchar(255)
* category_rule : int(11)
* category_question : int(10) unsigned
* associate_rule : int(11)
* associate_question : int(10) unsigned
* location_rule : int(11)
* location_question : int(10) unsigned
* commonitil_validation_rule : int(11)
* commonitil_validation_question : varchar(255)
* show_rule : int(11)
* sla_rule : int(11)
* sla_question_tto : int(10) unsigned
* sla_question_ttr : int(10) unsigned
* ola_rule : int(11)
* ola_question_tto : int(10) unsigned
* ola_question_ttr : int(10) unsigned
* uuid : varchar(255)
v gpli glpi_plugin_fusioninventory_agentmodules
* id : int(10) unsigned
* modulename : varchar(255)
* is_active : tinyint(1)
* exceptions : text
v gpli glpi_plugin_fusioninventory_agents
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* name : varchar(255)
* last_contact : timestamp
* version : varchar(255)
* lock : tinyint(1)
* device_id : varchar(255)
* computers_id : int(10) unsigned
* token : varchar(255)
* useragent : varchar(255)
* tag : varchar(255)
* threads_networkdiscovery : int(10) unsigned
* threads_networkinventory : int(10) unsigned
* senddico : tinyint(1)
* timeout_networkdiscovery : int(10) unsigned
* timeout_networkinventory : int(10) unsigned
* agent_port : smallint(5) unsigned
v gpli glpi_plugin_fusioninventory_collects
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* type : varchar(255)
* is_active : tinyint(1)
* comment : text
v gpli glpi_plugin_fusioninventory_collects_files
* id : int(10) unsigned
* name : varchar(255)
* plugin_fusioninventory_collects_id : int(10) unsigned
* dir : varchar(255)
* limit : int(10) unsigned
* is_recursive : tinyint(1)
* filter_regex : varchar(255)
* filter_sizeequals : int(10) unsigned
* filter_sizegreater : int(10) unsigned
* filter_sizelower : int(10) unsigned
* filter_checksumsha512 : varchar(255)
* filter_checksumsha2 : varchar(255)
* filter_name : varchar(255)
* filter_iname : varchar(255)
* filter_is_file : tinyint(1)
* filter_is_dir : tinyint(1)
v gpli glpi_plugin_fusioninventory_collects_files_contents
* id : int(10) unsigned
* computers_id : int(10) unsigned
* plugin_fusioninventory_collects_files_id : int(10) unsigned
* pathfile : text
* size : int(10) unsigned
v gpli glpi_plugin_fusioninventory_collects_registries
* id : int(10) unsigned
* name : varchar(255)
* plugin_fusioninventory_collects_id : int(10) unsigned
* hive : varchar(255)
* path : text
* key : varchar(255)
v gpli glpi_plugin_fusioninventory_collects_registries_contents
* id : int(10) unsigned
* computers_id : int(10) unsigned
* plugin_fusioninventory_collects_registries_id : int(10) unsigned
* key : varchar(255)
* value : varchar(255)
v gpli glpi_plugin_fusioninventory_collects_wmis
* id : int(10) unsigned
* name : varchar(255)
* plugin_fusioninventory_collects_id : int(10) unsigned
* moniker : varchar(255)
* class : varchar(255)
* properties : varchar(255)
v gpli glpi_plugin_fusioninventory_collects_wmis_contents
* id : int(10) unsigned
* computers_id : int(10) unsigned
* plugin_fusioninventory_collects_wmis_id : int(10) unsigned
* property : varchar(255)
* value : varchar(255)
v gpli glpi_plugin_fusioninventory_computerlicenseinfos
* id : int(10) unsigned
* computers_id : int(10) unsigned
* softwarelicenses_id : int(10) unsigned
* name : varchar(255)
* fullname : varchar(255)
* serial : varchar(255)
* is_trial : tinyint(1)
* is_update : tinyint(1)
* is_oem : tinyint(1)
* activation_date : timestamp
v gpli glpi_plugin_fusioninventory_computerremotemanagements
* id : int(10) unsigned
* computers_id : int(10) unsigned
* number : varchar(255)
* type : varchar(255)
v gpli glpi_plugin_fusioninventory_configlogfields
* id : int(10) unsigned
* plugin_fusioninventory_mappings_id : int(10) unsigned
* days : smallint(6)
v gpli glpi_plugin_fusioninventory_configs
* id : int(10) unsigned
* type : varchar(255)
* value : varchar(255)
v gpli glpi_plugin_fusioninventory_configsecurities
* id : int(10) unsigned
* name : varchar(64)
* snmpversion : varchar(8)
* community : varchar(255)
* username : varchar(255)
* authentication : varchar(255)
* auth_passphrase : varchar(255)
* encryption : varchar(255)
* priv_passphrase : varchar(255)
* is_deleted : tinyint(1)
v gpli glpi_plugin_fusioninventory_credentialips
* id : int(10) unsigned
* entities_id : int(10) unsigned
* plugin_fusioninventory_credentials_id : int(10) unsigned
* name : varchar(255)
* comment : text
* ip : varchar(255)
* date_mod : timestamp
v gpli glpi_plugin_fusioninventory_credentials
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* name : varchar(255)
* username : varchar(255)
* password : varchar(255)
* comment : text
* date_mod : timestamp
* itemtype : varchar(255)
v gpli glpi_plugin_fusioninventory_crontasks
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* command : text
* execution_year : varchar(255)
* execution_month : varchar(255)
* execution_day : varchar(255)
* execution_hour : varchar(255)
* execution_minute : varchar(255)
* execution_weekday : varchar(255)
* user_id_execution : int(10) unsigned
* user_execution : varchar(100)
* storage : varchar(100)
* user_id_storage : int(10) unsigned
* user_storage : varchar(100)
* status : tinyint(1)
* computers_id : int(10) unsigned
* creation_date : timestamp
v gpli glpi_plugin_fusioninventory_dblockinventories
* value : int(10) unsigned
* date : timestamp
v gpli glpi_plugin_fusioninventory_dblockinventorynames
* value : varchar(100)
* date : timestamp
v gpli glpi_plugin_fusioninventory_dblocksoftwares
* value : tinyint(1)
* date : timestamp
v gpli glpi_plugin_fusioninventory_dblocksoftwareversions
* value : tinyint(1)
* date : timestamp
v gpli glpi_plugin_fusioninventory_deployfiles
* id : int(10) unsigned
* name : varchar(255)
* mimetype : varchar(255)
* filesize : bigint(20)
* comment : text
* sha512 : char(128)
* shortsha512 : char(6)
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* date_mod : timestamp
v gpli glpi_plugin_fusioninventory_deploygroups
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* type : varchar(255)
v gpli glpi_plugin_fusioninventory_deploygroups_dynamicdatas
* id : int(10) unsigned
* plugin_fusioninventory_deploygroups_id : int(10) unsigned
* fields_array : text
* can_update_group : tinyint(1)
* computers_id_cache : longtext
v gpli glpi_plugin_fusioninventory_deploygroups_staticdatas
* id : int(10) unsigned
* plugin_fusioninventory_deploygroups_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v gpli glpi_plugin_fusioninventory_deploymirrors
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_active : tinyint(1)
* is_recursive : tinyint(1)
* name : varchar(255)
* url : varchar(255)
* locations_id : int(10) unsigned
* comment : text
* date_mod : timestamp
v gpli glpi_plugin_fusioninventory_deploypackages
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* date_mod : timestamp
* uuid : varchar(255)
* json : longtext
* icon : varchar(255)
* style : varchar(10)
* plugin_fusioninventory_deploygroups_id : int(10) unsigned
v gpli glpi_plugin_fusioninventory_deploypackages_entities
* id : int(10) unsigned
* plugin_fusioninventory_deploypackages_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
v gpli glpi_plugin_fusioninventory_deploypackages_groups
* id : int(10) unsigned
* plugin_fusioninventory_deploypackages_id : int(10) unsigned
* groups_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
v gpli glpi_plugin_fusioninventory_deploypackages_profiles
* id : int(10) unsigned
* plugin_fusioninventory_deploypackages_id : int(10) unsigned
* profiles_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
v gpli glpi_plugin_fusioninventory_deploypackages_users
* id : int(10) unsigned
* plugin_fusioninventory_deploypackages_id : int(10) unsigned
* users_id : int(10) unsigned
v gpli glpi_plugin_fusioninventory_deployuserinteractiontemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* date_creation : timestamp
* date_mod : timestamp
* json : longtext
v gpli glpi_plugin_fusioninventory_entities
* id : int(10) unsigned
* entities_id : int(10) unsigned
* transfers_id_auto : int(10) unsigned
* agent_base_url : varchar(255)
v gpli glpi_plugin_fusioninventory_ignoredimportdevices
* id : int(10) unsigned
* name : varchar(255)
* date : timestamp
* itemtype : varchar(100)
* entities_id : int(10) unsigned
* ip : varchar(255)
* mac : varchar(255)
* rules_id : int(10) unsigned
* method : varchar(255)
* serial : varchar(255)
* uuid : varchar(255)
* plugin_fusioninventory_agents_id : int(10) unsigned
v gpli glpi_plugin_fusioninventory_inventorycomputerblacklists
* id : int(10) unsigned
* plugin_fusioninventory_criterium_id : int(10) unsigned
* value : varchar(255)
v gpli glpi_plugin_fusioninventory_inventorycomputercomputers
* id : int(10) unsigned
* computers_id : int(10) unsigned
* operatingsystem_installationdate : timestamp
* winowner : varchar(255)
* wincompany : varchar(255)
* last_fusioninventory_update : timestamp
* remote_addr : varchar(255)
* serialized_inventory : longblob
* is_entitylocked : tinyint(1)
* oscomment : text
* hostid : varchar(255)
* last_boot : timestamp
v gpli glpi_plugin_fusioninventory_inventorycomputercriterias
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v gpli glpi_plugin_fusioninventory_inventorycomputerstats
* id : smallint(5) unsigned
* day : smallint(3)
* hour : tinyint(2)
* counter : int(10) unsigned
v gpli glpi_plugin_fusioninventory_ipranges
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* ip_start : varchar(255)
* ip_end : varchar(255)
v gpli glpi_plugin_fusioninventory_ipranges_configsecurities
* id : int(10) unsigned
* plugin_fusioninventory_ipranges_id : int(10) unsigned
* plugin_fusioninventory_configsecurities_id : int(10) unsigned
* rank : int(10) unsigned
v gpli glpi_plugin_fusioninventory_locks
* id : int(10) unsigned
* tablename : varchar(64)
* items_id : int(10) unsigned
* tablefields : text
v gpli glpi_plugin_fusioninventory_mappings
* id : int(10) unsigned
* itemtype : varchar(100)
* name : varchar(255)
* table : varchar(255)
* tablefield : varchar(255)
* locale : int(10) unsigned
* shortlocale : int(10) unsigned
v gpli glpi_plugin_fusioninventory_networkequipments
* id : int(10) unsigned
* networkequipments_id : int(10) unsigned
* sysdescr : text
* plugin_fusioninventory_configsecurities_id : int(10) unsigned
* uptime : varchar(255)
* cpu : int(10) unsigned
* memory : int(10) unsigned
* last_fusioninventory_update : timestamp
* last_PID_update : int(10) unsigned
* serialized_inventory : longblob
v gpli glpi_plugin_fusioninventory_networkportconnectionlogs
* id : int(10) unsigned
* date_mod : timestamp
* creation : tinyint(1)
* networkports_id_source : int(10) unsigned
* networkports_id_destination : int(10) unsigned
* plugin_fusioninventory_agentprocesses_id : int(10) unsigned
v gpli glpi_plugin_fusioninventory_networkportlogs
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* plugin_fusioninventory_mappings_id : int(10) unsigned
* date_mod : timestamp
* value_old : varchar(255)
* value_new : varchar(255)
* plugin_fusioninventory_agentprocesses_id : int(10) unsigned
v gpli glpi_plugin_fusioninventory_networkports
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* ifmtu : int(10) unsigned
* ifspeed : bigint(50)
* ifinternalstatus : varchar(255)
* ifconnectionstatus : int(10) unsigned
* iflastchange : varchar(255)
* ifinoctets : bigint(50)
* ifinerrors : bigint(50)
* ifoutoctets : bigint(50)
* ifouterrors : bigint(50)
* ifstatus : varchar(255)
* mac : varchar(255)
* ifdescr : varchar(255)
* ifalias : varchar(255)
* portduplex : varchar(255)
* trunk : tinyint(1)
* lastup : timestamp
v gpli glpi_plugin_fusioninventory_networkporttypes
* id : int(10) unsigned
* name : varchar(255)
* number : int(10) unsigned
* othername : varchar(255)
* import : tinyint(1)
v gpli glpi_plugin_fusioninventory_ouis
* id : int(10) unsigned
* mac : varchar(255)
* name : varchar(255)
v gpli glpi_plugin_fusioninventory_pcidevices
* id : int(10) unsigned
* deviceid : varchar(255)
* name : varchar(255)
* plugin_fusioninventory_pcivendor_id : int(10) unsigned
v gpli glpi_plugin_fusioninventory_pcivendors
* id : int(10) unsigned
* vendorid : varchar(255)
* name : varchar(255)
v gpli glpi_plugin_fusioninventory_printercartridges
* id : bigint(20) unsigned
* printers_id : int(10) unsigned
* plugin_fusioninventory_mappings_id : int(10) unsigned
* cartridges_id : int(10) unsigned
* state : int(10) unsigned
v gpli glpi_plugin_fusioninventory_printerlogs
* id : int(10) unsigned
* printers_id : int(10) unsigned
* date : timestamp
* pages_total : int(10) unsigned
* pages_n_b : int(10) unsigned
* pages_color : int(10) unsigned
* pages_recto_verso : int(10) unsigned
* scanned : int(10) unsigned
* pages_total_print : int(10) unsigned
* pages_n_b_print : int(10) unsigned
* pages_color_print : int(10) unsigned
* pages_total_copy : int(10) unsigned
* pages_n_b_copy : int(10) unsigned
* pages_color_copy : int(10) unsigned
* pages_total_fax : int(10) unsigned
v gpli glpi_plugin_fusioninventory_printers
* id : int(10) unsigned
* printers_id : int(10) unsigned
* sysdescr : text
* plugin_fusioninventory_configsecurities_id : int(10) unsigned
* frequence_days : int(10) unsigned
* last_fusioninventory_update : timestamp
* serialized_inventory : longblob
v gpli glpi_plugin_fusioninventory_rulematchedlogs
* id : int(10) unsigned
* date : timestamp
* items_id : int(10) unsigned
* itemtype : varchar(100)
* rules_id : int(10) unsigned
* plugin_fusioninventory_agents_id : int(10) unsigned
* method : varchar(255)
* criteria : text
v gpli glpi_plugin_fusioninventory_statediscoveries
* id : int(10) unsigned
* plugin_fusioninventory_taskjob_id : int(10) unsigned
* plugin_fusioninventory_agents_id : int(10) unsigned
* start_time : timestamp
* end_time : timestamp
* date_mod : timestamp
* threads : int(10) unsigned
* nb_ip : int(10) unsigned
* nb_found : int(10) unsigned
* nb_error : int(10) unsigned
* nb_exists : int(10) unsigned
* nb_import : int(10) unsigned
v gpli glpi_plugin_fusioninventory_taskjoblogs
* id : bigint(20) unsigned
* plugin_fusioninventory_taskjobstates_id : int(10) unsigned
* date : timestamp
* items_id : int(10) unsigned
* itemtype : varchar(100)
* state : int(10) unsigned
* comment : text
v gpli glpi_plugin_fusioninventory_taskjobs
* id : int(10) unsigned
* plugin_fusioninventory_tasks_id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* date_creation : timestamp
* method : varchar(255)
* targets : text
* actors : text
* comment : text
* rescheduled_taskjob_id : int(10) unsigned
* statuscomments : text
* enduser : text
v gpli glpi_plugin_fusioninventory_taskjobstates
* id : bigint(20) unsigned
* plugin_fusioninventory_taskjobs_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* state : int(10) unsigned
* plugin_fusioninventory_agents_id : int(10) unsigned
* specificity : text
* uniqid : varchar(255)
* date_start : timestamp
* nb_retry : int(10) unsigned
* max_retry : int(10) unsigned
v gpli glpi_plugin_fusioninventory_tasks
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* date_creation : timestamp
* comment : text
* is_active : tinyint(1)
* datetime_start : timestamp
* datetime_end : timestamp
* plugin_fusioninventory_timeslots_prep_id : int(10) unsigned
* plugin_fusioninventory_timeslots_exec_id : int(10) unsigned
* last_agent_wakeup : timestamp
* wakeup_agent_counter : int(10) unsigned
* wakeup_agent_time : int(10) unsigned
* reprepare_if_successful : tinyint(1)
* is_deploy_on_demand : tinyint(1)
v gpli glpi_plugin_fusioninventory_timeslotentries
* id : int(10) unsigned
* plugin_fusioninventory_timeslots_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* day : tinyint(1)
* begin : int(10) unsigned
* end : int(10) unsigned
v gpli glpi_plugin_fusioninventory_timeslots
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(1)
* name : varchar(255)
* comment : text
* date_mod : timestamp
v gpli glpi_plugin_fusioninventory_unmanageds
* id : int(10) unsigned
* name : varchar(255)
* date_mod : timestamp
* entities_id : int(10) unsigned
* locations_id : int(10) unsigned
* is_deleted : tinyint(1)
* users_id : int(10) unsigned
* serial : varchar(255)
* otherserial : varchar(255)
* contact : varchar(255)
* domain : int(10) unsigned
* comment : text
* item_type : varchar(255)
* accepted : tinyint(1)
* plugin_fusioninventory_agents_id : int(10) unsigned
* ip : varchar(255)
* hub : tinyint(1)
* states_id : int(10) unsigned
* sysdescr : text
* plugin_fusioninventory_configsecurities_id : int(10) unsigned
* is_dynamic : tinyint(1)
* serialized_inventory : longblob
v gpli glpi_plugin_fusioninventory_usbdevices
* id : int(10) unsigned
* deviceid : varchar(255)
* name : varchar(255)
* plugin_fusioninventory_usbvendor_id : int(10) unsigned
v gpli glpi_plugin_fusioninventory_usbvendors
* id : int(10) unsigned
* vendorid : varchar(255)
* name : varchar(255)
v gpli glpi_plugin_genericobject_pmodels
* id : int(11)
* name : varchar(255)
* comment : text
v gpli glpi_plugin_genericobject_pos
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
* contact : varchar(255)
* otherserial : varchar(255)
* serial : varchar(255)
* locations_id : int(10) unsigned
v gpli glpi_plugin_genericobject_typefamilies
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_plugin_genericobject_types
* id : int(10) unsigned
* entities_id : int(10) unsigned
* itemtype : varchar(255)
* is_active : tinyint(4)
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
* use_unicity : tinyint(4)
* use_history : tinyint(4)
* use_infocoms : tinyint(4)
* use_contracts : tinyint(4)
* use_documents : tinyint(4)
* use_tickets : tinyint(4)
* use_loans : tinyint(4)
* use_network_ports : tinyint(4)
* use_direct_connections : tinyint(4)
* use_plugin_datainjection : tinyint(4)
* use_plugin_pdf : tinyint(4)
* use_plugin_order : tinyint(4)
* use_plugin_uninstall : tinyint(4)
* use_plugin_geninventorynumber : tinyint(4)
* use_menu_entry : tinyint(4)
* use_projects : tinyint(4)
* linked_itemtypes : text
* plugin_genericobject_typefamilies_id : int(10) unsigned
* use_itemdevices : tinyint(4)
* impact_icon : varchar(255)
* use_notepad : tinyint(4)
* use_plugin_simcard : tinyint(4)
* use_plugin_treeview : tinyint(4)
v gpli glpi_plugs
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_printerlogs
* id : int(10) unsigned
* printers_id : int(10) unsigned
* total_pages : int(11)
* bw_pages : int(11)
* color_pages : int(11)
* rv_pages : int(11)
* prints : int(11)
* bw_prints : int(11)
* color_prints : int(11)
* copies : int(11)
* bw_copies : int(11)
* color_copies : int(11)
* scanned : int(11)
* date : date
* date_creation : timestamp
* date_mod : timestamp
* faxed : int(11)
v gpli glpi_printermodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* picture_front : text
* picture_rear : text
* pictures : text
v gpli glpi_printers
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* date_mod : timestamp
* contact : varchar(255)
* contact_num : varchar(255)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* serial : varchar(255)
* otherserial : varchar(255)
* have_serial : tinyint(4)
* have_parallel : tinyint(4)
* have_usb : tinyint(4)
* have_wifi : tinyint(4)
* have_ethernet : tinyint(4)
* comment : text
* memory_size : varchar(255)
* locations_id : int(10) unsigned
* networks_id : int(10) unsigned
* printertypes_id : int(10) unsigned
* printermodels_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* is_global : tinyint(4)
* is_deleted : tinyint(4)
* is_template : tinyint(4)
* template_name : varchar(255)
* init_pages_counter : int(11)
* last_pages_counter : int(11)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* states_id : int(10) unsigned
* ticket_tco : decimal(20,4)
* is_dynamic : tinyint(4)
* uuid : varchar(255)
* date_creation : timestamp
* sysdescr : text
* last_inventory_update : timestamp
* snmpcredentials_id : int(10) unsigned
* autoupdatesystems_id : int(10) unsigned
v gpli glpi_printers_cartridgeinfos
* id : int(10) unsigned
* printers_id : int(10) unsigned
* property : varchar(255)
* value : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_printertypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_problemcosts
* id : int(10) unsigned
* problems_id : int(10) unsigned
* name : varchar(255)
* comment : text
* begin_date : date
* end_date : date
* actiontime : int(11)
* cost_time : decimal(20,4)
* cost_fixed : decimal(20,4)
* cost_material : decimal(20,4)
* budgets_id : int(10) unsigned
* entities_id : int(10) unsigned
v gpli glpi_problems
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* is_deleted : tinyint(4)
* status : int(11)
* content : longtext
* date_mod : timestamp
* date : timestamp
* solvedate : timestamp
* closedate : timestamp
* time_to_resolve : timestamp
* users_id_recipient : int(10) unsigned
* users_id_lastupdater : int(10) unsigned
* urgency : int(11)
* impact : int(11)
* priority : int(11)
* itilcategories_id : int(10) unsigned
* impactcontent : longtext
* causecontent : longtext
* symptomcontent : longtext
* 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) unsigned
v gpli glpi_problems_suppliers
* id : int(10) unsigned
* problems_id : int(10) unsigned
* suppliers_id : int(10) unsigned
* type : int(11)
* use_notification : tinyint(4)
* alternative_email : varchar(255)
v gpli glpi_problems_tickets
* id : int(10) unsigned
* problems_id : int(10) unsigned
* tickets_id : int(10) unsigned
v gpli glpi_problems_users
* id : int(10) unsigned
* problems_id : int(10) unsigned
* users_id : int(10) unsigned
* type : int(11)
* use_notification : tinyint(4)
* alternative_email : varchar(255)
v gpli glpi_problemtasks
* id : int(10) unsigned
* uuid : varchar(255)
* problems_id : int(10) unsigned
* taskcategories_id : int(10) unsigned
* date : timestamp
* begin : timestamp
* end : timestamp
* users_id : int(10) unsigned
* users_id_editor : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* content : longtext
* actiontime : int(11)
* state : int(11)
* date_mod : timestamp
* date_creation : timestamp
* tasktemplates_id : int(10) unsigned
* timeline_position : tinyint(4)
* is_private : tinyint(4)
v gpli glpi_problemtemplatehiddenfields
* id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* num : int(11)
v gpli glpi_problemtemplatemandatoryfields
* id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* num : int(11)
v gpli glpi_problemtemplatepredefinedfields
* id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* num : int(11)
* value : text
v gpli glpi_problemtemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v gpli glpi_profilerights
* id : int(10) unsigned
* profiles_id : int(10) unsigned
* name : varchar(255)
* rights : int(11)
v gpli glpi_profiles
* id : int(10) unsigned
* name : varchar(255)
* interface : varchar(255)
* is_default : tinyint(4)
* helpdesk_hardware : int(11)
* helpdesk_item_type : text
* ticket_status : text
* date_mod : timestamp
* comment : text
* problem_status : text
* create_ticket_on_login : tinyint(4)
* tickettemplates_id : int(10) unsigned
* changetemplates_id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* change_status : text
* managed_domainrecordtypes : text
* date_creation : timestamp
v gpli glpi_profiles_reminders
* id : int(10) unsigned
* reminders_id : int(10) unsigned
* profiles_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* no_entity_restriction : tinyint(4)
v gpli glpi_profiles_rssfeeds
* id : int(10) unsigned
* rssfeeds_id : int(10) unsigned
* profiles_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* no_entity_restriction : tinyint(4)
v gpli glpi_profiles_users
* id : int(10) unsigned
* users_id : int(10) unsigned
* profiles_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* is_dynamic : tinyint(4)
* is_default_profile : tinyint(4)
v gpli glpi_projectcosts
* id : int(10) unsigned
* projects_id : int(10) unsigned
* name : varchar(255)
* comment : text
* begin_date : date
* end_date : date
* cost : decimal(20,4)
* budgets_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v gpli glpi_projects
* id : int(10) unsigned
* name : varchar(255)
* code : varchar(255)
* priority : int(11)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* projects_id : int(10) unsigned
* projectstates_id : int(10) unsigned
* projecttypes_id : int(10) unsigned
* date : timestamp
* date_mod : timestamp
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* plan_start_date : timestamp
* plan_end_date : timestamp
* real_start_date : timestamp
* real_end_date : timestamp
* percent_done : int(11)
* auto_percent_done : tinyint(4)
* show_on_global_gantt : tinyint(4)
* content : longtext
* comment : longtext
* is_deleted : tinyint(4)
* date_creation : timestamp
* projecttemplates_id : int(10) unsigned
* is_template : tinyint(4)
* template_name : varchar(255)
v gpli glpi_projectstates
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* color : varchar(255)
* is_finished : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_projecttasks
* id : int(10) unsigned
* uuid : varchar(255)
* name : varchar(255)
* content : longtext
* comment : longtext
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* projects_id : int(10) unsigned
* projecttasks_id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
* plan_start_date : timestamp
* plan_end_date : timestamp
* real_start_date : timestamp
* real_end_date : timestamp
* planned_duration : int(11)
* effective_duration : int(11)
* projectstates_id : int(10) unsigned
* projecttasktypes_id : int(10) unsigned
* users_id : int(10) unsigned
* percent_done : int(11)
* auto_percent_done : tinyint(4)
* is_milestone : tinyint(4)
* projecttasktemplates_id : int(10) unsigned
* is_template : tinyint(4)
* template_name : varchar(255)
v gpli glpi_projecttasks_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* projecttasks_id : int(10) unsigned
v gpli glpi_projecttaskteams
* id : int(10) unsigned
* projecttasks_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v gpli glpi_projecttasktemplates
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* description : longtext
* comment : longtext
* projects_id : int(10) unsigned
* projecttasks_id : int(10) unsigned
* plan_start_date : timestamp
* plan_end_date : timestamp
* real_start_date : timestamp
* real_end_date : timestamp
* planned_duration : int(11)
* effective_duration : int(11)
* projectstates_id : int(10) unsigned
* projecttasktypes_id : int(10) unsigned
* users_id : int(10) unsigned
* percent_done : int(11)
* is_milestone : tinyint(4)
* comments : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_projecttasktypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_projectteams
* id : int(10) unsigned
* projects_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v gpli glpi_projecttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_queuednotifications
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* notificationtemplates_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_deleted : tinyint(4)
* sent_try : int(11)
* create_time : timestamp
* send_time : timestamp
* sent_time : timestamp
* name : text
* sender : text
* sendername : text
* recipient : text
* recipientname : text
* replyto : text
* replytoname : text
* headers : text
* body_html : longtext
* body_text : longtext
* messageid : text
* documents : text
* mode : varchar(20)
* event : varchar(255)
v gpli glpi_rackmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* pictures : text
v gpli glpi_racks
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* locations_id : int(10) unsigned
* serial : varchar(255)
* otherserial : varchar(255)
* rackmodels_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* racktypes_id : int(10) unsigned
* states_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* width : int(11)
* height : int(11)
* depth : int(11)
* number_units : int(11)
* is_template : tinyint(4)
* template_name : varchar(255)
* is_deleted : tinyint(4)
* dcrooms_id : int(10) unsigned
* room_orientation : int(11)
* position : varchar(50)
* bgcolor : varchar(7)
* max_power : int(11)
* mesured_power : int(11)
* max_weight : int(11)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_racktypes
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_recurrentchanges
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* is_active : tinyint(4)
* changetemplates_id : int(10) unsigned
* begin_date : timestamp
* periodicity : varchar(255)
* create_before : int(11)
* next_creation_date : timestamp
* calendars_id : int(10) unsigned
* end_date : timestamp
v gpli glpi_refusedequipments
* id : int(10) unsigned
* name : varchar(255)
* itemtype : varchar(100)
* entities_id : int(10) unsigned
* ip : text
* mac : text
* rules_id : int(10) unsigned
* method : varchar(255)
* serial : varchar(255)
* uuid : varchar(255)
* agents_id : int(10) unsigned
* autoupdatesystems_id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_registeredids
* id : int(10) unsigned
* name : varchar(255)
* items_id : int(10) unsigned
* itemtype : varchar(100)
* device_type : varchar(100)
v gpli glpi_reminders
* id : int(10) unsigned
* uuid : varchar(255)
* date : timestamp
* users_id : int(10) unsigned
* name : varchar(255)
* text : text
* begin : timestamp
* end : timestamp
* is_planned : tinyint(4)
* date_mod : timestamp
* state : int(11)
* begin_view_date : timestamp
* end_view_date : timestamp
* date_creation : timestamp
v gpli glpi_reminders_users
* id : int(10) unsigned
* reminders_id : int(10) unsigned
* users_id : int(10) unsigned
v gpli glpi_remindertranslations
* id : int(10) unsigned
* reminders_id : int(10) unsigned
* language : varchar(5)
* name : text
* text : longtext
* users_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_requesttypes
* id : int(10) unsigned
* name : varchar(255)
* is_helpdesk_default : tinyint(4)
* is_followup_default : tinyint(4)
* is_mail_default : tinyint(4)
* is_mailfollowup_default : tinyint(4)
* is_active : tinyint(4)
* is_ticketheader : tinyint(4)
* is_itilfollowup : tinyint(4)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_reservationitems
* id : int(10) unsigned
* itemtype : varchar(100)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* items_id : int(10) unsigned
* comment : text
* is_active : tinyint(4)
v gpli glpi_reservations
* id : int(10) unsigned
* reservationitems_id : int(10) unsigned
* begin : timestamp
* end : timestamp
* users_id : int(10) unsigned
* comment : text
* group : int(11)
v gpli glpi_rssfeeds
* id : int(10) unsigned
* name : varchar(255)
* users_id : int(10) unsigned
* comment : text
* url : text
* refresh_rate : int(11)
* max_items : int(11)
* have_error : tinyint(4)
* is_active : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_rssfeeds_users
* id : int(10) unsigned
* rssfeeds_id : int(10) unsigned
* users_id : int(10) unsigned
v gpli glpi_ruleactions
* id : int(10) unsigned
* rules_id : int(10) unsigned
* action_type : varchar(255)
* field : varchar(255)
* value : varchar(255)
v gpli glpi_rulecriterias
* id : int(10) unsigned
* rules_id : int(10) unsigned
* criteria : varchar(255)
* condition : int(11)
* pattern : text
v gpli glpi_rulematchedlogs
* id : int(10) unsigned
* date : timestamp
* items_id : int(10) unsigned
* itemtype : varchar(100)
* rules_id : int(10) unsigned
* agents_id : int(10) unsigned
* method : varchar(255)
v gpli glpi_rulerightparameters
* id : int(10) unsigned
* name : varchar(255)
* value : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_rules
* id : int(10) unsigned
* entities_id : int(10) unsigned
* sub_type : varchar(255)
* ranking : int(11)
* name : varchar(255)
* description : text
* match : char(10)
* is_active : tinyint(4)
* comment : text
* date_mod : timestamp
* is_recursive : tinyint(4)
* uuid : varchar(255)
* condition : int(11)
* date_creation : timestamp
v gpli glpi_savedsearches
* id : int(10) unsigned
* name : varchar(255)
* type : int(11)
* itemtype : varchar(100)
* users_id : int(10) unsigned
* is_private : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* query : text
* last_execution_time : int(11)
* do_count : tinyint(4)
* last_execution_date : timestamp
* counter : int(11)
v gpli glpi_savedsearches_alerts
* id : int(10) unsigned
* savedsearches_id : int(10) unsigned
* name : varchar(255)
* is_active : tinyint(4)
* operator : tinyint(4)
* value : int(11)
* date_mod : timestamp
* date_creation : timestamp
* frequency : int(11)
v gpli glpi_savedsearches_users
* id : int(10) unsigned
* users_id : int(10) unsigned
* itemtype : varchar(100)
* savedsearches_id : int(10) unsigned
v gpli glpi_slalevelactions
* id : int(10) unsigned
* slalevels_id : int(10) unsigned
* action_type : varchar(255)
* field : varchar(255)
* value : varchar(255)
v gpli glpi_slalevelcriterias
* id : int(10) unsigned
* slalevels_id : int(10) unsigned
* criteria : varchar(255)
* condition : int(11)
* pattern : varchar(255)
v gpli glpi_slalevels
* id : int(10) unsigned
* name : varchar(255)
* slas_id : int(10) unsigned
* execution_time : int(11)
* is_active : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* match : char(10)
* uuid : varchar(255)
v gpli glpi_slalevels_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* slalevels_id : int(10) unsigned
* date : timestamp
v gpli glpi_slas
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* type : int(11)
* comment : text
* number_time : int(11)
* use_ticket_calendar : tinyint(4)
* calendars_id : int(10) unsigned
* date_mod : timestamp
* definition_time : varchar(255)
* end_of_working_day : tinyint(4)
* date_creation : timestamp
* slms_id : int(10) unsigned
v gpli glpi_slms
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
* use_ticket_calendar : tinyint(4)
* calendars_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_snmpcredentials
* id : int(10) unsigned
* name : varchar(64)
* snmpversion : varchar(8)
* community : varchar(255)
* username : varchar(255)
* authentication : varchar(255)
* auth_passphrase : varchar(255)
* encryption : varchar(255)
* priv_passphrase : varchar(255)
* is_deleted : tinyint(4)
v gpli glpi_socketmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_sockets
* id : int(10) unsigned
* position : int(11)
* locations_id : int(10) unsigned
* name : varchar(255)
* socketmodels_id : int(10) unsigned
* wiring_side : tinyint(4)
* itemtype : varchar(255)
* items_id : int(10) unsigned
* networkports_id : int(10) unsigned
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_softwarecategories
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* softwarecategories_id : int(10) unsigned
* completename : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
v gpli glpi_softwarelicenses
* id : int(10) unsigned
* softwares_id : int(10) unsigned
* softwarelicenses_id : int(10) unsigned
* completename : text
* level : int(11)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* number : int(11)
* softwarelicensetypes_id : int(10) unsigned
* name : varchar(255)
* serial : varchar(255)
* otherserial : varchar(255)
* softwareversions_id_buy : int(10) unsigned
* softwareversions_id_use : int(10) unsigned
* expire : date
* comment : text
* date_mod : timestamp
* is_valid : tinyint(4)
* date_creation : timestamp
* is_deleted : tinyint(4)
* locations_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* users_id : int(10) unsigned
* groups_id_tech : int(10) unsigned
* groups_id : int(10) unsigned
* is_helpdesk_visible : tinyint(4)
* is_template : tinyint(4)
* template_name : varchar(255)
* states_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* contact : varchar(255)
* contact_num : varchar(255)
* allow_overquota : tinyint(4)
* pictures : text
* ancestors_cache : longtext
* sons_cache : longtext
v gpli glpi_softwarelicensetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
* softwarelicensetypes_id : int(10) unsigned
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* completename : text
v gpli glpi_softwares
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* locations_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_update : tinyint(4)
* softwares_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_template : tinyint(4)
* template_name : varchar(255)
* date_mod : timestamp
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* ticket_tco : decimal(20,4)
* is_helpdesk_visible : tinyint(4)
* softwarecategories_id : int(10) unsigned
* is_valid : tinyint(4)
* date_creation : timestamp
* pictures : text
v gpli glpi_softwareversions
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* softwares_id : int(10) unsigned
* states_id : int(10) unsigned
* name : varchar(255)
* arch : varchar(255)
* comment : text
* operatingsystems_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_solutiontemplates
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* content : mediumtext
* solutiontypes_id : int(10) unsigned
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_solutiontypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_ssovariables
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_states
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
* states_id : int(10) unsigned
* completename : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
* is_visible_computer : tinyint(4)
* is_visible_monitor : tinyint(4)
* is_visible_networkequipment : tinyint(4)
* is_visible_peripheral : tinyint(4)
* is_visible_phone : tinyint(4)
* is_visible_printer : tinyint(4)
* is_visible_softwareversion : tinyint(4)
* is_visible_softwarelicense : tinyint(4)
* is_visible_line : tinyint(4)
* is_visible_certificate : tinyint(4)
* is_visible_rack : tinyint(4)
* is_visible_passivedcequipment : tinyint(4)
* is_visible_enclosure : tinyint(4)
* is_visible_pdu : tinyint(4)
* is_visible_cluster : tinyint(4)
* is_visible_contract : tinyint(4)
* is_visible_appliance : tinyint(4)
* is_visible_databaseinstance : tinyint(4)
* is_visible_cable : tinyint(4)
* is_visible_unmanaged : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_suppliers
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* suppliertypes_id : int(10) unsigned
* registration_number : varchar(255)
* address : text
* postcode : varchar(255)
* town : varchar(255)
* state : varchar(255)
* country : varchar(255)
* website : varchar(255)
* phonenumber : varchar(255)
* comment : text
* is_deleted : tinyint(4)
* fax : varchar(255)
* email : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* is_active : tinyint(4)
* pictures : text
v gpli glpi_suppliers_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* suppliers_id : int(10) unsigned
* type : int(11)
* use_notification : tinyint(4)
* alternative_email : varchar(255)
v gpli glpi_suppliertypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_taskcategories
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* taskcategories_id : int(10) unsigned
* name : varchar(255)
* completename : text
* comment : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
* is_active : tinyint(4)
* is_helpdeskvisible : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
* knowbaseitemcategories_id : int(10) unsigned
v gpli glpi_tasktemplates
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* content : mediumtext
* taskcategories_id : int(10) unsigned
* actiontime : int(11)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
* state : int(11)
* is_private : tinyint(4)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
v gpli glpi_ticketcosts
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* name : varchar(255)
* comment : text
* begin_date : date
* end_date : date
* actiontime : int(11)
* cost_time : decimal(20,4)
* cost_fixed : decimal(20,4)
* cost_material : decimal(20,4)
* budgets_id : int(10) unsigned
* entities_id : int(10) unsigned
v gpli glpi_ticketrecurrents
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* is_active : tinyint(4)
* tickettemplates_id : int(10) unsigned
* begin_date : timestamp
* periodicity : varchar(255)
* create_before : int(11)
* next_creation_date : timestamp
* calendars_id : int(10) unsigned
* end_date : timestamp
v gpli glpi_tickets
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* date : timestamp
* closedate : timestamp
* solvedate : timestamp
* takeintoaccountdate : timestamp
* date_mod : timestamp
* users_id_lastupdater : int(10) unsigned
* status : int(11)
* users_id_recipient : int(10) unsigned
* requesttypes_id : int(10) unsigned
* content : longtext
* urgency : int(11)
* impact : int(11)
* priority : int(11)
* itilcategories_id : int(10) unsigned
* type : int(11)
* global_validation : int(11)
* slas_id_ttr : int(10) unsigned
* slas_id_tto : int(10) unsigned
* slalevels_id_ttr : int(10) unsigned
* 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) unsigned
* olas_id_ttr : int(10) unsigned
* olalevels_id_ttr : int(10) unsigned
* 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) unsigned
* validation_percent : int(11)
* date_creation : timestamp
* ola_tto_begin_date : timestamp
v gpli glpi_ticketsatisfactions
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* type : int(11)
* date_begin : timestamp
* date_answered : timestamp
* satisfaction : int(11)
* comment : text
v gpli glpi_tickets_contracts
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* contracts_id : int(10) unsigned
v gpli glpi_tickets_tickets
* id : int(10) unsigned
* tickets_id_1 : int(10) unsigned
* tickets_id_2 : int(10) unsigned
v gpli glpi_tickets_users
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* users_id : int(10) unsigned
* type : int(11)
* use_notification : tinyint(4)
* alternative_email : varchar(255)
v gpli glpi_tickettasks
* id : int(10) unsigned
* uuid : varchar(255)
* tickets_id : int(10) unsigned
* taskcategories_id : int(10) unsigned
* date : timestamp
* users_id : int(10) unsigned
* users_id_editor : int(10) unsigned
* content : longtext
* is_private : tinyint(4)
* actiontime : int(11)
* begin : timestamp
* end : timestamp
* state : int(11)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
* tasktemplates_id : int(10) unsigned
* timeline_position : tinyint(4)
* sourceitems_id : int(10) unsigned
* sourceof_items_id : int(10) unsigned
v gpli glpi_tickettemplatehiddenfields
* id : int(10) unsigned
* tickettemplates_id : int(10) unsigned
* num : int(11)
v gpli glpi_tickettemplatemandatoryfields
* id : int(10) unsigned
* tickettemplates_id : int(10) unsigned
* num : int(11)
v gpli glpi_tickettemplatepredefinedfields
* id : int(10) unsigned
* tickettemplates_id : int(10) unsigned
* num : int(11)
* value : text
v gpli glpi_tickettemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v gpli glpi_ticketvalidations
* id : int(10) unsigned
* entities_id : int(10) unsigned
* users_id : int(10) unsigned
* tickets_id : int(10) unsigned
* users_id_validate : int(10) unsigned
* comment_submission : text
* comment_validation : text
* status : int(11)
* submission_date : timestamp
* validation_date : timestamp
* timeline_position : tinyint(4)
v gpli glpi_transfers
* id : int(10) unsigned
* name : varchar(255)
* keep_ticket : int(11)
* keep_reservation : int(11)
* keep_history : int(11)
* keep_device : int(11)
* keep_infocom : int(11)
* keep_dc_monitor : int(11)
* clean_dc_monitor : int(11)
* keep_dc_phone : int(11)
* clean_dc_phone : int(11)
* keep_dc_peripheral : int(11)
* clean_dc_peripheral : int(11)
* keep_dc_printer : int(11)
* clean_dc_printer : int(11)
* keep_supplier : int(11)
* clean_supplier : int(11)
* keep_contact : int(11)
* clean_contact : int(11)
* keep_contract : int(11)
* clean_contract : int(11)
* keep_software : int(11)
* clean_software : int(11)
* keep_document : int(11)
* clean_document : int(11)
* keep_cartridgeitem : int(11)
* clean_cartridgeitem : int(11)
* keep_cartridge : int(11)
* keep_consumable : int(11)
* date_mod : timestamp
* date_creation : timestamp
* comment : text
* keep_disk : int(11)
* keep_certificate : int(11)
* clean_certificate : int(11)
* lock_updated_fields : int(11)
* keep_location : int(11)
v gpli glpi_unmanageds
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* serial : varchar(255)
* otherserial : varchar(255)
* contact : varchar(255)
* contact_num : varchar(255)
* date_mod : timestamp
* comment : text
* locations_id : int(10) unsigned
* networks_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* is_deleted : tinyint(4)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* states_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_dynamic : tinyint(4)
* date_creation : timestamp
* autoupdatesystems_id : int(10) unsigned
* sysdescr : text
* agents_id : int(10) unsigned
* itemtype : varchar(100)
* accepted : tinyint(4)
* hub : tinyint(4)
* ip : varchar(255)
* snmpcredentials_id : int(10) unsigned
* last_inventory_update : timestamp
v gpli glpi_usbvendors
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* vendorid : varchar(4)
* deviceid : varchar(4)
* name : varchar(255)
* comment : text
* date_creation : timestamp
* date_mod : timestamp
v gpli glpi_usercategories
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_useremails
* id : int(10) unsigned
* users_id : int(10) unsigned
* is_default : tinyint(4)
* is_dynamic : tinyint(4)
* email : varchar(255)
v gpli glpi_users
* id : int(10) unsigned
* name : varchar(255)
* password : varchar(255)
* password_last_update : timestamp
* phone : varchar(255)
* phone2 : varchar(255)
* mobile : varchar(255)
* realname : varchar(255)
* firstname : varchar(255)
* locations_id : int(10) unsigned
* language : char(10)
* use_mode : int(11)
* list_limit : int(11)
* is_active : tinyint(4)
* comment : text
* auths_id : int(10) unsigned
* authtype : int(11)
* last_login : timestamp
* date_mod : timestamp
* date_sync : timestamp
* is_deleted : tinyint(4)
* profiles_id : int(10) unsigned
* entities_id : int(10) unsigned
* usertitles_id : int(10) unsigned
* usercategories_id : int(10) unsigned
* date_format : int(11)
* number_format : int(11)
* names_format : int(11)
* csv_delimiter : char(1)
* is_ids_visible : tinyint(4)
* use_flat_dropdowntree : tinyint(4)
* show_jobs_at_login : tinyint(4)
* priority_1 : char(20)
* priority_2 : char(20)
* priority_3 : char(20)
* priority_4 : char(20)
* priority_5 : char(20)
* priority_6 : char(20)
* followup_private : tinyint(4)
* task_private : tinyint(4)
* default_requesttypes_id : int(10) unsigned
* password_forget_token : char(40)
* password_forget_token_date : timestamp
* user_dn : text
* user_dn_hash : varchar(32)
* registration_number : varchar(255)
* show_count_on_tabs : tinyint(4)
* refresh_views : int(11)
* set_default_tech : tinyint(4)
* personal_token : varchar(255)
* personal_token_date : timestamp
* api_token : varchar(255)
* api_token_date : timestamp
* cookie_token : varchar(255)
* cookie_token_date : timestamp
* display_count_on_home : int(11)
* notification_to_myself : tinyint(4)
* duedateok_color : varchar(255)
* duedatewarning_color : varchar(255)
* duedatecritical_color : varchar(255)
* duedatewarning_less : int(11)
* duedatecritical_less : int(11)
* duedatewarning_unit : varchar(255)
* duedatecritical_unit : varchar(255)
* display_options : text
* is_deleted_ldap : tinyint(4)
* pdffont : varchar(255)
* picture : varchar(255)
* begin_date : timestamp
* end_date : timestamp
* keep_devices_when_purging_item : tinyint(4)
* privatebookmarkorder : longtext
* backcreated : tinyint(4)
* task_state : int(11)
* palette : char(20)
* page_layout : char(20)
* fold_menu : tinyint(4)
* savedsearches_pinned : text
* timeline_order : char(20)
* itil_layout : text
* richtext_layout : char(20)
* set_default_requester : tinyint(4)
* lock_autolock_mode : tinyint(4)
* lock_directunlock_notification : tinyint(4)
* date_creation : timestamp
* highcontrast_css : tinyint(4)
* plannings : text
* sync_field : varchar(255)
* groups_id : int(10) unsigned
* users_id_supervisor : int(10) unsigned
* timezone : varchar(50)
* default_dashboard_central : varchar(100)
* default_dashboard_assets : varchar(100)
* default_dashboard_helpdesk : varchar(100)
* default_dashboard_mini_ticket : varchar(100)
* default_central_tab : tinyint(4)
* nickname : varchar(255)
* timeline_action_btn_layout : tinyint(4)
* timeline_date_format : tinyint(4)
* use_flat_dropdowntree_on_search_result : tinyint(4)
v gpli glpi_usertitles
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_virtualmachinestates
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_virtualmachinesystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_virtualmachinetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_vlans
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* tag : int(11)
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_vobjects
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* data : text
* date_mod : timestamp
* date_creation : timestamp
v gpli glpi_wifinetworks
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* essid : varchar(255)
* mode : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
Crear relación
FOREIGN KEY
on delete
on update
Eliminar la relación