amixlevante.duckdns.org / 127.0.0.1 / inventario

No existen tablas favoritas.

Cambiar la apariencia del panel de navegación.

Panel de navegación

Mostrar las bases de datos navegación como árbol En el panel de navegación, reemplaza el árbol de base de datos con un selector
Enlace al panel principal Enlace con el panel principal resaltando la base de datos o tabla actual.
Mostrar el logo Mostrar el logo en el panel de navegación.
URL para enlace del logo URL a la que apuntará el logo en el panel de navegación.
Logo destino del enlace Abrir la página enlazada en la ventana principal (`principal`) o en una nueva (`nueva`).
Permitir destacar Resaltar servidor bajo el cursor.
Cantidad máxima de elementos en el primer nivel El número de elementos que pueden ser mostrados en cada página en el primer nivel del árbol de navegación.
Número mínimo de elementos para mostrar la caja de filtro Define el número mínimo de elementos (tablas, vistas, rutinas y eventos) para mostrar un cuadro de filtro.
Tablas recientemente utilizadas Número máximo de tablas recientemente utilizadas; 0 para desactivar.
Tablas favoritas Cantidad máxima de tablas favoritas; 0 para desactivar.
Anchura del panel de navegación Asignar 0 para ocular el panel de navegación.

Personalizar el árbol de navegación.

Árbol de navegación

Cantidad máxima de elementos en una rama El número de elementos que pueden ser mostrados en cada página del árbol de navegación.
Agrupar elementos en el árbol Agrupar elementos en el árbol de navegación (determinado por el separador definido abajo en las pestañas superiores de Bases de datos y Tablas).
Activar la expansión del árbol de navegación Si tendrá la posibilidad de expandir el árbol en el panel de navegación.
Mostrar tablas en árbol Si se muestran las tablas bajo base de datos en el árbol de navegación
Mostrar vistas en árbol Si se muestran vistas bajo base de datos en el árbol de navegación
Mostrar funciones en árbol Si se muestran las funciones bajo la base de datos en el árbol de navegación
Mostrar procedimientos en árbol Si se muestran los procedimientos bajo la base de datos en el árbol de navegación
Mostrar eventos en árbol Si se muestran eventos bajo la base de datos en el árbol de navegación
Expandir la base de datos única Si se debe desglosar automáticamente una base de datos individual en el árbol de navegación.

Opciones para visualizar los servidores.

Servidores

Mostrar la selección de servidores Mostrar la elección de servidor en la parte superior del panel de navegación.
Mostrar los servidores en una lista Mostrar los servidores en una lista en lugar de una caja desplegable.

Opciones para visualizar las bases de datos.

Bases de datos

Número mínimo de bases de datos a mostrar en la ventana de filtro de bases de datos
Separador de árbol de base de datos Cadena que separa bases de datos en diferentes niveles de árbol.

Opciones para visualizar las tablas.

Tablas

Destino para el icono de acceso rápido
Objetivo para el segundo icono de acceso rápido
Separador de árbol de tablas Cadena que separa tablas en diferentes niveles de árbol.
Profundidad máxima del árbol de tablas

Suelte aquí los archivos

Carga SQL ( 0 ) x -

Pulse en la barra para deslizarse al tope de la página

Presione Ctrl+Enter para ejecutar la consulta

Colapsar Expandir Mostrar rastro Ocultar rastro Tiempo necesario :

Ningún favorito

Etiqueta: Base de datos de destino: Compartir favorito

Siempre expandir mensajes de consultas
Mostrar histórico de consultas al iniciar
Mostrar consulta de navegación actual
Ejecute consultas en Enter e inserte una nueva línea con Shift+Enter. Para que esto sea permanente, consulte la configuración.
Cambiar al tema oscuro

Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :

Sin título *

v		inventario 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		inventario glpi_agenttypes
id : int(10) unsigned
name : varchar(255)

v		inventario glpi_alerts
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
type : int(11)
date : timestamp

v		inventario 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		inventario glpi_applianceenvironments
id : int(10) unsigned
name : varchar(255)
comment : text

v		inventario 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		inventario glpi_appliances_items
id : int(10) unsigned
appliances_id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)

v		inventario glpi_appliances_items_relations
id : int(10) unsigned
appliances_items_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

v		inventario glpi_appliancetypes
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
comment : text
externalidentifier : varchar(255)

v		inventario glpi_authldapreplicates
id : int(10) unsigned
authldaps_id : int(10) unsigned
host : varchar(255)
port : int(11)
name : varchar(255)
timeout : int(11)

v		inventario 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		inventario 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		inventario glpi_autoupdatesystems
id : int(10) unsigned
name : varchar(255)
comment : text

v		inventario glpi_blacklistedmailcontents
id : int(10) unsigned
name : varchar(255)
content : text
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_blacklists
id : int(10) unsigned
type : int(11)
name : varchar(255)
value : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario glpi_budgettypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario glpi_cablestrands
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_cabletypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario glpi_calendars_holidays
id : int(10) unsigned
calendars_id : int(10) unsigned
holidays_id : int(10) unsigned

v		inventario 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		inventario glpi_cartridgeitems_printermodels
id : int(10) unsigned
cartridgeitems_id : int(10) unsigned
printermodels_id : int(10) unsigned

v		inventario glpi_cartridgeitemtypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_changes_groups
id : int(10) unsigned
changes_id : int(10) unsigned
groups_id : int(10) unsigned
type : int(11)

v		inventario glpi_changes_items
id : int(10) unsigned
changes_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

v		inventario glpi_changes_problems
id : int(10) unsigned
changes_id : int(10) unsigned
problems_id : int(10) unsigned

v		inventario 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		inventario glpi_changes_tickets
id : int(10) unsigned
changes_id : int(10) unsigned
tickets_id : int(10) unsigned

v		inventario 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		inventario 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		inventario glpi_changetemplatehiddenfields
id : int(10) unsigned
changetemplates_id : int(10) unsigned
num : int(11)

v		inventario glpi_changetemplatemandatoryfields
id : int(10) unsigned
changetemplates_id : int(10) unsigned
num : int(11)

v		inventario glpi_changetemplatepredefinedfields
id : int(10) unsigned
changetemplates_id : int(10) unsigned
num : int(11)
value : text

v		inventario glpi_changetemplates
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_computertypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario glpi_configs
id : int(10) unsigned
context : varchar(150)
name : varchar(150)
value : text

v		inventario 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		inventario glpi_consumableitemtypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario glpi_contacts_suppliers
id : int(10) unsigned
suppliers_id : int(10) unsigned
contacts_id : int(10) unsigned

v		inventario glpi_contacttypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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)
max_links_allowed : int(11)
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		inventario glpi_contracts_items
id : int(10) unsigned
contracts_id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)

v		inventario glpi_contracts_suppliers
id : int(10) unsigned
suppliers_id : int(10) unsigned
contracts_id : int(10) unsigned

v		inventario glpi_contracttypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario glpi_dashboards_dashboards
id : int(10) unsigned
key : varchar(100)
name : varchar(100)
context : varchar(100)
users_id : int(10) unsigned

v		inventario glpi_dashboards_filters
id : int(10) unsigned
dashboards_dashboards_id : int(10) unsigned
users_id : int(10) unsigned
filter : longtext

v		inventario 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		inventario glpi_dashboards_rights
id : int(10) unsigned
dashboards_dashboards_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

v		inventario glpi_databaseinstancecategories
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario glpi_databaseinstancetypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_devicebatterymodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario glpi_devicebatterytypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_devicecameramodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_devicecasemodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_devicecasetypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_devicecontrolmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_devicedrivemodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_devicefirmwaremodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_devicefirmwaretypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_devicegenericmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_devicegenerictypes
id : int(10) unsigned
name : varchar(255)
comment : text

v		inventario glpi_devicegraphiccardmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_deviceharddrivemodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario 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		inventario glpi_devicememorymodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario glpi_devicememorytypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_devicemotherboardmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_devicenetworkcardmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_devicepcimodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario 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		inventario glpi_devicepowersupplymodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario glpi_deviceprocessormodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_devicesensormodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_devicesensortypes
id : int(10) unsigned
name : varchar(255)
comment : text

v		inventario 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		inventario glpi_devicesimcardtypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_devicesoundcardmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		inventario 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		inventario glpi_displaypreferences
id : int(10) unsigned
itemtype : varchar(100)
num : int(11)
rank : int(11)
users_id : int(10) unsigned

v		inventario 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		inventario 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)
link : varchar(255)
users_id : int(10) unsigned
tickets_id : int(10) unsigned
sha1sum : char(40)
is_blacklisted : tinyint(4)
tag : varchar(255)
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario glpi_domainrecordtypes
id : int(10) unsigned
name : varchar(255)
fields : text
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text

v		inventario glpi_domainrelations
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text

v		inventario 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		inventario 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		inventario glpi_domaintypes
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text

v		inventario glpi_dropdowntranslations
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
language : varchar(10)
field : varchar(100)
value : text

v		inventario 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		inventario 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		inventario 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		inventario glpi_entities_knowbaseitems
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)

v		inventario glpi_entities_reminders
id : int(10) unsigned
reminders_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)

v		inventario glpi_entities_rssfeeds
id : int(10) unsigned
rssfeeds_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)

v		inventario 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		inventario 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		inventario 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		inventario glpi_filesystems
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario glpi_groups_problems
id : int(10) unsigned
problems_id : int(10) unsigned
groups_id : int(10) unsigned
type : int(11)

v		inventario 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		inventario 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		inventario glpi_groups_tickets
id : int(10) unsigned
tickets_id : int(10) unsigned
groups_id : int(10) unsigned
type : int(11)

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_impactcompounds
id : int(10) unsigned
name : varchar(255)
color : varchar(255)

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_interfacetypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario glpi_ipaddresses_ipnetworks
id : int(10) unsigned
ipaddresses_id : int(10) unsigned
ipnetworks_id : int(10) unsigned

v		inventario 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		inventario glpi_ipnetworks_vlans
id : int(10) unsigned
ipnetworks_id : int(10) unsigned
vlans_id : int(10) unsigned

v		inventario glpi_items_clusters
id : int(10) unsigned
clusters_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_items_enclosures
id : int(10) unsigned
enclosures_id : int(10) unsigned
itemtype : varchar(255)
items_id : int(10) unsigned
position : int(11)

v		inventario 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		inventario 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		inventario glpi_items_problems
id : int(10) unsigned
problems_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

v		inventario glpi_items_projects
id : int(10) unsigned
projects_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_items_tickets
id : int(10) unsigned
itemtype : varchar(255)
items_id : int(10) unsigned
tickets_id : int(10) unsigned

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_itils_projects
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
projects_id : int(10) unsigned

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_knowbaseitems_knowbaseitemcategories
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
knowbaseitemcategories_id : int(10) unsigned

v		inventario 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		inventario 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		inventario glpi_knowbaseitems_users
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
users_id : int(10) unsigned

v		inventario 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		inventario 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		inventario 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		inventario glpi_linetypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_links
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
link : varchar(255)
data : text
open_window : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_links_itemtypes
id : int(10) unsigned
links_id : int(10) unsigned
itemtype : varchar(100)

v		inventario 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		inventario 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		inventario glpi_logs
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
itemtype_link : varchar(100)
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		inventario 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		inventario glpi_manuallinks
id : int(10) unsigned
name : varchar(255)
url : varchar(8096)
open_window : tinyint(4)
icon : varchar(255)
comment : text
items_id : int(10) unsigned
itemtype : varchar(255)
date_creation : timestamp
date_mod : timestamp

v		inventario glpi_manufacturers
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario glpi_monitortypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario glpi_networkequipmenttypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_networkinterfaces
id : int(10) unsigned
name : varchar(255)
comment : text

v		inventario 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		inventario glpi_networkportaggregates
id : int(10) unsigned
networkports_id : int(10) unsigned
networkports_id_list : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_networkportaliases
id : int(10) unsigned
networkports_id : int(10) unsigned
networkports_id_alias : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_networkportconnectionlogs
id : int(10) unsigned
date : timestamp
connected : tinyint(4)
networkports_id_source : int(10) unsigned
networkports_id_destination : int(10) unsigned

v		inventario glpi_networkportdialups
id : int(10) unsigned
networkports_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario glpi_networkportfiberchanneltypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_networkportlocals
id : int(10) unsigned
networkports_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario glpi_networkports_networkports
id : int(10) unsigned
networkports_id_1 : int(10) unsigned
networkports_id_2 : int(10) unsigned

v		inventario glpi_networkports_vlans
id : int(10) unsigned
networkports_id : int(10) unsigned
vlans_id : int(10) unsigned
tagged : tinyint(4)

v		inventario 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		inventario 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		inventario glpi_networks
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario glpi_notifications_notificationtemplates
id : int(10) unsigned
notifications_id : int(10) unsigned
mode : varchar(20)
notificationtemplates_id : int(10) unsigned

v		inventario glpi_notificationtargets
id : int(10) unsigned
items_id : int(10) unsigned
type : int(11)
notifications_id : int(10) unsigned

v		inventario glpi_notificationtemplates
id : int(10) unsigned
name : varchar(255)
itemtype : varchar(100)
date_mod : timestamp
comment : text
css : text
date_creation : timestamp

v		inventario glpi_notificationtemplatetranslations
id : int(10) unsigned
notificationtemplates_id : int(10) unsigned
language : varchar(10)
subject : varchar(255)
content_text : text
content_html : text

v		inventario 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		inventario glpi_objectlocks
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
users_id : int(10) unsigned
date : timestamp

v		inventario glpi_olalevelactions
id : int(10) unsigned
olalevels_id : int(10) unsigned
action_type : varchar(255)
field : varchar(255)
value : varchar(255)

v		inventario glpi_olalevelcriterias
id : int(10) unsigned
olalevels_id : int(10) unsigned
criteria : varchar(255)
condition : int(11)
pattern : varchar(255)

v		inventario 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		inventario glpi_olalevels_tickets
id : int(10) unsigned
tickets_id : int(10) unsigned
olalevels_id : int(10) unsigned
date : timestamp

v		inventario 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		inventario glpi_operatingsystemarchitectures
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_operatingsystemeditions
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_operatingsystemkernels
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_operatingsystemkernelversions
id : int(10) unsigned
operatingsystemkernels_id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_operatingsystems
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_operatingsystemservicepacks
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_operatingsystemversions
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario glpi_passivedcequipmenttypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_peripheraltypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario glpi_phonepowersupplies
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario glpi_phonetypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_planningeventcategories
id : int(10) unsigned
name : varchar(255)
color : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_plugs
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_printertypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario glpi_problems_tickets
id : int(10) unsigned
problems_id : int(10) unsigned
tickets_id : int(10) unsigned

v		inventario 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		inventario 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		inventario glpi_problemtemplatehiddenfields
id : int(10) unsigned
problemtemplates_id : int(10) unsigned
num : int(11)

v		inventario glpi_problemtemplatemandatoryfields
id : int(10) unsigned
problemtemplates_id : int(10) unsigned
num : int(11)

v		inventario glpi_problemtemplatepredefinedfields
id : int(10) unsigned
problemtemplates_id : int(10) unsigned
num : int(11)
value : text

v		inventario glpi_problemtemplates
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text

v		inventario glpi_profilerights
id : int(10) unsigned
profiles_id : int(10) unsigned
name : varchar(255)
rights : int(11)

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_projecttasklinks
id : int(10) unsigned
projecttasks_id_source : int(10) unsigned
source_uuid : varchar(255)
projecttasks_id_target : int(10) unsigned
target_uuid : varchar(255)
type : tinyint(4)
lag : smallint(6)
lead : smallint(6)

v		inventario 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		inventario glpi_projecttasks_tickets
id : int(10) unsigned
tickets_id : int(10) unsigned
projecttasks_id : int(10) unsigned

v		inventario glpi_projecttaskteams
id : int(10) unsigned
projecttasks_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

v		inventario 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		inventario glpi_projecttasktypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_projectteams
id : int(10) unsigned
projects_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

v		inventario glpi_projecttypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario glpi_rackmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
date_mod : timestamp
date_creation : timestamp
pictures : text

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_registeredids
id : int(10) unsigned
name : varchar(255)
items_id : int(10) unsigned
itemtype : varchar(100)
device_type : varchar(100)

v		inventario 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		inventario glpi_reminders_users
id : int(10) unsigned
reminders_id : int(10) unsigned
users_id : int(10) unsigned

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_rssfeeds_users
id : int(10) unsigned
rssfeeds_id : int(10) unsigned
users_id : int(10) unsigned

v		inventario glpi_ruleactions
id : int(10) unsigned
rules_id : int(10) unsigned
action_type : varchar(255)
field : varchar(255)
value : varchar(255)

v		inventario glpi_rulecriterias
id : int(10) unsigned
rules_id : int(10) unsigned
criteria : varchar(255)
condition : int(11)
pattern : text

v		inventario 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		inventario glpi_rulerightparameters
id : int(10) unsigned
name : varchar(255)
value : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario glpi_savedsearches_users
id : int(10) unsigned
users_id : int(10) unsigned
itemtype : varchar(100)
savedsearches_id : int(10) unsigned

v		inventario glpi_slalevelactions
id : int(10) unsigned
slalevels_id : int(10) unsigned
action_type : varchar(255)
field : varchar(255)
value : varchar(255)

v		inventario glpi_slalevelcriterias
id : int(10) unsigned
slalevels_id : int(10) unsigned
criteria : varchar(255)
condition : int(11)
pattern : varchar(255)

v		inventario 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		inventario glpi_slalevels_tickets
id : int(10) unsigned
tickets_id : int(10) unsigned
slalevels_id : int(10) unsigned
date : timestamp

v		inventario 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		inventario 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		inventario 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		inventario glpi_socketmodels
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_ssovariables
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario glpi_suppliertypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario 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		inventario glpi_tickets_contracts
id : int(10) unsigned
tickets_id : int(10) unsigned
contracts_id : int(10) unsigned

v		inventario glpi_tickets_tickets
id : int(10) unsigned
tickets_id_1 : int(10) unsigned
tickets_id_2 : int(10) unsigned
link : int(11)

v		inventario 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		inventario 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		inventario glpi_tickettemplatehiddenfields
id : int(10) unsigned
tickettemplates_id : int(10) unsigned
num : int(11)

v		inventario glpi_tickettemplatemandatoryfields
id : int(10) unsigned
tickettemplates_id : int(10) unsigned
num : int(11)

v		inventario glpi_tickettemplatepredefinedfields
id : int(10) unsigned
tickettemplates_id : int(10) unsigned
num : int(11)
value : text

v		inventario glpi_tickettemplates
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text

v		inventario 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		inventario glpi_transfers
id : int(10) unsigned
name : varchar(255)
keep_ticket : int(11)
keep_networklink : 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		inventario 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		inventario 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		inventario glpi_usercategories
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_useremails
id : int(10) unsigned
users_id : int(10) unsigned
is_default : tinyint(4)
is_dynamic : tinyint(4)
email : varchar(255)

v		inventario 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)
fold_search : 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		inventario glpi_usertitles
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_virtualmachinestates
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_virtualmachinesystems
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario glpi_virtualmachinetypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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		inventario glpi_vobjects
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
data : text
date_mod : timestamp
date_creation : timestamp

v		inventario 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