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 glpi 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 glpi glpi_agenttypes
* id : int(10) unsigned
* name : varchar(255)
v glpi glpi_alerts
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* type : int(11)
* date : timestamp
v glpi 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 glpi glpi_applianceenvironments
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v glpi 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 glpi glpi_appliances_items
* id : int(10) unsigned
* appliances_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
v glpi glpi_appliances_items_relations
* id : int(10) unsigned
* appliances_items_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpi glpi_appliancetypes
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* externalidentifier : varchar(255)
v glpi glpi_authldapreplicates
* id : int(10) unsigned
* authldaps_id : int(10) unsigned
* host : varchar(255)
* port : int(11)
* name : varchar(255)
* timeout : int(11)
v glpi 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 glpi 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 glpi glpi_autoupdatesystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v glpi glpi_blacklistedmailcontents
* id : int(10) unsigned
* name : varchar(255)
* content : text
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_blacklists
* id : int(10) unsigned
* type : int(11)
* name : varchar(255)
* value : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi glpi_budgettypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_cablestrands
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_cabletypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_calendars_holidays
* id : int(10) unsigned
* calendars_id : int(10) unsigned
* holidays_id : int(10) unsigned
v glpi 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 glpi glpi_cartridgeitems_printermodels
* id : int(10) unsigned
* cartridgeitems_id : int(10) unsigned
* printermodels_id : int(10) unsigned
v glpi glpi_cartridgeitemtypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_changes_groups
* id : int(10) unsigned
* changes_id : int(10) unsigned
* groups_id : int(10) unsigned
* type : int(11)
v glpi glpi_changes_items
* id : int(10) unsigned
* changes_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpi glpi_changes_problems
* id : int(10) unsigned
* changes_id : int(10) unsigned
* problems_id : int(10) unsigned
v glpi 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 glpi glpi_changes_tickets
* id : int(10) unsigned
* changes_id : int(10) unsigned
* tickets_id : int(10) unsigned
v glpi 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 glpi 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 glpi glpi_changetemplatehiddenfields
* id : int(10) unsigned
* changetemplates_id : int(10) unsigned
* num : int(11)
v glpi glpi_changetemplatemandatoryfields
* id : int(10) unsigned
* changetemplates_id : int(10) unsigned
* num : int(11)
v glpi glpi_changetemplatepredefinedfields
* id : int(10) unsigned
* changetemplates_id : int(10) unsigned
* num : int(11)
* value : text
v glpi glpi_changetemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_computertypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi glpi_configs
* id : int(10) unsigned
* context : varchar(150)
* name : varchar(150)
* value : text
v glpi 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 glpi glpi_consumableitemtypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_contacts_suppliers
* id : int(10) unsigned
* suppliers_id : int(10) unsigned
* contacts_id : int(10) unsigned
v glpi glpi_contacttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_contracts_items
* id : int(10) unsigned
* contracts_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
v glpi glpi_contracts_suppliers
* id : int(10) unsigned
* suppliers_id : int(10) unsigned
* contracts_id : int(10) unsigned
v glpi glpi_contracttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_dashboards_dashboards
* id : int(10) unsigned
* key : varchar(100)
* name : varchar(100)
* context : varchar(100)
* users_id : int(10) unsigned
v glpi glpi_dashboards_filters
* id : int(10) unsigned
* dashboards_dashboards_id : int(10) unsigned
* users_id : int(10) unsigned
* filter : longtext
v glpi 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 glpi glpi_dashboards_rights
* id : int(10) unsigned
* dashboards_dashboards_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpi glpi_databaseinstancecategories
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi glpi_databaseinstancetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_devicebatterymodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi glpi_devicebatterytypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_devicecameramodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_devicecasemodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_devicecasetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_devicecontrolmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_devicedrivemodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_devicefirmwaremodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_devicefirmwaretypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_devicegenericmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_devicegenerictypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v glpi glpi_devicegraphiccardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_deviceharddrivemodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi 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 glpi glpi_devicememorymodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi glpi_devicememorytypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_devicemotherboardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_devicenetworkcardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_devicepcimodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi 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 glpi glpi_devicepowersupplymodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi glpi_deviceprocessormodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_devicesensormodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_devicesensortypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v glpi 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 glpi glpi_devicesimcardtypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_devicesoundcardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpi 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 glpi glpi_displaypreferences
* id : int(10) unsigned
* itemtype : varchar(100)
* num : int(11)
* rank : int(11)
* users_id : int(10) unsigned
v glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_domainrecordtypes
* id : int(10) unsigned
* name : varchar(255)
* fields : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpi glpi_domainrelations
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpi 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 glpi 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 glpi glpi_domaintypes
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpi glpi_dropdowntranslations
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* language : varchar(10)
* field : varchar(100)
* value : text
v glpi 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 glpi 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 glpi 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 glpi glpi_entities_knowbaseitems
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v glpi glpi_entities_reminders
* id : int(10) unsigned
* reminders_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v glpi glpi_entities_rssfeeds
* id : int(10) unsigned
* rssfeeds_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v glpi 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 glpi 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 glpi 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 glpi glpi_filesystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi glpi_groups_problems
* id : int(10) unsigned
* problems_id : int(10) unsigned
* groups_id : int(10) unsigned
* type : int(11)
v glpi 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 glpi 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 glpi glpi_groups_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* groups_id : int(10) unsigned
* type : int(11)
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_impactcompounds
* id : int(10) unsigned
* name : varchar(255)
* color : varchar(255)
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_interfacetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi glpi_ipaddresses_ipnetworks
* id : int(10) unsigned
* ipaddresses_id : int(10) unsigned
* ipnetworks_id : int(10) unsigned
v glpi 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 glpi glpi_ipnetworks_vlans
* id : int(10) unsigned
* ipnetworks_id : int(10) unsigned
* vlans_id : int(10) unsigned
v glpi glpi_items_clusters
* id : int(10) unsigned
* clusters_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_items_enclosures
* id : int(10) unsigned
* enclosures_id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* position : int(11)
v glpi 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 glpi 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)
* company : varchar(255)
* owner : varchar(255)
* hostid : 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
v glpi glpi_items_problems
* id : int(10) unsigned
* problems_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpi glpi_items_projects
* id : int(10) unsigned
* projects_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_items_tickets
* id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* tickets_id : int(10) unsigned
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_itils_projects
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* projects_id : int(10) unsigned
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_knowbaseitems_knowbaseitemcategories
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* knowbaseitemcategories_id : int(10) unsigned
v glpi 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 glpi 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 glpi glpi_knowbaseitems_users
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* users_id : int(10) unsigned
v glpi 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 glpi 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 glpi 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 glpi glpi_linetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_manufacturers
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_monitortypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi glpi_networkequipmenttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_networkinterfaces
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v glpi 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 glpi glpi_networkportaggregates
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* networkports_id_list : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_networkportaliases
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* networkports_id_alias : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_networkportconnectionlogs
* id : int(10) unsigned
* date : timestamp
* connected : tinyint(4)
* networkports_id_source : int(10) unsigned
* networkports_id_destination : int(10) unsigned
v glpi glpi_networkportdialups
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_networkportfiberchanneltypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_networkportlocals
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_networkports_networkports
* id : int(10) unsigned
* networkports_id_1 : int(10) unsigned
* networkports_id_2 : int(10) unsigned
v glpi glpi_networkports_vlans
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* vlans_id : int(10) unsigned
* tagged : tinyint(4)
v glpi 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 glpi 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 glpi glpi_networks
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_notifications_notificationtemplates
* id : int(10) unsigned
* notifications_id : int(10) unsigned
* mode : varchar(20)
* notificationtemplates_id : int(10) unsigned
v glpi glpi_notificationtargets
* id : int(10) unsigned
* items_id : int(10) unsigned
* type : int(11)
* notifications_id : int(10) unsigned
v glpi glpi_notificationtemplates
* id : int(10) unsigned
* name : varchar(255)
* itemtype : varchar(100)
* date_mod : timestamp
* comment : text
* css : text
* date_creation : timestamp
v glpi glpi_notificationtemplatetranslations
* id : int(10) unsigned
* notificationtemplates_id : int(10) unsigned
* language : varchar(10)
* subject : varchar(255)
* content_text : text
* content_html : text
v glpi 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 glpi glpi_objectlocks
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* users_id : int(10) unsigned
* date : timestamp
v glpi glpi_olalevelactions
* id : int(10) unsigned
* olalevels_id : int(10) unsigned
* action_type : varchar(255)
* field : varchar(255)
* value : varchar(255)
v glpi glpi_olalevelcriterias
* id : int(10) unsigned
* olalevels_id : int(10) unsigned
* criteria : varchar(255)
* condition : int(11)
* pattern : varchar(255)
v glpi 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 glpi glpi_olalevels_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* olalevels_id : int(10) unsigned
* date : timestamp
v glpi 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 glpi glpi_operatingsystemarchitectures
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_operatingsystemeditions
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_operatingsystemkernels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_operatingsystemkernelversions
* id : int(10) unsigned
* operatingsystemkernels_id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_operatingsystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_operatingsystemservicepacks
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_operatingsystemversions
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_passivedcequipmenttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_peripheraltypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi glpi_phonepowersupplies
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi glpi_phonetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_planningeventcategories
* id : int(10) unsigned
* name : varchar(255)
* color : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_plugs
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_printertypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi glpi_problems_tickets
* id : int(10) unsigned
* problems_id : int(10) unsigned
* tickets_id : int(10) unsigned
v glpi 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 glpi 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 glpi glpi_problemtemplatehiddenfields
* id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* num : int(11)
v glpi glpi_problemtemplatemandatoryfields
* id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* num : int(11)
v glpi glpi_problemtemplatepredefinedfields
* id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* num : int(11)
* value : text
v glpi glpi_problemtemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpi glpi_profilerights
* id : int(10) unsigned
* profiles_id : int(10) unsigned
* name : varchar(255)
* rights : int(11)
v glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_projecttasks_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* projecttasks_id : int(10) unsigned
v glpi glpi_projecttaskteams
* id : int(10) unsigned
* projecttasks_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpi 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 glpi glpi_projecttasktypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_projectteams
* id : int(10) unsigned
* projects_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpi glpi_projecttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi glpi_rackmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* pictures : text
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_registeredids
* id : int(10) unsigned
* name : varchar(255)
* items_id : int(10) unsigned
* itemtype : varchar(100)
* device_type : varchar(100)
v glpi 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 glpi glpi_reminders_users
* id : int(10) unsigned
* reminders_id : int(10) unsigned
* users_id : int(10) unsigned
v glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_rssfeeds_users
* id : int(10) unsigned
* rssfeeds_id : int(10) unsigned
* users_id : int(10) unsigned
v glpi glpi_ruleactions
* id : int(10) unsigned
* rules_id : int(10) unsigned
* action_type : varchar(255)
* field : varchar(255)
* value : varchar(255)
v glpi glpi_rulecriterias
* id : int(10) unsigned
* rules_id : int(10) unsigned
* criteria : varchar(255)
* condition : int(11)
* pattern : text
v glpi 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 glpi glpi_rulerightparameters
* id : int(10) unsigned
* name : varchar(255)
* value : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi glpi_savedsearches_users
* id : int(10) unsigned
* users_id : int(10) unsigned
* itemtype : varchar(100)
* savedsearches_id : int(10) unsigned
v glpi glpi_slalevelactions
* id : int(10) unsigned
* slalevels_id : int(10) unsigned
* action_type : varchar(255)
* field : varchar(255)
* value : varchar(255)
v glpi glpi_slalevelcriterias
* id : int(10) unsigned
* slalevels_id : int(10) unsigned
* criteria : varchar(255)
* condition : int(11)
* pattern : varchar(255)
v glpi 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 glpi glpi_slalevels_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* slalevels_id : int(10) unsigned
* date : timestamp
v glpi 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 glpi 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 glpi 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 glpi glpi_socketmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi glpi_softwarelicenses
* id : int(10) unsigned
* softwares_id : int(10) unsigned
* softwarelicenses_id : int(10) unsigned
* completename : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
* 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
v glpi 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 glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_ssovariables
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi glpi_suppliertypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi 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 glpi 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 glpi 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 glpi 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_tto_begin_date : timestamp
* 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
v glpi 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 glpi glpi_tickets_contracts
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* contracts_id : int(10) unsigned
v glpi glpi_tickets_tickets
* id : int(10) unsigned
* tickets_id_1 : int(10) unsigned
* tickets_id_2 : int(10) unsigned
v glpi 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 glpi 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 glpi glpi_tickettemplatehiddenfields
* id : int(10) unsigned
* tickettemplates_id : int(10) unsigned
* num : int(11)
v glpi glpi_tickettemplatemandatoryfields
* id : int(10) unsigned
* tickettemplates_id : int(10) unsigned
* num : int(11)
v glpi glpi_tickettemplatepredefinedfields
* id : int(10) unsigned
* tickettemplates_id : int(10) unsigned
* num : int(11)
* value : text
v glpi glpi_tickettemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpi 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 glpi 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 glpi 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 glpi 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 glpi glpi_usercategories
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_useremails
* id : int(10) unsigned
* users_id : int(10) unsigned
* is_default : tinyint(4)
* is_dynamic : tinyint(4)
* email : varchar(255)
v glpi 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)
* use_flat_dropdowntree_on_search_result : 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)
v glpi glpi_usertitles
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_virtualmachinestates
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_virtualmachinesystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi glpi_virtualmachinetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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 glpi glpi_vobjects
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* data : text
* date_mod : timestamp
* date_creation : timestamp
v glpi 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