desarrollodetic.com:8080 / 127.0.0.1 / glpi_2

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		glpi_2 glpi_agents
id : int(10) unsigned
deviceid : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
agenttypes_id : int(10) unsigned
last_contact : timestamp
version : varchar(255)
locked : tinyint(4)
itemtype : varchar(100)
items_id : int(10) unsigned
useragent : varchar(255)
tag : varchar(255)
port : varchar(6)
remote_addr : varchar(255)
threads_networkdiscovery : int(11)
threads_networkinventory : int(11)
timeout_networkdiscovery : int(11)
timeout_networkinventory : int(11)
use_module_wake_on_lan : tinyint(4)
use_module_computer_inventory : tinyint(4)
use_module_esx_remote_inventory : tinyint(4)
use_module_remote_inventory : tinyint(4)
use_module_network_inventory : tinyint(4)
use_module_network_discovery : tinyint(4)
use_module_package_deployment : tinyint(4)
use_module_collect_data : tinyint(4)

v		glpi_2 glpi_agenttypes
id : int(10) unsigned
name : varchar(255)

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

v		glpi_2 glpi_apiclients
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
date_mod : timestamp
date_creation : timestamp
is_active : tinyint(4)
ipv4_range_start : bigint(20)
ipv4_range_end : bigint(20)
ipv6 : varchar(255)
app_token : varchar(255)
app_token_date : timestamp
dolog_method : tinyint(4)
comment : text

v		glpi_2 glpi_applianceenvironments
id : int(10) unsigned
name : varchar(255)
comment : text

v		glpi_2 glpi_appliances
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
is_deleted : tinyint(4)
appliancetypes_id : int(10) unsigned
comment : text
locations_id : int(10) unsigned
manufacturers_id : int(10) unsigned
applianceenvironments_id : int(10) unsigned
users_id : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id : int(10) unsigned
groups_id_tech : int(10) unsigned
date_mod : timestamp
date_creation : timestamp
states_id : int(10) unsigned
externalidentifier : varchar(255)
serial : varchar(255)
otherserial : varchar(255)
contact : varchar(255)
contact_num : varchar(255)
is_helpdesk_visible : tinyint(4)
pictures : text

v		glpi_2 glpi_appliances_items
id : int(10) unsigned
appliances_id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)

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

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

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

v		glpi_2 glpi_authldaps
id : int(10) unsigned
name : varchar(255)
host : varchar(255)
basedn : varchar(255)
rootdn : varchar(255)
port : int(11)
condition : text
login_field : varchar(255)
sync_field : varchar(255)
use_tls : tinyint(4)
group_field : varchar(255)
group_condition : text
group_search_type : int(11)
group_member_field : varchar(255)
email1_field : varchar(255)
realname_field : varchar(255)
firstname_field : varchar(255)
phone_field : varchar(255)
phone2_field : varchar(255)
mobile_field : varchar(255)
comment_field : varchar(255)
use_dn : tinyint(4)
time_offset : int(11)
deref_option : int(11)
title_field : varchar(255)
category_field : varchar(255)
language_field : varchar(255)
entity_field : varchar(255)
entity_condition : text
date_mod : timestamp
comment : text
is_default : tinyint(4)
is_active : tinyint(4)
rootdn_passwd : varchar(255)
registration_number_field : varchar(255)
email2_field : varchar(255)
email3_field : varchar(255)
email4_field : varchar(255)
location_field : varchar(255)
responsible_field : varchar(255)
pagesize : int(11)
ldap_maxlimit : int(11)
can_support_pagesize : tinyint(4)
picture_field : varchar(255)
date_creation : timestamp
inventory_domain : varchar(255)
tls_certfile : text
tls_keyfile : text
use_bind : tinyint(4)
timeout : int(11)

v		glpi_2 glpi_authmails
id : int(10) unsigned
name : varchar(255)
connect_string : varchar(255)
host : varchar(255)
date_mod : timestamp
date_creation : timestamp
comment : text
is_active : tinyint(4)

v		glpi_2 glpi_autoupdatesystems
id : int(10) unsigned
name : varchar(255)
comment : text

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

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

v		glpi_2 glpi_budgets
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text
is_deleted : tinyint(4)
begin_date : date
end_date : date
value : decimal(20,4)
is_template : tinyint(4)
template_name : varchar(255)
date_mod : timestamp
date_creation : timestamp
locations_id : int(10) unsigned
budgettypes_id : int(10) unsigned

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

v		glpi_2 glpi_businesscriticities
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text
date_mod : timestamp
date_creation : timestamp
businesscriticities_id : int(10) unsigned
completename : text
level : int(11)
ancestors_cache : longtext
sons_cache : longtext

v		glpi_2 glpi_cables
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
itemtype_endpoint_a : varchar(255)
itemtype_endpoint_b : varchar(255)
items_id_endpoint_a : int(10) unsigned
items_id_endpoint_b : int(10) unsigned
socketmodels_id_endpoint_a : int(10) unsigned
socketmodels_id_endpoint_b : int(10) unsigned
sockets_id_endpoint_a : int(10) unsigned
sockets_id_endpoint_b : int(10) unsigned
cablestrands_id : int(10) unsigned
color : varchar(255)
otherserial : varchar(255)
states_id : int(10) unsigned
users_id_tech : int(10) unsigned
cabletypes_id : int(10) unsigned
comment : text
date_mod : timestamp
date_creation : timestamp
is_deleted : tinyint(4)

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

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

v		glpi_2 glpi_calendars
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text
date_mod : timestamp
cache_duration : text
date_creation : timestamp

v		glpi_2 glpi_calendarsegments
id : int(10) unsigned
calendars_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
day : tinyint(4)
begin : time
end : time

v		glpi_2 glpi_calendars_holidays
id : int(10) unsigned
calendars_id : int(10) unsigned
holidays_id : int(10) unsigned

v		glpi_2 glpi_cartridgeitems
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
ref : varchar(255)
locations_id : int(10) unsigned
cartridgeitemtypes_id : int(10) unsigned
manufacturers_id : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
is_deleted : tinyint(4)
comment : text
alarm_threshold : int(11)
stock_target : int(11)
date_mod : timestamp
date_creation : timestamp
pictures : text

v		glpi_2 glpi_cartridgeitems_printermodels
id : int(10) unsigned
cartridgeitems_id : int(10) unsigned
printermodels_id : int(10) unsigned

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

v		glpi_2 glpi_cartridges
id : int(10) unsigned
entities_id : int(10) unsigned
cartridgeitems_id : int(10) unsigned
printers_id : int(10) unsigned
date_in : date
date_use : date
date_out : date
pages : int(11)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_certificates
id : int(10) unsigned
name : varchar(255)
serial : varchar(255)
otherserial : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text
is_deleted : tinyint(4)
is_template : tinyint(4)
template_name : varchar(255)
certificatetypes_id : int(10) unsigned
dns_name : varchar(255)
dns_suffix : varchar(255)
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
locations_id : int(10) unsigned
manufacturers_id : int(10) unsigned
contact : varchar(255)
contact_num : varchar(255)
users_id : int(10) unsigned
groups_id : int(10) unsigned
is_autosign : tinyint(4)
date_expiration : date
states_id : int(10) unsigned
command : text
certificate_request : text
certificate_item : text
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_certificates_items
id : int(10) unsigned
certificates_id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_certificatetypes
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
comment : text
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_changecosts
id : int(10) unsigned
changes_id : int(10) unsigned
name : varchar(255)
comment : text
begin_date : date
end_date : date
actiontime : int(11)
cost_time : decimal(20,4)
cost_fixed : decimal(20,4)
cost_material : decimal(20,4)
budgets_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)

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

v		glpi_2 glpi_changes_groups
id : int(10) unsigned
changes_id : int(10) unsigned
groups_id : int(10) unsigned
type : int(11)

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

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

v		glpi_2 glpi_changes_suppliers
id : int(10) unsigned
changes_id : int(10) unsigned
suppliers_id : int(10) unsigned
type : int(11)
use_notification : tinyint(4)
alternative_email : varchar(255)

v		glpi_2 glpi_changes_tickets
id : int(10) unsigned
changes_id : int(10) unsigned
tickets_id : int(10) unsigned

v		glpi_2 glpi_changes_users
id : int(10) unsigned
changes_id : int(10) unsigned
users_id : int(10) unsigned
type : int(11)
use_notification : tinyint(4)
alternative_email : varchar(255)

v		glpi_2 glpi_changetasks
id : int(10) unsigned
uuid : varchar(255)
changes_id : int(10) unsigned
taskcategories_id : int(10) unsigned
state : int(11)
date : timestamp
begin : timestamp
end : timestamp
users_id : int(10) unsigned
users_id_editor : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
content : longtext
actiontime : int(11)
date_mod : timestamp
date_creation : timestamp
tasktemplates_id : int(10) unsigned
timeline_position : tinyint(4)
is_private : tinyint(4)

v		glpi_2 glpi_changetemplatehiddenfields
id : int(10) unsigned
changetemplates_id : int(10) unsigned
num : int(11)

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

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

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

v		glpi_2 glpi_changevalidations
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
users_id : int(10) unsigned
changes_id : int(10) unsigned
users_id_validate : int(10) unsigned
comment_submission : text
comment_validation : text
status : int(11)
submission_date : timestamp
validation_date : timestamp
timeline_position : tinyint(4)

v		glpi_2 glpi_clusters
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
uuid : varchar(255)
version : varchar(255)
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
is_deleted : tinyint(4)
states_id : int(10) unsigned
comment : text
clustertypes_id : int(10) unsigned
autoupdatesystems_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_clustertypes
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
comment : text
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_computerantiviruses
id : int(10) unsigned
computers_id : int(10) unsigned
name : varchar(255)
manufacturers_id : int(10) unsigned
antivirus_version : varchar(255)
signature_version : varchar(255)
is_active : tinyint(4)
is_deleted : tinyint(4)
is_uptodate : tinyint(4)
is_dynamic : tinyint(4)
date_expiration : timestamp
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_computermodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
weight : int(11)
required_units : int(11)
depth : float
power_connections : int(11)
power_consumption : int(11)
is_half_rack : tinyint(4)
picture_front : text
picture_rear : text
pictures : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_computers
id : int(10) unsigned
entities_id : int(10) unsigned
name : varchar(255)
serial : varchar(255)
otherserial : varchar(255)
contact : varchar(255)
contact_num : varchar(255)
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
comment : text
date_mod : timestamp
autoupdatesystems_id : int(10) unsigned
locations_id : int(10) unsigned
networks_id : int(10) unsigned
computermodels_id : int(10) unsigned
computertypes_id : int(10) unsigned
is_template : tinyint(4)
template_name : varchar(255)
manufacturers_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
users_id : int(10) unsigned
groups_id : int(10) unsigned
states_id : int(10) unsigned
ticket_tco : decimal(20,4)
uuid : varchar(255)
date_creation : timestamp
is_recursive : tinyint(4)
last_inventory_update : timestamp
last_boot : timestamp

v		glpi_2 glpi_computers_items
id : int(10) unsigned
items_id : int(10) unsigned
computers_id : int(10) unsigned
itemtype : varchar(100)
is_deleted : tinyint(4)
is_dynamic : tinyint(4)

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

v		glpi_2 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 : varchar(255)
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
comment : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_configs
id : int(10) unsigned
context : varchar(150)
name : varchar(150)
value : text

v		glpi_2 glpi_consumableitems
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
ref : varchar(255)
locations_id : int(10) unsigned
consumableitemtypes_id : int(10) unsigned
manufacturers_id : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
is_deleted : tinyint(4)
comment : text
alarm_threshold : int(11)
stock_target : int(11)
date_mod : timestamp
date_creation : timestamp
otherserial : varchar(255)
pictures : text

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

v		glpi_2 glpi_consumables
id : int(10) unsigned
entities_id : int(10) unsigned
consumableitems_id : int(10) unsigned
date_in : date
date_out : date
itemtype : varchar(100)
items_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_contacts
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
firstname : varchar(255)
registration_number : varchar(255)
phone : varchar(255)
phone2 : varchar(255)
mobile : varchar(255)
fax : varchar(255)
email : varchar(255)
contacttypes_id : int(10) unsigned
comment : text
is_deleted : tinyint(4)
usertitles_id : int(10) unsigned
address : text
postcode : varchar(255)
town : varchar(255)
state : varchar(255)
country : varchar(255)
date_mod : timestamp
date_creation : timestamp
pictures : text

v		glpi_2 glpi_contacts_suppliers
id : int(10) unsigned
suppliers_id : int(10) unsigned
contacts_id : int(10) unsigned

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

v		glpi_2 glpi_contractcosts
id : int(10) unsigned
contracts_id : int(10) unsigned
name : varchar(255)
comment : text
begin_date : date
end_date : date
cost : decimal(20,4)
budgets_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)

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

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

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

v		glpi_2 glpi_crontasklogs
id : int(10) unsigned
crontasks_id : int(10) unsigned
crontasklogs_id : int(10) unsigned
date : timestamp
state : int(11)
elapsed : float
volume : int(11)
content : varchar(255)

v		glpi_2 glpi_crontasks
id : int(10) unsigned
itemtype : varchar(100)
name : varchar(150)
frequency : int(11)
param : int(11)
state : int(11)
mode : int(11)
allowmode : int(11)
hourmin : int(11)
hourmax : int(11)
logs_lifetime : int(11)
lastrun : timestamp
lastcode : int(11)
comment : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_dashboards_dashboards
id : int(10) unsigned
key : varchar(100)
name : varchar(100)
context : varchar(100)
users_id : int(10) unsigned

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

v		glpi_2 glpi_dashboards_items
id : int(10) unsigned
dashboards_dashboards_id : int(10) unsigned
gridstack_id : varchar(255)
card_id : varchar(255)
x : int(11)
y : int(11)
width : int(11)
height : int(11)
card_options : text

v		glpi_2 glpi_dashboards_rights
id : int(10) unsigned
dashboards_dashboards_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

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

v		glpi_2 glpi_databaseinstances
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
version : varchar(255)
port : varchar(10)
path : varchar(255)
size : int(11)
databaseinstancetypes_id : int(10) unsigned
databaseinstancecategories_id : int(10) unsigned
locations_id : int(10) unsigned
manufacturers_id : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
states_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
is_onbackup : tinyint(4)
is_active : tinyint(4)
is_deleted : tinyint(4)
is_helpdesk_visible : tinyint(4)
is_dynamic : tinyint(4)
autoupdatesystems_id : int(10) unsigned
date_creation : timestamp
date_mod : timestamp
date_lastboot : timestamp
date_lastbackup : timestamp
comment : text

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

v		glpi_2 glpi_databases
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
size : int(11)
databaseinstances_id : int(10) unsigned
is_onbackup : tinyint(4)
is_active : tinyint(4)
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
date_creation : timestamp
date_mod : timestamp
date_update : timestamp
date_lastbackup : timestamp

v		glpi_2 glpi_datacenters
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
locations_id : int(10) unsigned
is_deleted : tinyint(4)
date_mod : timestamp
date_creation : timestamp
pictures : text

v		glpi_2 glpi_dcrooms
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
locations_id : int(10) unsigned
vis_cols : int(11)
vis_rows : int(11)
blueprint : text
datacenters_id : int(10) unsigned
is_deleted : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicebatteries
id : int(10) unsigned
designation : varchar(255)
comment : text
manufacturers_id : int(10) unsigned
voltage : int(11)
capacity : int(11)
devicebatterytypes_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicebatterymodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicebatterymodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

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

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

v		glpi_2 glpi_devicecameras
id : int(10) unsigned
designation : varchar(255)
flashunit : tinyint(4)
lensfacing : varchar(255)
orientation : varchar(255)
focallength : varchar(255)
sensorsize : varchar(255)
comment : text
manufacturers_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicecameramodels_id : int(10) unsigned
support : varchar(255)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicecasemodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		glpi_2 glpi_devicecases
id : int(10) unsigned
designation : varchar(255)
devicecasetypes_id : int(10) unsigned
comment : text
manufacturers_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicecasemodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

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

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

v		glpi_2 glpi_devicecontrols
id : int(10) unsigned
designation : varchar(255)
is_raid : tinyint(4)
comment : text
manufacturers_id : int(10) unsigned
interfacetypes_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicecontrolmodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicedrivemodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		glpi_2 glpi_devicedrives
id : int(10) unsigned
designation : varchar(255)
is_writer : tinyint(4)
speed : varchar(255)
comment : text
manufacturers_id : int(10) unsigned
interfacetypes_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicedrivemodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicefirmwaremodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		glpi_2 glpi_devicefirmwares
id : int(10) unsigned
designation : varchar(255)
comment : text
manufacturers_id : int(10) unsigned
date : date
version : varchar(255)
devicefirmwaretypes_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicefirmwaremodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

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

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

v		glpi_2 glpi_devicegenerics
id : int(10) unsigned
designation : varchar(255)
devicegenerictypes_id : int(10) unsigned
comment : text
manufacturers_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
locations_id : int(10) unsigned
states_id : int(10) unsigned
devicegenericmodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicegenerictypes
id : int(10) unsigned
name : varchar(255)
comment : text

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

v		glpi_2 glpi_devicegraphiccards
id : int(10) unsigned
designation : varchar(255)
interfacetypes_id : int(10) unsigned
comment : text
manufacturers_id : int(10) unsigned
memory_default : int(11)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicegraphiccardmodels_id : int(10) unsigned
chipset : varchar(255)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_deviceharddrivemodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		glpi_2 glpi_deviceharddrives
id : int(10) unsigned
designation : varchar(255)
rpm : varchar(255)
interfacetypes_id : int(10) unsigned
cache : varchar(255)
comment : text
manufacturers_id : int(10) unsigned
capacity_default : int(11)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
deviceharddrivemodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicememories
id : int(10) unsigned
designation : varchar(255)
frequence : varchar(255)
comment : text
manufacturers_id : int(10) unsigned
size_default : int(11)
devicememorytypes_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicememorymodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicememorymodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

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

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

v		glpi_2 glpi_devicemotherboards
id : int(10) unsigned
designation : varchar(255)
chipset : varchar(255)
comment : text
manufacturers_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicemotherboardmodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicenetworkcardmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		glpi_2 glpi_devicenetworkcards
id : int(10) unsigned
designation : varchar(255)
bandwidth : varchar(255)
comment : text
manufacturers_id : int(10) unsigned
mac_default : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicenetworkcardmodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicepcimodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		glpi_2 glpi_devicepcis
id : int(10) unsigned
designation : varchar(255)
comment : text
manufacturers_id : int(10) unsigned
devicenetworkcardmodels_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicepcimodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicepowersupplies
id : int(10) unsigned
designation : varchar(255)
power : varchar(255)
is_atx : tinyint(4)
comment : text
manufacturers_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicepowersupplymodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicepowersupplymodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

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

v		glpi_2 glpi_deviceprocessors
id : int(10) unsigned
designation : varchar(255)
frequence : int(11)
comment : text
manufacturers_id : int(10) unsigned
frequency_default : int(11)
nbcores_default : int(11)
nbthreads_default : int(11)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
deviceprocessormodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicesensormodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)

v		glpi_2 glpi_devicesensors
id : int(10) unsigned
designation : varchar(255)
devicesensortypes_id : int(10) unsigned
devicesensormodels_id : int(10) unsigned
comment : text
manufacturers_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
locations_id : int(10) unsigned
states_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_devicesensortypes
id : int(10) unsigned
name : varchar(255)
comment : text

v		glpi_2 glpi_devicesimcards
id : int(10) unsigned
designation : varchar(255)
comment : text
entities_id : int(10) unsigned
is_recursive : tinyint(4)
manufacturers_id : int(10) unsigned
voltage : int(11)
devicesimcardtypes_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp
allow_voip : tinyint(4)

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

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

v		glpi_2 glpi_devicesoundcards
id : int(10) unsigned
designation : varchar(255)
type : varchar(255)
comment : text
manufacturers_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
devicesoundcardmodels_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_displaypreferences
id : int(10) unsigned
itemtype : varchar(100)
num : int(11)
rank : int(11)
users_id : int(10) unsigned

v		glpi_2 glpi_documentcategories
id : int(10) unsigned
name : varchar(255)
comment : text
documentcategories_id : int(10) unsigned
completename : text
level : int(11)
ancestors_cache : longtext
sons_cache : longtext
date_mod : timestamp
date_creation : timestamp

v		glpi_2 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		glpi_2 glpi_documents_items
id : int(10) unsigned
documents_id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
date_mod : timestamp
users_id : int(10) unsigned
timeline_position : tinyint(4)
date_creation : timestamp
date : timestamp

v		glpi_2 glpi_documenttypes
id : int(10) unsigned
name : varchar(255)
ext : varchar(255)
icon : varchar(255)
mime : varchar(255)
is_uploadable : tinyint(4)
date_mod : timestamp
comment : text
date_creation : timestamp

v		glpi_2 glpi_domainrecords
id : int(10) unsigned
name : varchar(255)
data : text
data_obj : text
entities_id : int(10) unsigned
is_recursive : tinyint(4)
domains_id : int(10) unsigned
domainrecordtypes_id : int(10) unsigned
ttl : int(11)
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
is_deleted : tinyint(4)
comment : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_domainrecordtypes
id : int(10) unsigned
name : varchar(255)
fields : text
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text

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

v		glpi_2 glpi_domains
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
domaintypes_id : int(10) unsigned
date_expiration : timestamp
date_domaincreation : timestamp
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
is_deleted : tinyint(4)
comment : text
is_template : tinyint(4)
template_name : varchar(255)
is_active : tinyint(4)
date_mod : timestamp
date_creation : timestamp

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

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

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

v		glpi_2 glpi_enclosuremodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
weight : int(11)
required_units : int(11)
depth : float
power_connections : int(11)
power_consumption : int(11)
is_half_rack : tinyint(4)
picture_front : text
picture_rear : text
pictures : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_enclosures
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
locations_id : int(10) unsigned
serial : varchar(255)
otherserial : varchar(255)
enclosuremodels_id : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
is_template : tinyint(4)
template_name : varchar(255)
is_deleted : tinyint(4)
orientation : tinyint(4)
power_supplies : tinyint(4)
states_id : int(10) unsigned
comment : text
manufacturers_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

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

v		glpi_2 glpi_entities_knowbaseitems
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)

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

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

v		glpi_2 glpi_events
id : int(10) unsigned
items_id : int(10) unsigned
type : varchar(255)
date : timestamp
service : varchar(255)
level : int(11)
message : text

v		glpi_2 glpi_fieldblacklists
id : int(10) unsigned
name : varchar(255)
field : varchar(255)
value : varchar(255)
itemtype : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_fieldunicities
id : int(10) unsigned
name : varchar(255)
is_recursive : tinyint(4)
itemtype : varchar(255)
entities_id : int(10) unsigned
fields : text
is_active : tinyint(4)
action_refuse : tinyint(4)
action_notify : tinyint(4)
comment : text
date_mod : timestamp
date_creation : timestamp

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

v		glpi_2 glpi_fqdns
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
fqdn : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_groups
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
comment : text
ldap_field : varchar(255)
ldap_value : text
ldap_group_dn : text
date_mod : timestamp
groups_id : int(10) unsigned
completename : text
level : int(11)
ancestors_cache : longtext
sons_cache : longtext
is_requester : tinyint(4)
is_watcher : tinyint(4)
is_assign : tinyint(4)
is_task : tinyint(4)
is_notify : tinyint(4)
is_itemgroup : tinyint(4)
is_usergroup : tinyint(4)
is_manager : tinyint(4)
date_creation : timestamp

v		glpi_2 glpi_groups_knowbaseitems
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
groups_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
no_entity_restriction : tinyint(4)

v		glpi_2 glpi_groups_problems
id : int(10) unsigned
problems_id : int(10) unsigned
groups_id : int(10) unsigned
type : int(11)

v		glpi_2 glpi_groups_reminders
id : int(10) unsigned
reminders_id : int(10) unsigned
groups_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
no_entity_restriction : tinyint(4)

v		glpi_2 glpi_groups_rssfeeds
id : int(10) unsigned
rssfeeds_id : int(10) unsigned
groups_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
no_entity_restriction : tinyint(4)

v		glpi_2 glpi_groups_tickets
id : int(10) unsigned
tickets_id : int(10) unsigned
groups_id : int(10) unsigned
type : int(11)

v		glpi_2 glpi_groups_users
id : int(10) unsigned
users_id : int(10) unsigned
groups_id : int(10) unsigned
is_dynamic : tinyint(4)
is_manager : tinyint(4)
is_userdelegate : tinyint(4)

v		glpi_2 glpi_holidays
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text
begin_date : date
end_date : date
is_perpetual : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_imageformats
id : int(10) unsigned
name : varchar(255)
date_mod : timestamp
comment : text
date_creation : timestamp
entities_id : int(10) unsigned
is_recursive : tinyint(4)

v		glpi_2 glpi_imageresolutions
id : int(10) unsigned
name : varchar(255)
is_video : tinyint(4)
date_mod : timestamp
comment : text
date_creation : timestamp
entities_id : int(10) unsigned
is_recursive : tinyint(4)

v		glpi_2 glpi_impactcompounds
id : int(10) unsigned
name : varchar(255)
color : varchar(255)

v		glpi_2 glpi_impactcontexts
id : int(10) unsigned
positions : mediumtext
zoom : float
pan_x : float
pan_y : float
impact_color : varchar(255)
depends_color : varchar(255)
impact_and_depends_color : varchar(255)
show_depends : tinyint(4)
show_impact : tinyint(4)
max_depth : int(11)

v		glpi_2 glpi_impactitems
id : int(10) unsigned
itemtype : varchar(255)
items_id : int(10) unsigned
parent_id : int(10) unsigned
impactcontexts_id : int(10) unsigned
is_slave : tinyint(4)

v		glpi_2 glpi_impactrelations
id : int(10) unsigned
itemtype_source : varchar(255)
items_id_source : int(10) unsigned
itemtype_impacted : varchar(255)
items_id_impacted : int(10) unsigned

v		glpi_2 glpi_infocoms
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
buy_date : date
use_date : date
warranty_duration : int(11)
warranty_info : varchar(255)
suppliers_id : int(10) unsigned
order_number : varchar(255)
delivery_number : varchar(255)
immo_number : varchar(255)
value : decimal(20,4)
warranty_value : decimal(20,4)
sink_time : int(11)
sink_type : int(11)
sink_coeff : float
comment : text
bill : varchar(255)
budgets_id : int(10) unsigned
alert : int(11)
order_date : date
delivery_date : date
inventory_date : date
warranty_date : date
date_mod : timestamp
date_creation : timestamp
decommission_date : timestamp
businesscriticities_id : int(10) unsigned

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

v		glpi_2 glpi_ipaddresses
id : int(10) unsigned
entities_id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
version : tinyint(3) unsigned
name : varchar(255)
binary_0 : int(10) unsigned
binary_1 : int(10) unsigned
binary_2 : int(10) unsigned
binary_3 : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
mainitems_id : int(10) unsigned
mainitemtype : varchar(255)

v		glpi_2 glpi_ipaddresses_ipnetworks
id : int(10) unsigned
ipaddresses_id : int(10) unsigned
ipnetworks_id : int(10) unsigned

v		glpi_2 glpi_ipnetworks
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
ipnetworks_id : int(10) unsigned
completename : text
level : int(11)
ancestors_cache : longtext
sons_cache : longtext
addressable : tinyint(4)
version : tinyint(3) unsigned
name : varchar(255)
address : varchar(40)
address_0 : int(10) unsigned
address_1 : int(10) unsigned
address_2 : int(10) unsigned
address_3 : int(10) unsigned
netmask : varchar(40)
netmask_0 : int(10) unsigned
netmask_1 : int(10) unsigned
netmask_2 : int(10) unsigned
netmask_3 : int(10) unsigned
gateway : varchar(40)
gateway_0 : int(10) unsigned
gateway_1 : int(10) unsigned
gateway_2 : int(10) unsigned
gateway_3 : int(10) unsigned
comment : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_ipnetworks_vlans
id : int(10) unsigned
ipnetworks_id : int(10) unsigned
vlans_id : int(10) unsigned

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

v		glpi_2 glpi_items_devicebatteries
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicebatteries_id : int(10) unsigned
manufacturing_date : date
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned
real_capacity : int(11)

v		glpi_2 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)

v		glpi_2 glpi_items_devicecameras_imageformats
id : int(10) unsigned
item_devicecameras_id : int(10) unsigned
imageformats_id : int(10) unsigned
is_dynamic : tinyint(4)
is_deleted : tinyint(4)

v		glpi_2 glpi_items_devicecameras_imageresolutions
id : int(10) unsigned
item_devicecameras_id : int(10) unsigned
imageresolutions_id : int(10) unsigned
is_dynamic : tinyint(4)
is_deleted : tinyint(4)

v		glpi_2 glpi_items_devicecases
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicecases_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicecontrols
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicecontrols_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
busID : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicedrives
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicedrives_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
busID : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicefirmwares
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicefirmwares_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicegenerics
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicegenerics_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicegraphiccards
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicegraphiccards_id : int(10) unsigned
memory : int(11)
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
busID : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_deviceharddrives
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
deviceharddrives_id : int(10) unsigned
capacity : int(11)
serial : varchar(255)
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
busID : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicememories
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicememories_id : int(10) unsigned
size : int(11)
serial : varchar(255)
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
busID : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicemotherboards
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicemotherboards_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicenetworkcards
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicenetworkcards_id : int(10) unsigned
mac : varchar(255)
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
busID : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicepcis
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicepcis_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
busID : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicepowersupplies
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicepowersupplies_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_deviceprocessors
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
deviceprocessors_id : int(10) unsigned
frequency : int(11)
serial : varchar(255)
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
nbcores : int(11)
nbthreads : int(11)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
busID : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicesensors
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicesensors_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 glpi_items_devicesimcards
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
devicesimcards_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
otherserial : varchar(255)
states_id : int(10) unsigned
locations_id : int(10) unsigned
lines_id : int(10) unsigned
users_id : int(10) unsigned
groups_id : int(10) unsigned
pin : varchar(255)
pin2 : varchar(255)
puk : varchar(255)
puk2 : varchar(255)
msin : varchar(255)
comment : text

v		glpi_2 glpi_items_devicesoundcards
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
devicesoundcards_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
serial : varchar(255)
busID : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
states_id : int(10) unsigned

v		glpi_2 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 : int(11)
freesize : int(11)
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
encryption_status : int(11)
encryption_tool : varchar(255)
encryption_algorithm : varchar(255)
encryption_type : varchar(255)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_items_enclosures
id : int(10) unsigned
enclosures_id : int(10) unsigned
itemtype : varchar(255)
items_id : int(10) unsigned
position : int(11)

v		glpi_2 glpi_items_kanbans
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
users_id : int(10) unsigned
state : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_items_operatingsystems
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(255)
operatingsystems_id : int(10) unsigned
operatingsystemversions_id : int(10) unsigned
operatingsystemservicepacks_id : int(10) unsigned
operatingsystemarchitectures_id : int(10) unsigned
operatingsystemkernelversions_id : int(10) unsigned
license_number : varchar(255)
licenseid : varchar(255)
operatingsystemeditions_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
install_date : date

v		glpi_2 glpi_items_problems
id : int(10) unsigned
problems_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

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

v		glpi_2 glpi_items_racks
id : int(10) unsigned
racks_id : int(10) unsigned
itemtype : varchar(255)
items_id : int(10) unsigned
position : int(11)
orientation : tinyint(4)
bgcolor : varchar(7)
hpos : tinyint(4)
is_reserved : tinyint(4)

v		glpi_2 glpi_items_remotemanagements
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
remoteid : varchar(255)
type : varchar(255)
is_dynamic : tinyint(4)
is_deleted : tinyint(4)

v		glpi_2 glpi_items_softwarelicenses
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
softwarelicenses_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)

v		glpi_2 glpi_items_softwareversions
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
softwareversions_id : int(10) unsigned
is_deleted_item : tinyint(4)
is_template_item : tinyint(4)
entities_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
date_install : date

v		glpi_2 glpi_items_tickets
id : int(10) unsigned
itemtype : varchar(255)
items_id : int(10) unsigned
tickets_id : int(10) unsigned

v		glpi_2 glpi_itilcategories
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
itilcategories_id : int(10) unsigned
name : varchar(255)
completename : text
comment : text
level : int(11)
knowbaseitemcategories_id : int(10) unsigned
users_id : int(10) unsigned
groups_id : int(10) unsigned
code : varchar(255)
ancestors_cache : longtext
sons_cache : longtext
is_helpdeskvisible : tinyint(4)
tickettemplates_id_incident : int(10) unsigned
tickettemplates_id_demand : int(10) unsigned
changetemplates_id : int(10) unsigned
problemtemplates_id : int(10) unsigned
is_incident : int(11)
is_request : int(11)
is_problem : int(11)
is_change : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_itilfollowups
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
date : timestamp
users_id : int(10) unsigned
users_id_editor : int(10) unsigned
content : longtext
is_private : tinyint(4)
requesttypes_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp
timeline_position : tinyint(4)
sourceitems_id : int(10) unsigned
sourceof_items_id : int(10) unsigned

v		glpi_2 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 : text
requesttypes_id : int(10) unsigned
is_private : tinyint(4)
comment : text

v		glpi_2 glpi_itilsolutions
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
solutiontypes_id : int(10) unsigned
solutiontype_name : varchar(255)
content : longtext
date_creation : timestamp
date_mod : timestamp
date_approval : timestamp
users_id : int(10) unsigned
user_name : varchar(255)
users_id_editor : int(10) unsigned
users_id_approval : int(10) unsigned
user_name_approval : varchar(255)
status : int(11)
itilfollowups_id : int(10) unsigned

v		glpi_2 glpi_itils_projects
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
projects_id : int(10) unsigned

v		glpi_2 glpi_knowbaseitemcategories
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
knowbaseitemcategories_id : int(10) unsigned
name : varchar(255)
completename : text
comment : text
level : int(11)
sons_cache : longtext
ancestors_cache : longtext
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_knowbaseitems
id : int(10) unsigned
name : text
answer : longtext
is_faq : tinyint(4)
users_id : int(10) unsigned
view : int(11)
date_creation : timestamp
date_mod : timestamp
begin_date : timestamp
end_date : timestamp

v		glpi_2 glpi_knowbaseitems_comments
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
users_id : int(10) unsigned
language : varchar(10)
comment : text
parent_comment_id : int(10) unsigned
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_knowbaseitems_items
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_knowbaseitems_knowbaseitemcategories
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
knowbaseitemcategories_id : int(10) unsigned

v		glpi_2 glpi_knowbaseitems_profiles
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
profiles_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
no_entity_restriction : tinyint(4)

v		glpi_2 glpi_knowbaseitems_revisions
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
revision : int(11)
name : text
answer : longtext
language : varchar(10)
users_id : int(10) unsigned
date : timestamp

v		glpi_2 glpi_knowbaseitems_users
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
users_id : int(10) unsigned

v		glpi_2 glpi_knowbaseitemtranslations
id : int(10) unsigned
knowbaseitems_id : int(10) unsigned
language : varchar(10)
name : text
answer : longtext
users_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_lineoperators
id : int(10) unsigned
name : varchar(255)
comment : text
mcc : int(11)
mnc : int(11)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_lines
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
is_deleted : tinyint(4)
caller_num : varchar(255)
caller_name : varchar(255)
users_id : int(10) unsigned
groups_id : int(10) unsigned
lineoperators_id : int(10) unsigned
locations_id : int(10) unsigned
states_id : int(10) unsigned
linetypes_id : int(10) unsigned
date_creation : timestamp
date_mod : timestamp
comment : text

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

v		glpi_2 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		glpi_2 glpi_links_itemtypes
id : int(10) unsigned
links_id : int(10) unsigned
itemtype : varchar(100)

v		glpi_2 glpi_locations
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
locations_id : int(10) unsigned
completename : text
comment : text
level : int(11)
ancestors_cache : longtext
sons_cache : longtext
address : text
postcode : varchar(255)
town : varchar(255)
state : varchar(255)
country : varchar(255)
building : varchar(255)
room : varchar(255)
latitude : varchar(255)
longitude : varchar(255)
altitude : varchar(255)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_lockedfields
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
field : varchar(50)
value : varchar(255)
date_mod : timestamp
date_creation : timestamp
is_global : tinyint(4)

v		glpi_2 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		glpi_2 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)

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

v		glpi_2 glpi_monitormodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
weight : int(11)
required_units : int(11)
depth : float
power_connections : int(11)
power_consumption : int(11)
is_half_rack : tinyint(4)
picture_front : text
picture_rear : text
pictures : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_monitors
id : int(10) unsigned
entities_id : int(10) unsigned
name : varchar(255)
date_mod : timestamp
contact : varchar(255)
contact_num : varchar(255)
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
comment : text
serial : varchar(255)
otherserial : varchar(255)
size : decimal(5,2)
have_micro : tinyint(4)
have_speaker : tinyint(4)
have_subd : tinyint(4)
have_bnc : tinyint(4)
have_dvi : tinyint(4)
have_pivot : tinyint(4)
have_hdmi : tinyint(4)
have_displayport : tinyint(4)
locations_id : int(10) unsigned
monitortypes_id : int(10) unsigned
monitormodels_id : int(10) unsigned
manufacturers_id : int(10) unsigned
is_global : tinyint(4)
is_deleted : tinyint(4)
is_template : tinyint(4)
template_name : varchar(255)
users_id : int(10) unsigned
groups_id : int(10) unsigned
states_id : int(10) unsigned
ticket_tco : decimal(20,4)
is_dynamic : tinyint(4)
autoupdatesystems_id : int(10) unsigned
uuid : varchar(255)
date_creation : timestamp
is_recursive : tinyint(4)

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

v		glpi_2 glpi_networkaliases
id : int(10) unsigned
entities_id : int(10) unsigned
networknames_id : int(10) unsigned
name : varchar(255)
fqdns_id : int(10) unsigned
comment : text

v		glpi_2 glpi_networkequipmentmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
weight : int(11)
required_units : int(11)
depth : float
power_connections : int(11)
power_consumption : int(11)
is_half_rack : tinyint(4)
picture_front : text
picture_rear : text
pictures : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_networkequipments
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
ram : 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
date_mod : timestamp
comment : text
locations_id : int(10) unsigned
networks_id : int(10) unsigned
networkequipmenttypes_id : int(10) unsigned
networkequipmentmodels_id : int(10) unsigned
manufacturers_id : int(10) unsigned
is_deleted : tinyint(4)
is_template : tinyint(4)
template_name : varchar(255)
users_id : int(10) unsigned
groups_id : int(10) unsigned
states_id : int(10) unsigned
ticket_tco : decimal(20,4)
is_dynamic : tinyint(4)
uuid : varchar(255)
date_creation : timestamp
autoupdatesystems_id : int(10) unsigned
sysdescr : text
cpu : int(11)
uptime : varchar(255)
last_inventory_update : timestamp
snmpcredentials_id : int(10) unsigned

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

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

v		glpi_2 glpi_networknames
id : int(10) unsigned
entities_id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
name : varchar(255)
comment : text
fqdns_id : int(10) unsigned
ipnetworks_id : int(10) unsigned
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_networkportaggregates
id : int(10) unsigned
networkports_id : int(10) unsigned
networkports_id_list : text
date_mod : timestamp
date_creation : timestamp

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

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

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

v		glpi_2 glpi_networkportethernets
id : int(10) unsigned
networkports_id : int(10) unsigned
items_devicenetworkcards_id : int(10) unsigned
type : varchar(10)
speed : int(11)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_networkportfiberchannels
id : int(10) unsigned
networkports_id : int(10) unsigned
items_devicenetworkcards_id : int(10) unsigned
networkportfiberchanneltypes_id : int(10) unsigned
wwn : varchar(16)
speed : int(11)
date_mod : timestamp
date_creation : timestamp

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

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

v		glpi_2 glpi_networkportmetrics
id : int(10) unsigned
date : date
ifinbytes : bigint(20)
ifinerrors : bigint(20)
ifoutbytes : bigint(20)
ifouterrors : bigint(20)
networkports_id : int(10) unsigned
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_networkports
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
logical_number : int(11)
name : varchar(255)
instantiation_type : varchar(255)
mac : varchar(255)
comment : text
is_deleted : tinyint(4)
is_dynamic : tinyint(4)
date_mod : timestamp
date_creation : timestamp
ifmtu : int(11)
ifspeed : bigint(20)
ifinternalstatus : varchar(255)
ifconnectionstatus : int(11)
iflastchange : varchar(255)
ifinbytes : bigint(20)
ifinerrors : bigint(20)
ifoutbytes : bigint(20)
ifouterrors : bigint(20)
ifstatus : varchar(255)
ifdescr : varchar(255)
ifalias : varchar(255)
portduplex : varchar(255)
trunk : tinyint(4)
lastup : timestamp

v		glpi_2 glpi_networkports_networkports
id : int(10) unsigned
networkports_id_1 : int(10) unsigned
networkports_id_2 : int(10) unsigned

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

v		glpi_2 glpi_networkporttypes
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
value_decimal : int(11)
name : varchar(255)
comment : text
is_importable : tinyint(4)
instantiation_type : varchar(255)
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_networkportwifis
id : int(10) unsigned
networkports_id : int(10) unsigned
items_devicenetworkcards_id : int(10) unsigned
wifinetworks_id : int(10) unsigned
networkportwifis_id : int(10) unsigned
version : varchar(20)
mode : varchar(20)
date_mod : timestamp
date_creation : timestamp

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

v		glpi_2 glpi_notepads
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
date_creation : timestamp
date_mod : timestamp
users_id : int(10) unsigned
users_id_lastupdater : int(10) unsigned
content : longtext

v		glpi_2 glpi_notifications
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
itemtype : varchar(100)
event : varchar(255)
comment : text
is_recursive : tinyint(4)
is_active : tinyint(4)
date_mod : timestamp
date_creation : timestamp
allow_response : tinyint(4)

v		glpi_2 glpi_notifications_notificationtemplates
id : int(10) unsigned
notifications_id : int(10) unsigned
mode : varchar(20)
notificationtemplates_id : int(10) unsigned

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

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

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

v		glpi_2 glpi_notimportedemails
id : int(10) unsigned
from : varchar(255)
to : varchar(255)
mailcollectors_id : int(10) unsigned
date : timestamp
subject : text
messageid : varchar(255)
reason : int(11)
users_id : int(10) unsigned

v		glpi_2 glpi_objectlocks
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
users_id : int(10) unsigned
date : timestamp

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

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

v		glpi_2 glpi_olalevels
id : int(10) unsigned
name : varchar(255)
olas_id : int(10) unsigned
execution_time : int(11)
is_active : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
match : char(10)
uuid : varchar(255)

v		glpi_2 glpi_olalevels_tickets
id : int(10) unsigned
tickets_id : int(10) unsigned
olalevels_id : int(10) unsigned
date : timestamp

v		glpi_2 glpi_olas
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
type : int(11)
comment : text
number_time : int(11)
use_ticket_calendar : tinyint(4)
calendars_id : int(10) unsigned
date_mod : timestamp
definition_time : varchar(255)
end_of_working_day : tinyint(4)
date_creation : timestamp
slms_id : int(10) unsigned

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

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

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

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

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

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

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

v		glpi_2 glpi_passivedcequipmentmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
weight : int(11)
required_units : int(11)
depth : float
power_connections : int(11)
power_consumption : int(11)
is_half_rack : tinyint(4)
picture_front : text
picture_rear : text
pictures : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_passivedcequipments
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
locations_id : int(10) unsigned
serial : varchar(255)
otherserial : varchar(255)
passivedcequipmentmodels_id : int(10) unsigned
passivedcequipmenttypes_id : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
is_template : tinyint(4)
template_name : varchar(255)
is_deleted : tinyint(4)
states_id : int(10) unsigned
comment : text
manufacturers_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

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

v		glpi_2 glpi_pcivendors
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
vendorid : varchar(4)
deviceid : varchar(4)
name : varchar(255)
comment : text
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_pdumodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
weight : int(11)
required_units : int(11)
depth : float
power_connections : int(11)
max_power : int(11)
is_half_rack : tinyint(4)
picture_front : text
picture_rear : text
pictures : text
is_rackable : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_pdus
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
locations_id : int(10) unsigned
serial : varchar(255)
otherserial : varchar(255)
pdumodels_id : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
is_template : tinyint(4)
template_name : varchar(255)
is_deleted : tinyint(4)
states_id : int(10) unsigned
comment : text
manufacturers_id : int(10) unsigned
pdutypes_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_pdus_plugs
id : int(10) unsigned
plugs_id : int(10) unsigned
pdus_id : int(10) unsigned
number_plugs : int(11)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_pdus_racks
id : int(10) unsigned
racks_id : int(10) unsigned
pdus_id : int(10) unsigned
side : int(11)
position : int(11)
bgcolor : varchar(7)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_pdutypes
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
comment : text
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_pendingreasons
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
followup_frequency : int(11)
followups_before_resolution : int(11)
itilfollowuptemplates_id : int(10) unsigned
solutiontemplates_id : int(10) unsigned
comment : text

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

v		glpi_2 glpi_peripheralmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
weight : int(11)
required_units : int(11)
depth : float
power_connections : int(11)
power_consumption : int(11)
is_half_rack : tinyint(4)
picture_front : text
picture_rear : text
pictures : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_peripherals
id : int(10) unsigned
entities_id : int(10) unsigned
name : varchar(255)
date_mod : timestamp
contact : varchar(255)
contact_num : varchar(255)
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
comment : text
serial : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
peripheraltypes_id : int(10) unsigned
peripheralmodels_id : int(10) unsigned
brand : varchar(255)
manufacturers_id : int(10) unsigned
is_global : tinyint(4)
is_deleted : tinyint(4)
is_template : tinyint(4)
template_name : varchar(255)
users_id : int(10) unsigned
groups_id : int(10) unsigned
states_id : int(10) unsigned
ticket_tco : decimal(20,4)
is_dynamic : tinyint(4)
autoupdatesystems_id : int(10) unsigned
uuid : varchar(255)
date_creation : timestamp
is_recursive : tinyint(4)

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

v		glpi_2 glpi_phonemodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
date_mod : timestamp
date_creation : timestamp
picture_front : text
picture_rear : text
pictures : text

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

v		glpi_2 glpi_phones
id : int(10) unsigned
entities_id : int(10) unsigned
name : varchar(255)
date_mod : timestamp
contact : varchar(255)
contact_num : varchar(255)
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
comment : text
serial : varchar(255)
otherserial : varchar(255)
locations_id : int(10) unsigned
phonetypes_id : int(10) unsigned
phonemodels_id : int(10) unsigned
brand : varchar(255)
phonepowersupplies_id : int(10) unsigned
number_line : varchar(255)
have_headset : tinyint(4)
have_hp : tinyint(4)
manufacturers_id : int(10) unsigned
is_global : tinyint(4)
is_deleted : tinyint(4)
is_template : tinyint(4)
template_name : varchar(255)
users_id : int(10) unsigned
groups_id : int(10) unsigned
states_id : int(10) unsigned
ticket_tco : decimal(20,4)
is_dynamic : tinyint(4)
autoupdatesystems_id : int(10) unsigned
uuid : varchar(255)
date_creation : timestamp
is_recursive : tinyint(4)
last_inventory_update : timestamp

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

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

v		glpi_2 glpi_planningexternalevents
id : int(10) unsigned
uuid : varchar(255)
planningexternaleventtemplates_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
date : timestamp
users_id : int(10) unsigned
users_id_guests : text
groups_id : int(10) unsigned
name : varchar(255)
text : text
begin : timestamp
end : timestamp
rrule : text
state : int(11)
planningeventcategories_id : int(10) unsigned
background : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_planningexternaleventtemplates
id : int(10) unsigned
entities_id : int(10) unsigned
name : varchar(255)
text : text
comment : text
duration : int(11)
before_time : int(11)
rrule : text
state : int(11)
planningeventcategories_id : int(10) unsigned
background : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_planningrecalls
id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
users_id : int(10) unsigned
before_time : int(11)
when : timestamp

v		glpi_2 glpi_plugins
id : int(10) unsigned
directory : varchar(255)
name : varchar(255)
version : varchar(255)
state : int(11)
author : varchar(255)
homepage : varchar(255)
license : varchar(255)

v		glpi_2 glpi_plugin_formcreator_answers
id : int(10) unsigned
plugin_formcreator_formanswers_id : int(10) unsigned
plugin_formcreator_questions_id : int(10) unsigned
answer : longtext

v		glpi_2 glpi_plugin_formcreator_categories
id : int(10) unsigned
name : varchar(255)
comment : mediumtext
completename : varchar(255)
plugin_formcreator_categories_id : int(10) unsigned
level : int(11)
sons_cache : longtext
ancestors_cache : longtext
knowbaseitemcategories_id : int(10) unsigned

v		glpi_2 glpi_plugin_formcreator_conditions
id : int(10) unsigned
itemtype : varchar(255)
items_id : int(10) unsigned
plugin_formcreator_questions_id : int(10) unsigned
show_condition : int(11)
show_value : mediumtext
show_logic : int(11)
order : int(11)
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_entityconfigs
id : int(10) unsigned
entities_id : int(10) unsigned
replace_helpdesk : int(11)
default_form_list_mode : int(11)
sort_order : int(11)
is_kb_separated : int(11)
is_search_visible : int(11)
is_dashboard_visible : int(11)
is_header_visible : int(11)
is_search_issue_visible : int(11)
tile_design : int(11)
header : text
service_catalog_home : int(11)

v		glpi_2 glpi_plugin_formcreator_formanswers
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(1)
plugin_formcreator_forms_id : int(10) unsigned
requester_id : int(10) unsigned
users_id_validator : int(10) unsigned
groups_id_validator : int(10) unsigned
request_date : timestamp
status : int(11)
comment : mediumtext

v		glpi_2 glpi_plugin_formcreator_forms
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(1)
icon : varchar(255)
icon_color : varchar(255)
background_color : varchar(255)
access_rights : tinyint(1)
description : varchar(255)
content : longtext
plugin_formcreator_categories_id : int(10) unsigned
is_active : tinyint(1)
language : varchar(255)
helpdesk_home : tinyint(1)
is_deleted : tinyint(1)
validation_required : tinyint(1)
usage_count : int(11)
is_default : tinyint(1)
is_captcha_enabled : tinyint(1)
show_rule : int(11)
formanswer_name : varchar(255)
is_visible : tinyint(4)
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_forms_groups
id : int(10) unsigned
plugin_formcreator_forms_id : int(10) unsigned
groups_id : int(10) unsigned
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_forms_languages
id : int(10) unsigned
plugin_formcreator_forms_id : int(10) unsigned
name : varchar(255)
comment : text
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_forms_profiles
id : int(10) unsigned
plugin_formcreator_forms_id : int(10) unsigned
profiles_id : int(10) unsigned
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_forms_users
id : int(10) unsigned
plugin_formcreator_forms_id : int(10) unsigned
users_id : int(10) unsigned
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_forms_validators
id : int(10) unsigned
plugin_formcreator_forms_id : int(10) unsigned
itemtype : varchar(255)
items_id : int(10) unsigned
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_issues
id : int(10) unsigned
name : varchar(255)
display_id : varchar(255)
items_id : int(10) unsigned
itemtype : varchar(255)
status : varchar(255)
date_creation : timestamp
date_mod : timestamp
entities_id : int(10) unsigned
is_recursive : tinyint(1)
requester_id : int(10) unsigned
comment : longtext
users_id_recipient : int(10) unsigned

v		glpi_2 glpi_plugin_formcreator_items_targettickets
id : int(10) unsigned
plugin_formcreator_targettickets_id : int(10) unsigned
link : int(11)
itemtype : varchar(255)
items_id : int(10) unsigned
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_questiondependencies
id : int(10) unsigned
plugin_formcreator_questions_id : int(10) unsigned
plugin_formcreator_questions_id_2 : int(10) unsigned
fieldname : varchar(255)
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_questionranges
id : int(10) unsigned
plugin_formcreator_questions_id : int(10) unsigned
range_min : varchar(255)
range_max : varchar(255)
fieldname : varchar(255)
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_questionregexes
id : int(10) unsigned
plugin_formcreator_questions_id : int(10) unsigned
regex : mediumtext
fieldname : varchar(255)
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_questions
id : int(10) unsigned
name : varchar(255)
plugin_formcreator_sections_id : int(10) unsigned
fieldtype : varchar(30)
required : tinyint(1)
show_empty : tinyint(1)
default_values : mediumtext
itemtype : varchar(255)
values : mediumtext
description : mediumtext
row : int(11)
col : int(11)
width : int(11)
show_rule : int(11)
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_sections
id : int(10) unsigned
name : varchar(255)
plugin_formcreator_forms_id : int(10) unsigned
order : int(11)
show_rule : int(11)
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_targetchanges
id : int(10) unsigned
name : varchar(255)
plugin_formcreator_forms_id : int(10) unsigned
target_name : varchar(255)
changetemplates_id : int(10) unsigned
content : longtext
impactcontent : longtext
controlistcontent : longtext
rolloutplancontent : longtext
backoutplancontent : longtext
checklistcontent : longtext
due_date_rule : int(11)
due_date_question : int(10) unsigned
due_date_value : tinyint(4)
due_date_period : int(11)
urgency_rule : int(11)
urgency_question : int(10) unsigned
validation_followup : tinyint(1)
destination_entity : int(11)
destination_entity_value : int(10) unsigned
tag_type : int(11)
tag_questions : varchar(255)
tag_specifics : varchar(255)
category_rule : int(11)
category_question : int(10) unsigned
commonitil_validation_rule : int(11)
commonitil_validation_question : varchar(255)
show_rule : int(11)
sla_rule : int(11)
sla_question_tto : int(10) unsigned
sla_question_ttr : int(10) unsigned
ola_rule : int(11)
ola_question_tto : int(10) unsigned
ola_question_ttr : int(10) unsigned
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_targetproblems
id : int(10) unsigned
name : varchar(255)
plugin_formcreator_forms_id : int(10) unsigned
target_name : varchar(255)
problemtemplates_id : int(10) unsigned
content : longtext
impactcontent : longtext
causecontent : longtext
symptomcontent : longtext
urgency_rule : int(11)
urgency_question : int(10) unsigned
destination_entity : int(11)
destination_entity_value : int(10) unsigned
tag_type : int(11)
tag_questions : varchar(255)
tag_specifics : varchar(255)
category_rule : int(11)
category_question : int(10) unsigned
show_rule : int(11)
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_targets_actors
id : int(10) unsigned
itemtype : varchar(255)
items_id : int(10) unsigned
actor_role : int(11)
actor_type : int(11)
actor_value : int(10) unsigned
use_notification : tinyint(1)
uuid : varchar(255)

v		glpi_2 glpi_plugin_formcreator_targettickets
id : int(10) unsigned
name : varchar(255)
plugin_formcreator_forms_id : int(10) unsigned
target_name : varchar(255)
source_rule : int(11)
source_question : int(11)
type_rule : int(11)
type_question : int(10) unsigned
tickettemplates_id : int(10) unsigned
content : longtext
due_date_rule : int(11)
due_date_question : int(10) unsigned
due_date_value : tinyint(4)
due_date_period : int(11)
urgency_rule : int(11)
urgency_question : int(10) unsigned
validation_followup : tinyint(1)
destination_entity : int(11)
destination_entity_value : int(10) unsigned
tag_type : int(11)
tag_questions : varchar(255)
tag_specifics : varchar(255)
category_rule : int(11)
category_question : int(10) unsigned
associate_rule : int(11)
associate_question : int(10) unsigned
location_rule : int(11)
location_question : int(10) unsigned
commonitil_validation_rule : int(11)
commonitil_validation_question : varchar(255)
show_rule : int(11)
sla_rule : int(11)
sla_question_tto : int(10) unsigned
sla_question_ttr : int(10) unsigned
ola_rule : int(11)
ola_question_tto : int(10) unsigned
ola_question_ttr : int(10) unsigned
uuid : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_agentmodules
id : int(10) unsigned
modulename : varchar(255)
is_active : tinyint(1)
exceptions : text

v		glpi_2 glpi_plugin_fusioninventory_agents
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(1)
name : varchar(255)
last_contact : timestamp
version : varchar(255)
lock : tinyint(1)
device_id : varchar(255)
computers_id : int(10) unsigned
token : varchar(255)
useragent : varchar(255)
tag : varchar(255)
threads_networkdiscovery : int(10) unsigned
threads_networkinventory : int(10) unsigned
senddico : tinyint(1)
timeout_networkdiscovery : int(10) unsigned
timeout_networkinventory : int(10) unsigned
agent_port : smallint(5) unsigned

v		glpi_2 glpi_plugin_fusioninventory_collects
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(1)
type : varchar(255)
is_active : tinyint(1)
comment : text

v		glpi_2 glpi_plugin_fusioninventory_collects_files
id : int(10) unsigned
name : varchar(255)
plugin_fusioninventory_collects_id : int(10) unsigned
dir : varchar(255)
limit : int(10) unsigned
is_recursive : tinyint(1)
filter_regex : varchar(255)
filter_sizeequals : int(10) unsigned
filter_sizegreater : int(10) unsigned
filter_sizelower : int(10) unsigned
filter_checksumsha512 : varchar(255)
filter_checksumsha2 : varchar(255)
filter_name : varchar(255)
filter_iname : varchar(255)
filter_is_file : tinyint(1)
filter_is_dir : tinyint(1)

v		glpi_2 glpi_plugin_fusioninventory_collects_files_contents
id : int(10) unsigned
computers_id : int(10) unsigned
plugin_fusioninventory_collects_files_id : int(10) unsigned
pathfile : text
size : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_collects_registries
id : int(10) unsigned
name : varchar(255)
plugin_fusioninventory_collects_id : int(10) unsigned
hive : varchar(255)
path : text
key : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_collects_registries_contents
id : int(10) unsigned
computers_id : int(10) unsigned
plugin_fusioninventory_collects_registries_id : int(10) unsigned
key : varchar(255)
value : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_collects_wmis
id : int(10) unsigned
name : varchar(255)
plugin_fusioninventory_collects_id : int(10) unsigned
moniker : varchar(255)
class : varchar(255)
properties : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_collects_wmis_contents
id : int(10) unsigned
computers_id : int(10) unsigned
plugin_fusioninventory_collects_wmis_id : int(10) unsigned
property : varchar(255)
value : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_computerlicenseinfos
id : int(10) unsigned
computers_id : int(10) unsigned
softwarelicenses_id : int(10) unsigned
name : varchar(255)
fullname : varchar(255)
serial : varchar(255)
is_trial : tinyint(1)
is_update : tinyint(1)
is_oem : tinyint(1)
activation_date : timestamp

v		glpi_2 glpi_plugin_fusioninventory_computerremotemanagements
id : int(10) unsigned
computers_id : int(10) unsigned
number : varchar(255)
type : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_configlogfields
id : int(10) unsigned
plugin_fusioninventory_mappings_id : int(10) unsigned
days : smallint(6)

v		glpi_2 glpi_plugin_fusioninventory_configs
id : int(10) unsigned
type : varchar(255)
value : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_configsecurities
id : int(10) unsigned
name : varchar(64)
snmpversion : varchar(8)
community : varchar(255)
username : varchar(255)
authentication : varchar(255)
auth_passphrase : varchar(255)
encryption : varchar(255)
priv_passphrase : varchar(255)
is_deleted : tinyint(1)

v		glpi_2 glpi_plugin_fusioninventory_credentialips
id : int(10) unsigned
entities_id : int(10) unsigned
plugin_fusioninventory_credentials_id : int(10) unsigned
name : varchar(255)
comment : text
ip : varchar(255)
date_mod : timestamp

v		glpi_2 glpi_plugin_fusioninventory_credentials
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(1)
name : varchar(255)
username : varchar(255)
password : varchar(255)
comment : text
date_mod : timestamp
itemtype : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_crontasks
id : int(10) unsigned
name : varchar(255)
comment : text
command : text
execution_year : varchar(255)
execution_month : varchar(255)
execution_day : varchar(255)
execution_hour : varchar(255)
execution_minute : varchar(255)
execution_weekday : varchar(255)
user_id_execution : int(10) unsigned
user_execution : varchar(100)
storage : varchar(100)
user_id_storage : int(10) unsigned
user_storage : varchar(100)
status : tinyint(1)
computers_id : int(10) unsigned
creation_date : timestamp

v		glpi_2 glpi_plugin_fusioninventory_dblockinventories
value : int(10) unsigned
date : timestamp

v		glpi_2 glpi_plugin_fusioninventory_dblockinventorynames
value : varchar(100)
date : timestamp

v		glpi_2 glpi_plugin_fusioninventory_dblocksoftwares
value : tinyint(1)
date : timestamp

v		glpi_2 glpi_plugin_fusioninventory_dblocksoftwareversions
value : tinyint(1)
date : timestamp

v		glpi_2 glpi_plugin_fusioninventory_deployfiles
id : int(10) unsigned
name : varchar(255)
mimetype : varchar(255)
filesize : bigint(20)
comment : text
sha512 : char(128)
shortsha512 : char(6)
entities_id : int(10) unsigned
is_recursive : tinyint(1)
date_mod : timestamp

v		glpi_2 glpi_plugin_fusioninventory_deploygroups
id : int(10) unsigned
name : varchar(255)
comment : text
type : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_deploygroups_dynamicdatas
id : int(10) unsigned
plugin_fusioninventory_deploygroups_id : int(10) unsigned
fields_array : text
can_update_group : tinyint(1)
computers_id_cache : longtext

v		glpi_2 glpi_plugin_fusioninventory_deploygroups_staticdatas
id : int(10) unsigned
plugin_fusioninventory_deploygroups_id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_deploymirrors
id : int(10) unsigned
entities_id : int(10) unsigned
is_active : tinyint(1)
is_recursive : tinyint(1)
name : varchar(255)
url : varchar(255)
locations_id : int(10) unsigned
comment : text
date_mod : timestamp

v		glpi_2 glpi_plugin_fusioninventory_deploypackages
id : int(10) unsigned
name : varchar(255)
comment : text
entities_id : int(10) unsigned
is_recursive : tinyint(1)
date_mod : timestamp
uuid : varchar(255)
json : longtext
icon : varchar(255)
style : varchar(10)
plugin_fusioninventory_deploygroups_id : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_deploypackages_entities
id : int(10) unsigned
plugin_fusioninventory_deploypackages_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(1)

v		glpi_2 glpi_plugin_fusioninventory_deploypackages_groups
id : int(10) unsigned
plugin_fusioninventory_deploypackages_id : int(10) unsigned
groups_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(1)

v		glpi_2 glpi_plugin_fusioninventory_deploypackages_profiles
id : int(10) unsigned
plugin_fusioninventory_deploypackages_id : int(10) unsigned
profiles_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(1)

v		glpi_2 glpi_plugin_fusioninventory_deploypackages_users
id : int(10) unsigned
plugin_fusioninventory_deploypackages_id : int(10) unsigned
users_id : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_deployuserinteractiontemplates
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(1)
date_creation : timestamp
date_mod : timestamp
json : longtext

v		glpi_2 glpi_plugin_fusioninventory_entities
id : int(10) unsigned
entities_id : int(10) unsigned
transfers_id_auto : int(10) unsigned
agent_base_url : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_ignoredimportdevices
id : int(10) unsigned
name : varchar(255)
date : timestamp
itemtype : varchar(100)
entities_id : int(10) unsigned
ip : varchar(255)
mac : varchar(255)
rules_id : int(10) unsigned
method : varchar(255)
serial : varchar(255)
uuid : varchar(255)
plugin_fusioninventory_agents_id : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_inventorycomputerblacklists
id : int(10) unsigned
plugin_fusioninventory_criterium_id : int(10) unsigned
value : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_inventorycomputercomputers
id : int(10) unsigned
computers_id : int(10) unsigned
operatingsystem_installationdate : timestamp
winowner : varchar(255)
wincompany : varchar(255)
last_fusioninventory_update : timestamp
remote_addr : varchar(255)
serialized_inventory : longblob
is_entitylocked : tinyint(1)
oscomment : text
hostid : varchar(255)
last_boot : timestamp

v		glpi_2 glpi_plugin_fusioninventory_inventorycomputercriterias
id : int(10) unsigned
name : varchar(255)
comment : text

v		glpi_2 glpi_plugin_fusioninventory_inventorycomputerstats
id : smallint(5) unsigned
day : smallint(3)
hour : tinyint(2)
counter : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_ipranges
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
ip_start : varchar(255)
ip_end : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_ipranges_configsecurities
id : int(10) unsigned
plugin_fusioninventory_ipranges_id : int(10) unsigned
plugin_fusioninventory_configsecurities_id : int(10) unsigned
rank : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_locks
id : int(10) unsigned
tablename : varchar(64)
items_id : int(10) unsigned
tablefields : text

v		glpi_2 glpi_plugin_fusioninventory_mappings
id : int(10) unsigned
itemtype : varchar(100)
name : varchar(255)
table : varchar(255)
tablefield : varchar(255)
locale : int(10) unsigned
shortlocale : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_networkequipments
id : int(10) unsigned
networkequipments_id : int(10) unsigned
sysdescr : text
plugin_fusioninventory_configsecurities_id : int(10) unsigned
uptime : varchar(255)
cpu : int(10) unsigned
memory : int(10) unsigned
last_fusioninventory_update : timestamp
last_PID_update : int(10) unsigned
serialized_inventory : longblob

v		glpi_2 glpi_plugin_fusioninventory_networkportconnectionlogs
id : int(10) unsigned
date_mod : timestamp
creation : tinyint(1)
networkports_id_source : int(10) unsigned
networkports_id_destination : int(10) unsigned
plugin_fusioninventory_agentprocesses_id : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_networkportlogs
id : int(10) unsigned
networkports_id : int(10) unsigned
plugin_fusioninventory_mappings_id : int(10) unsigned
date_mod : timestamp
value_old : varchar(255)
value_new : varchar(255)
plugin_fusioninventory_agentprocesses_id : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_networkports
id : int(10) unsigned
networkports_id : int(10) unsigned
ifmtu : int(10) unsigned
ifspeed : bigint(50)
ifinternalstatus : varchar(255)
ifconnectionstatus : int(10) unsigned
iflastchange : varchar(255)
ifinoctets : bigint(50)
ifinerrors : bigint(50)
ifoutoctets : bigint(50)
ifouterrors : bigint(50)
ifstatus : varchar(255)
mac : varchar(255)
ifdescr : varchar(255)
ifalias : varchar(255)
portduplex : varchar(255)
trunk : tinyint(1)
lastup : timestamp

v		glpi_2 glpi_plugin_fusioninventory_networkporttypes
id : int(10) unsigned
name : varchar(255)
number : int(10) unsigned
othername : varchar(255)
import : tinyint(1)

v		glpi_2 glpi_plugin_fusioninventory_ouis
id : int(10) unsigned
mac : varchar(255)
name : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_pcidevices
id : int(10) unsigned
deviceid : varchar(255)
name : varchar(255)
plugin_fusioninventory_pcivendor_id : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_pcivendors
id : int(10) unsigned
vendorid : varchar(255)
name : varchar(255)

v		glpi_2 glpi_plugin_fusioninventory_printercartridges
id : bigint(20) unsigned
printers_id : int(10) unsigned
plugin_fusioninventory_mappings_id : int(10) unsigned
cartridges_id : int(10) unsigned
state : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_printerlogs
id : int(10) unsigned
printers_id : int(10) unsigned
date : timestamp
pages_total : int(10) unsigned
pages_n_b : int(10) unsigned
pages_color : int(10) unsigned
pages_recto_verso : int(10) unsigned
scanned : int(10) unsigned
pages_total_print : int(10) unsigned
pages_n_b_print : int(10) unsigned
pages_color_print : int(10) unsigned
pages_total_copy : int(10) unsigned
pages_n_b_copy : int(10) unsigned
pages_color_copy : int(10) unsigned
pages_total_fax : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_printers
id : int(10) unsigned
printers_id : int(10) unsigned
sysdescr : text
plugin_fusioninventory_configsecurities_id : int(10) unsigned
frequence_days : int(10) unsigned
last_fusioninventory_update : timestamp
serialized_inventory : longblob

v		glpi_2 glpi_plugin_fusioninventory_rulematchedlogs
id : int(10) unsigned
date : timestamp
items_id : int(10) unsigned
itemtype : varchar(100)
rules_id : int(10) unsigned
plugin_fusioninventory_agents_id : int(10) unsigned
method : varchar(255)
criteria : text

v		glpi_2 glpi_plugin_fusioninventory_statediscoveries
id : int(10) unsigned
plugin_fusioninventory_taskjob_id : int(10) unsigned
plugin_fusioninventory_agents_id : int(10) unsigned
start_time : timestamp
end_time : timestamp
date_mod : timestamp
threads : int(10) unsigned
nb_ip : int(10) unsigned
nb_found : int(10) unsigned
nb_error : int(10) unsigned
nb_exists : int(10) unsigned
nb_import : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_taskjoblogs
id : bigint(20) unsigned
plugin_fusioninventory_taskjobstates_id : int(10) unsigned
date : timestamp
items_id : int(10) unsigned
itemtype : varchar(100)
state : int(10) unsigned
comment : text

v		glpi_2 glpi_plugin_fusioninventory_taskjobs
id : int(10) unsigned
plugin_fusioninventory_tasks_id : int(10) unsigned
entities_id : int(10) unsigned
name : varchar(255)
date_creation : timestamp
method : varchar(255)
targets : text
actors : text
comment : text
rescheduled_taskjob_id : int(10) unsigned
statuscomments : text
enduser : text

v		glpi_2 glpi_plugin_fusioninventory_taskjobstates
id : bigint(20) unsigned
plugin_fusioninventory_taskjobs_id : int(10) unsigned
items_id : int(10) unsigned
itemtype : varchar(100)
state : int(10) unsigned
plugin_fusioninventory_agents_id : int(10) unsigned
specificity : text
uniqid : varchar(255)
date_start : timestamp
nb_retry : int(10) unsigned
max_retry : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_tasks
id : int(10) unsigned
entities_id : int(10) unsigned
name : varchar(255)
date_creation : timestamp
comment : text
is_active : tinyint(1)
datetime_start : timestamp
datetime_end : timestamp
plugin_fusioninventory_timeslots_prep_id : int(10) unsigned
plugin_fusioninventory_timeslots_exec_id : int(10) unsigned
last_agent_wakeup : timestamp
wakeup_agent_counter : int(10) unsigned
wakeup_agent_time : int(10) unsigned
reprepare_if_successful : tinyint(1)
is_deploy_on_demand : tinyint(1)

v		glpi_2 glpi_plugin_fusioninventory_timeslotentries
id : int(10) unsigned
plugin_fusioninventory_timeslots_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(1)
day : tinyint(1)
begin : int(10) unsigned
end : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_timeslots
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(1)
name : varchar(255)
comment : text
date_mod : timestamp

v		glpi_2 glpi_plugin_fusioninventory_unmanageds
id : int(10) unsigned
name : varchar(255)
date_mod : timestamp
entities_id : int(10) unsigned
locations_id : int(10) unsigned
is_deleted : tinyint(1)
users_id : int(10) unsigned
serial : varchar(255)
otherserial : varchar(255)
contact : varchar(255)
domain : int(10) unsigned
comment : text
item_type : varchar(255)
accepted : tinyint(1)
plugin_fusioninventory_agents_id : int(10) unsigned
ip : varchar(255)
hub : tinyint(1)
states_id : int(10) unsigned
sysdescr : text
plugin_fusioninventory_configsecurities_id : int(10) unsigned
is_dynamic : tinyint(1)
serialized_inventory : longblob

v		glpi_2 glpi_plugin_fusioninventory_usbdevices
id : int(10) unsigned
deviceid : varchar(255)
name : varchar(255)
plugin_fusioninventory_usbvendor_id : int(10) unsigned

v		glpi_2 glpi_plugin_fusioninventory_usbvendors
id : int(10) unsigned
vendorid : varchar(255)
name : varchar(255)

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

v		glpi_2 glpi_printerlogs
id : int(10) unsigned
printers_id : int(10) unsigned
total_pages : int(11)
bw_pages : int(11)
color_pages : int(11)
rv_pages : int(11)
prints : int(11)
bw_prints : int(11)
color_prints : int(11)
copies : int(11)
bw_copies : int(11)
color_copies : int(11)
scanned : int(11)
date : date
date_creation : timestamp
date_mod : timestamp
faxed : int(11)

v		glpi_2 glpi_printermodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
date_mod : timestamp
date_creation : timestamp
picture_front : text
picture_rear : text
pictures : text

v		glpi_2 glpi_printers
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
date_mod : timestamp
contact : varchar(255)
contact_num : varchar(255)
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
serial : varchar(255)
otherserial : varchar(255)
have_serial : tinyint(4)
have_parallel : tinyint(4)
have_usb : tinyint(4)
have_wifi : tinyint(4)
have_ethernet : tinyint(4)
comment : text
memory_size : varchar(255)
locations_id : int(10) unsigned
networks_id : int(10) unsigned
printertypes_id : int(10) unsigned
printermodels_id : int(10) unsigned
manufacturers_id : int(10) unsigned
is_global : tinyint(4)
is_deleted : tinyint(4)
is_template : tinyint(4)
template_name : varchar(255)
init_pages_counter : int(11)
last_pages_counter : int(11)
users_id : int(10) unsigned
groups_id : int(10) unsigned
states_id : int(10) unsigned
ticket_tco : decimal(20,4)
is_dynamic : tinyint(4)
uuid : varchar(255)
date_creation : timestamp
sysdescr : text
last_inventory_update : timestamp
snmpcredentials_id : int(10) unsigned
autoupdatesystems_id : int(10) unsigned

v		glpi_2 glpi_printers_cartridgeinfos
id : int(10) unsigned
printers_id : int(10) unsigned
property : varchar(255)
value : varchar(255)
date_mod : timestamp
date_creation : timestamp

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

v		glpi_2 glpi_problemcosts
id : int(10) unsigned
problems_id : int(10) unsigned
name : varchar(255)
comment : text
begin_date : date
end_date : date
actiontime : int(11)
cost_time : decimal(20,4)
cost_fixed : decimal(20,4)
cost_material : decimal(20,4)
budgets_id : int(10) unsigned
entities_id : int(10) unsigned

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

v		glpi_2 glpi_problems_suppliers
id : int(10) unsigned
problems_id : int(10) unsigned
suppliers_id : int(10) unsigned
type : int(11)
use_notification : tinyint(4)
alternative_email : varchar(255)

v		glpi_2 glpi_problems_tickets
id : int(10) unsigned
problems_id : int(10) unsigned
tickets_id : int(10) unsigned

v		glpi_2 glpi_problems_users
id : int(10) unsigned
problems_id : int(10) unsigned
users_id : int(10) unsigned
type : int(11)
use_notification : tinyint(4)
alternative_email : varchar(255)

v		glpi_2 glpi_problemtasks
id : int(10) unsigned
uuid : varchar(255)
problems_id : int(10) unsigned
taskcategories_id : int(10) unsigned
date : timestamp
begin : timestamp
end : timestamp
users_id : int(10) unsigned
users_id_editor : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
content : longtext
actiontime : int(11)
state : int(11)
date_mod : timestamp
date_creation : timestamp
tasktemplates_id : int(10) unsigned
timeline_position : tinyint(4)
is_private : tinyint(4)

v		glpi_2 glpi_problemtemplatehiddenfields
id : int(10) unsigned
problemtemplates_id : int(10) unsigned
num : int(11)

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

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

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

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

v		glpi_2 glpi_profiles
id : int(10) unsigned
name : varchar(255)
interface : varchar(255)
is_default : tinyint(4)
helpdesk_hardware : int(11)
helpdesk_item_type : text
ticket_status : text
date_mod : timestamp
comment : text
problem_status : text
create_ticket_on_login : tinyint(4)
tickettemplates_id : int(10) unsigned
changetemplates_id : int(10) unsigned
problemtemplates_id : int(10) unsigned
change_status : text
managed_domainrecordtypes : text
date_creation : timestamp

v		glpi_2 glpi_profiles_reminders
id : int(10) unsigned
reminders_id : int(10) unsigned
profiles_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
no_entity_restriction : tinyint(4)

v		glpi_2 glpi_profiles_rssfeeds
id : int(10) unsigned
rssfeeds_id : int(10) unsigned
profiles_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
no_entity_restriction : tinyint(4)

v		glpi_2 glpi_profiles_users
id : int(10) unsigned
users_id : int(10) unsigned
profiles_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
is_dynamic : tinyint(4)
is_default_profile : tinyint(4)

v		glpi_2 glpi_projectcosts
id : int(10) unsigned
projects_id : int(10) unsigned
name : varchar(255)
comment : text
begin_date : date
end_date : date
cost : decimal(20,4)
budgets_id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)

v		glpi_2 glpi_projects
id : int(10) unsigned
name : varchar(255)
code : varchar(255)
priority : int(11)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
projects_id : int(10) unsigned
projectstates_id : int(10) unsigned
projecttypes_id : int(10) unsigned
date : timestamp
date_mod : timestamp
users_id : int(10) unsigned
groups_id : int(10) unsigned
plan_start_date : timestamp
plan_end_date : timestamp
real_start_date : timestamp
real_end_date : timestamp
percent_done : int(11)
auto_percent_done : tinyint(4)
show_on_global_gantt : tinyint(4)
content : longtext
comment : longtext
is_deleted : tinyint(4)
date_creation : timestamp
projecttemplates_id : int(10) unsigned
is_template : tinyint(4)
template_name : varchar(255)

v		glpi_2 glpi_projectstates
id : int(10) unsigned
name : varchar(255)
comment : text
color : varchar(255)
is_finished : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 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		glpi_2 glpi_projecttasks
id : int(10) unsigned
uuid : varchar(255)
name : varchar(255)
content : longtext
comment : longtext
entities_id : int(10) unsigned
is_recursive : tinyint(4)
projects_id : int(10) unsigned
projecttasks_id : int(10) unsigned
date_creation : timestamp
date_mod : timestamp
plan_start_date : timestamp
plan_end_date : timestamp
real_start_date : timestamp
real_end_date : timestamp
planned_duration : int(11)
effective_duration : int(11)
projectstates_id : int(10) unsigned
projecttasktypes_id : int(10) unsigned
users_id : int(10) unsigned
percent_done : int(11)
auto_percent_done : tinyint(4)
is_milestone : tinyint(4)
projecttasktemplates_id : int(10) unsigned
is_template : tinyint(4)
template_name : varchar(255)

v		glpi_2 glpi_projecttasks_tickets
id : int(10) unsigned
tickets_id : int(10) unsigned
projecttasks_id : int(10) unsigned

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

v		glpi_2 glpi_projecttasktemplates
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
description : longtext
comment : longtext
projects_id : int(10) unsigned
projecttasks_id : int(10) unsigned
plan_start_date : timestamp
plan_end_date : timestamp
real_start_date : timestamp
real_end_date : timestamp
planned_duration : int(11)
effective_duration : int(11)
projectstates_id : int(10) unsigned
projecttasktypes_id : int(10) unsigned
users_id : int(10) unsigned
percent_done : int(11)
is_milestone : tinyint(4)
comments : text
date_mod : timestamp
date_creation : timestamp

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

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

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

v		glpi_2 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)

v		glpi_2 glpi_rackmodels
id : int(10) unsigned
name : varchar(255)
comment : text
product_number : varchar(255)
date_mod : timestamp
date_creation : timestamp
pictures : text

v		glpi_2 glpi_racks
id : int(10) unsigned
name : varchar(255)
comment : text
entities_id : int(10) unsigned
is_recursive : tinyint(4)
locations_id : int(10) unsigned
serial : varchar(255)
otherserial : varchar(255)
rackmodels_id : int(10) unsigned
manufacturers_id : int(10) unsigned
racktypes_id : int(10) unsigned
states_id : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
width : int(11)
height : int(11)
depth : int(11)
number_units : int(11)
is_template : tinyint(4)
template_name : varchar(255)
is_deleted : tinyint(4)
dcrooms_id : int(10) unsigned
room_orientation : int(11)
position : varchar(50)
bgcolor : varchar(7)
max_power : int(11)
mesured_power : int(11)
max_weight : int(11)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_racktypes
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
comment : text
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_recurrentchanges
id : int(10) unsigned
name : varchar(255)
comment : text
entities_id : int(10) unsigned
is_recursive : tinyint(4)
is_active : tinyint(4)
changetemplates_id : int(10) unsigned
begin_date : timestamp
periodicity : varchar(255)
create_before : int(11)
next_creation_date : timestamp
calendars_id : int(10) unsigned
end_date : timestamp

v		glpi_2 glpi_refusedequipments
id : int(10) unsigned
name : varchar(255)
itemtype : varchar(100)
entities_id : int(10) unsigned
ip : varchar(255)
mac : varchar(255)
rules_id : int(10) unsigned
method : varchar(255)
serial : varchar(255)
uuid : varchar(255)
agents_id : int(10) unsigned
autoupdatesystems_id : int(10) unsigned
date_creation : timestamp
date_mod : timestamp

v		glpi_2 glpi_registeredids
id : int(10) unsigned
name : varchar(255)
items_id : int(10) unsigned
itemtype : varchar(100)
device_type : varchar(100)

v		glpi_2 glpi_reminders
id : int(10) unsigned
uuid : varchar(255)
date : timestamp
users_id : int(10) unsigned
name : varchar(255)
text : text
begin : timestamp
end : timestamp
is_planned : tinyint(4)
date_mod : timestamp
state : int(11)
begin_view_date : timestamp
end_view_date : timestamp
date_creation : timestamp

v		glpi_2 glpi_reminders_users
id : int(10) unsigned
reminders_id : int(10) unsigned
users_id : int(10) unsigned

v		glpi_2 glpi_remindertranslations
id : int(10) unsigned
reminders_id : int(10) unsigned
language : varchar(5)
name : text
text : longtext
users_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_requesttypes
id : int(10) unsigned
name : varchar(255)
is_helpdesk_default : tinyint(4)
is_followup_default : tinyint(4)
is_mail_default : tinyint(4)
is_mailfollowup_default : tinyint(4)
is_active : tinyint(4)
is_ticketheader : tinyint(4)
is_itilfollowup : tinyint(4)
comment : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_reservationitems
id : int(10) unsigned
itemtype : varchar(100)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
items_id : int(10) unsigned
comment : text
is_active : tinyint(4)

v		glpi_2 glpi_reservations
id : int(10) unsigned
reservationitems_id : int(10) unsigned
begin : timestamp
end : timestamp
users_id : int(10) unsigned
comment : text
group : int(11)

v		glpi_2 glpi_rssfeeds
id : int(10) unsigned
name : varchar(255)
users_id : int(10) unsigned
comment : text
url : text
refresh_rate : int(11)
max_items : int(11)
have_error : tinyint(4)
is_active : tinyint(4)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_rssfeeds_users
id : int(10) unsigned
rssfeeds_id : int(10) unsigned
users_id : int(10) unsigned

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

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

v		glpi_2 glpi_rulematchedlogs
id : int(10) unsigned
date : timestamp
items_id : int(10) unsigned
itemtype : varchar(100)
rules_id : int(10) unsigned
agents_id : int(10) unsigned
method : varchar(255)

v		glpi_2 glpi_rulerightparameters
id : int(10) unsigned
name : varchar(255)
value : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_rules
id : int(10) unsigned
entities_id : int(10) unsigned
sub_type : varchar(255)
ranking : int(11)
name : varchar(255)
description : text
match : char(10)
is_active : tinyint(4)
comment : text
date_mod : timestamp
is_recursive : tinyint(4)
uuid : varchar(255)
condition : int(11)
date_creation : timestamp

v		glpi_2 glpi_savedsearches
id : int(10) unsigned
name : varchar(255)
type : int(11)
itemtype : varchar(100)
users_id : int(10) unsigned
is_private : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
query : text
last_execution_time : int(11)
do_count : tinyint(4)
last_execution_date : timestamp
counter : int(11)

v		glpi_2 glpi_savedsearches_alerts
id : int(10) unsigned
savedsearches_id : int(10) unsigned
name : varchar(255)
is_active : tinyint(4)
operator : tinyint(4)
value : int(11)
date_mod : timestamp
date_creation : timestamp
frequency : int(11)

v		glpi_2 glpi_savedsearches_users
id : int(10) unsigned
users_id : int(10) unsigned
itemtype : varchar(100)
savedsearches_id : int(10) unsigned

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

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

v		glpi_2 glpi_slalevels
id : int(10) unsigned
name : varchar(255)
slas_id : int(10) unsigned
execution_time : int(11)
is_active : tinyint(4)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
match : char(10)
uuid : varchar(255)

v		glpi_2 glpi_slalevels_tickets
id : int(10) unsigned
tickets_id : int(10) unsigned
slalevels_id : int(10) unsigned
date : timestamp

v		glpi_2 glpi_slas
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
type : int(11)
comment : text
number_time : int(11)
use_ticket_calendar : tinyint(4)
calendars_id : int(10) unsigned
date_mod : timestamp
definition_time : varchar(255)
end_of_working_day : tinyint(4)
date_creation : timestamp
slms_id : int(10) unsigned

v		glpi_2 glpi_slms
id : int(10) unsigned
name : varchar(255)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
comment : text
use_ticket_calendar : tinyint(4)
calendars_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_snmpcredentials
id : int(10) unsigned
name : varchar(64)
snmpversion : varchar(8)
community : varchar(255)
username : varchar(255)
authentication : varchar(255)
auth_passphrase : varchar(255)
encryption : varchar(255)
priv_passphrase : varchar(255)
is_deleted : tinyint(4)

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

v		glpi_2 glpi_sockets
id : int(10) unsigned
position : int(11)
locations_id : int(10) unsigned
name : varchar(255)
socketmodels_id : int(10) unsigned
wiring_side : tinyint(4)
itemtype : varchar(255)
items_id : int(10) unsigned
networkports_id : int(10) unsigned
comment : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_softwarecategories
id : int(10) unsigned
name : varchar(255)
comment : text
softwarecategories_id : int(10) unsigned
completename : text
level : int(11)
ancestors_cache : longtext
sons_cache : longtext

v		glpi_2 glpi_softwarelicenses
id : int(10) unsigned
softwares_id : int(10) unsigned
softwarelicenses_id : int(10) unsigned
completename : text
level : int(11)
entities_id : int(10) unsigned
is_recursive : tinyint(4)
number : int(11)
softwarelicensetypes_id : int(10) unsigned
name : varchar(255)
serial : varchar(255)
otherserial : varchar(255)
softwareversions_id_buy : int(10) unsigned
softwareversions_id_use : int(10) unsigned
expire : date
comment : text
date_mod : timestamp
is_valid : tinyint(4)
date_creation : timestamp
is_deleted : tinyint(4)
locations_id : int(10) unsigned
users_id_tech : int(10) unsigned
users_id : int(10) unsigned
groups_id_tech : int(10) unsigned
groups_id : int(10) unsigned
is_helpdesk_visible : tinyint(4)
is_template : tinyint(4)
template_name : varchar(255)
states_id : int(10) unsigned
manufacturers_id : int(10) unsigned
contact : varchar(255)
contact_num : varchar(255)
allow_overquota : tinyint(4)
pictures : text

v		glpi_2 glpi_softwarelicensetypes
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp
softwarelicensetypes_id : int(10) unsigned
level : int(11)
ancestors_cache : longtext
sons_cache : longtext
entities_id : int(10) unsigned
is_recursive : tinyint(4)
completename : text

v		glpi_2 glpi_softwares
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
comment : text
locations_id : int(10) unsigned
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
is_update : tinyint(4)
softwares_id : int(10) unsigned
manufacturers_id : int(10) unsigned
is_deleted : tinyint(4)
is_template : tinyint(4)
template_name : varchar(255)
date_mod : timestamp
users_id : int(10) unsigned
groups_id : int(10) unsigned
ticket_tco : decimal(20,4)
is_helpdesk_visible : tinyint(4)
softwarecategories_id : int(10) unsigned
is_valid : tinyint(4)
date_creation : timestamp
pictures : text

v		glpi_2 glpi_softwareversions
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
softwares_id : int(10) unsigned
states_id : int(10) unsigned
name : varchar(255)
arch : varchar(255)
comment : text
operatingsystems_id : int(10) unsigned
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_solutiontemplates
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
content : text
solutiontypes_id : int(10) unsigned
comment : text
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_solutiontypes
id : int(10) unsigned
name : varchar(255)
comment : text
entities_id : int(10) unsigned
is_recursive : tinyint(4)
date_mod : timestamp
date_creation : timestamp

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

v		glpi_2 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)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_suppliers
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
suppliertypes_id : int(10) unsigned
registration_number : varchar(255)
address : text
postcode : varchar(255)
town : varchar(255)
state : varchar(255)
country : varchar(255)
website : varchar(255)
phonenumber : varchar(255)
comment : text
is_deleted : tinyint(4)
fax : varchar(255)
email : varchar(255)
date_mod : timestamp
date_creation : timestamp
is_active : tinyint(4)
pictures : text

v		glpi_2 glpi_suppliers_tickets
id : int(10) unsigned
tickets_id : int(10) unsigned
suppliers_id : int(10) unsigned
type : int(11)
use_notification : tinyint(4)
alternative_email : varchar(255)

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

v		glpi_2 glpi_taskcategories
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
taskcategories_id : int(10) unsigned
name : varchar(255)
completename : text
comment : text
level : int(11)
ancestors_cache : longtext
sons_cache : longtext
is_active : tinyint(4)
is_helpdeskvisible : tinyint(4)
date_mod : timestamp
date_creation : timestamp
knowbaseitemcategories_id : int(10) unsigned

v		glpi_2 glpi_tasktemplates
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
content : text
taskcategories_id : int(10) unsigned
actiontime : int(11)
comment : text
date_mod : timestamp
date_creation : timestamp
state : int(11)
is_private : tinyint(4)
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned

v		glpi_2 glpi_ticketcosts
id : int(10) unsigned
tickets_id : int(10) unsigned
name : varchar(255)
comment : text
begin_date : date
end_date : date
actiontime : int(11)
cost_time : decimal(20,4)
cost_fixed : decimal(20,4)
cost_material : decimal(20,4)
budgets_id : int(10) unsigned
entities_id : int(10) unsigned

v		glpi_2 glpi_ticketrecurrents
id : int(10) unsigned
name : varchar(255)
comment : text
entities_id : int(10) unsigned
is_recursive : tinyint(4)
is_active : tinyint(4)
tickettemplates_id : int(10) unsigned
begin_date : timestamp
periodicity : varchar(255)
create_before : int(11)
next_creation_date : timestamp
calendars_id : int(10) unsigned
end_date : timestamp

v		glpi_2 glpi_tickets
id : int(10) unsigned
entities_id : int(10) unsigned
name : varchar(255)
date : timestamp
closedate : timestamp
solvedate : timestamp
takeintoaccountdate : timestamp
date_mod : timestamp
users_id_lastupdater : int(10) unsigned
status : int(11)
users_id_recipient : int(10) unsigned
requesttypes_id : int(10) unsigned
content : longtext
urgency : int(11)
impact : int(11)
priority : int(11)
itilcategories_id : int(10) unsigned
type : int(11)
global_validation : int(11)
slas_id_ttr : int(10) unsigned
slas_id_tto : int(10) unsigned
slalevels_id_ttr : int(10) unsigned
time_to_resolve : timestamp
time_to_own : timestamp
begin_waiting_date : timestamp
sla_waiting_duration : int(11)
ola_waiting_duration : int(11)
olas_id_tto : int(10) unsigned
olas_id_ttr : int(10) unsigned
olalevels_id_ttr : int(10) unsigned
ola_ttr_begin_date : timestamp
internal_time_to_resolve : timestamp
internal_time_to_own : timestamp
waiting_duration : int(11)
close_delay_stat : int(11)
solve_delay_stat : int(11)
takeintoaccount_delay_stat : int(11)
actiontime : int(11)
is_deleted : tinyint(4)
locations_id : int(10) unsigned
validation_percent : int(11)
date_creation : timestamp

v		glpi_2 glpi_ticketsatisfactions
id : int(10) unsigned
tickets_id : int(10) unsigned
type : int(11)
date_begin : timestamp
date_answered : timestamp
satisfaction : int(11)
comment : text

v		glpi_2 glpi_tickets_contracts
id : int(10) unsigned
tickets_id : int(10) unsigned
contracts_id : int(10) unsigned

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

v		glpi_2 glpi_tickets_users
id : int(10) unsigned
tickets_id : int(10) unsigned
users_id : int(10) unsigned
type : int(11)
use_notification : tinyint(4)
alternative_email : varchar(255)

v		glpi_2 glpi_tickettasks
id : int(10) unsigned
uuid : varchar(255)
tickets_id : int(10) unsigned
taskcategories_id : int(10) unsigned
date : timestamp
users_id : int(10) unsigned
users_id_editor : int(10) unsigned
content : longtext
is_private : tinyint(4)
actiontime : int(11)
begin : timestamp
end : timestamp
state : int(11)
users_id_tech : int(10) unsigned
groups_id_tech : int(10) unsigned
date_mod : timestamp
date_creation : timestamp
tasktemplates_id : int(10) unsigned
timeline_position : tinyint(4)
sourceitems_id : int(10) unsigned
sourceof_items_id : int(10) unsigned

v		glpi_2 glpi_tickettemplatehiddenfields
id : int(10) unsigned
tickettemplates_id : int(10) unsigned
num : int(11)

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

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

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

v		glpi_2 glpi_ticketvalidations
id : int(10) unsigned
entities_id : int(10) unsigned
users_id : int(10) unsigned
tickets_id : int(10) unsigned
users_id_validate : int(10) unsigned
comment_submission : text
comment_validation : text
status : int(11)
submission_date : timestamp
validation_date : timestamp
timeline_position : tinyint(4)

v		glpi_2 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)

v		glpi_2 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
groups_id_tech : int(10) unsigned
is_dynamic : tinyint(4)
date_creation : timestamp
autoupdatesystems_id : int(10) unsigned
sysdescr : text
domains_id : int(10) unsigned
agents_id : int(10) unsigned
itemtype : varchar(100)
accepted : tinyint(4)
hub : tinyint(4)
ip : varchar(255)
snmpcredentials_id : int(10) unsigned
last_inventory_update : timestamp

v		glpi_2 glpi_usbvendors
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
vendorid : varchar(4)
deviceid : varchar(4)
name : varchar(255)
comment : text
date_creation : timestamp
date_mod : timestamp

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

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

v		glpi_2 glpi_users
id : int(10) unsigned
name : varchar(255)
password : varchar(255)
password_last_update : timestamp
phone : varchar(255)
phone2 : varchar(255)
mobile : varchar(255)
realname : varchar(255)
firstname : varchar(255)
locations_id : int(10) unsigned
language : char(10)
use_mode : int(11)
list_limit : int(11)
is_active : tinyint(4)
comment : text
auths_id : int(10) unsigned
authtype : int(11)
last_login : timestamp
date_mod : timestamp
date_sync : timestamp
is_deleted : tinyint(4)
profiles_id : int(10) unsigned
entities_id : int(10) unsigned
usertitles_id : int(10) unsigned
usercategories_id : int(10) unsigned
date_format : int(11)
number_format : int(11)
names_format : int(11)
csv_delimiter : char(1)
is_ids_visible : tinyint(4)
use_flat_dropdowntree : tinyint(4)
show_jobs_at_login : tinyint(4)
priority_1 : char(20)
priority_2 : char(20)
priority_3 : char(20)
priority_4 : char(20)
priority_5 : char(20)
priority_6 : char(20)
followup_private : tinyint(4)
task_private : tinyint(4)
default_requesttypes_id : int(10) unsigned
password_forget_token : char(40)
password_forget_token_date : timestamp
user_dn : text
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		glpi_2 glpi_usertitles
id : int(10) unsigned
name : varchar(255)
comment : text
date_mod : timestamp
date_creation : timestamp

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

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

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

v		glpi_2 glpi_vlans
id : int(10) unsigned
entities_id : int(10) unsigned
is_recursive : tinyint(4)
name : varchar(255)
comment : text
tag : int(11)
date_mod : timestamp
date_creation : timestamp

v		glpi_2 glpi_vobjects
id : int(10) unsigned
itemtype : varchar(100)
items_id : int(10) unsigned
data : text
date_mod : timestamp
date_creation : timestamp

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