Largue ficheiros aqui

Envio de SQL ( 0 ) x -

Definições relacionadas com a página Clique na barra para deslizar para o topo da página
Use Ctrl+Enter para executar a consulta Pressione Enter para executar consulta
Ascendente
Descendente
Ordem:
Depurar SQL
Contagem
Ordem de execução
Tempo gasto
Ordenar por:
Agrupar consultas
Desagrupar consultas
Ocultar Mostrar Mostrar rastro Ocultar rastro Contagem : Tempo gasto :
Marcadores
Actualizar
Adicionar
Sem marcadores
Adicionar marcador
Opções
Definir como predefinição





Ocultar Mostrar Re-consultar Editar Explicar Perfil Marcadores Consulta falhou Base de Dados : Tempo de execução da consulta :
Sem título *
v Mostrar/ocultar lista de tabelas Ver em ecrã cheio Adicione tabelas de outras bases de dados Nova página Abrir página Guardar página Guardar página como Apagar páginas Criar tabela Criar relacionamento Escolha a coluna para mostrar Recarregar Ajuda Links angulares / Links diretos Ajustar à grade v Tudo pequeno/grande Mudar para pequeno/grande Alternar linhas de relação Exportar estrutura > Mover o menu > Fixar texto
v v
Número de tabelas: 0
v glpidb 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 glpidb glpi_agenttypes
* id : int(10) unsigned
* name : varchar(255)
v glpidb glpi_alerts
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* type : int(11)
* date : timestamp
v glpidb 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 glpidb glpi_applianceenvironments
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v glpidb 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 glpidb glpi_appliances_items
* id : int(10) unsigned
* appliances_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
v glpidb glpi_appliances_items_relations
* id : int(10) unsigned
* appliances_items_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpidb glpi_appliancetypes
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* externalidentifier : varchar(255)
v glpidb glpi_authldapreplicates
* id : int(10) unsigned
* authldaps_id : int(10) unsigned
* host : varchar(255)
* port : int(11)
* name : varchar(255)
* timeout : int(11)
v glpidb 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 glpidb 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 glpidb glpi_autoupdatesystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v glpidb glpi_blacklistedmailcontents
* id : int(10) unsigned
* name : varchar(255)
* content : text
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_blacklists
* id : int(10) unsigned
* type : int(11)
* name : varchar(255)
* value : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_budgettypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_cablestrands
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_cabletypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_calendars_holidays
* id : int(10) unsigned
* calendars_id : int(10) unsigned
* holidays_id : int(10) unsigned
v glpidb 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 glpidb glpi_cartridgeitems_printermodels
* id : int(10) unsigned
* cartridgeitems_id : int(10) unsigned
* printermodels_id : int(10) unsigned
v glpidb glpi_cartridgeitemtypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_changes
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* is_deleted : tinyint(4)
* status : int(11)
* content : longtext
* date_mod : timestamp
* date : timestamp
* solvedate : timestamp
* closedate : timestamp
* time_to_resolve : timestamp
* users_id_recipient : int(10) unsigned
* users_id_lastupdater : int(10) unsigned
* urgency : int(11)
* impact : int(11)
* priority : int(11)
* itilcategories_id : int(10) unsigned
* impactcontent : longtext
* controlistcontent : longtext
* rolloutplancontent : longtext
* backoutplancontent : longtext
* checklistcontent : longtext
* global_validation : int(11)
* validation_percent : int(11)
* actiontime : int(11)
* begin_waiting_date : timestamp
* waiting_duration : int(11)
* close_delay_stat : int(11)
* solve_delay_stat : int(11)
* date_creation : timestamp
* locations_id : int(10) unsigned
v glpidb glpi_changes_groups
* id : int(10) unsigned
* changes_id : int(10) unsigned
* groups_id : int(10) unsigned
* type : int(11)
v glpidb glpi_changes_items
* id : int(10) unsigned
* changes_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpidb glpi_changes_problems
* id : int(10) unsigned
* changes_id : int(10) unsigned
* problems_id : int(10) unsigned
v glpidb 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 glpidb glpi_changes_tickets
* id : int(10) unsigned
* changes_id : int(10) unsigned
* tickets_id : int(10) unsigned
v glpidb 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 glpidb 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 glpidb glpi_changetemplatehiddenfields
* id : int(10) unsigned
* changetemplates_id : int(10) unsigned
* num : int(11)
v glpidb glpi_changetemplatemandatoryfields
* id : int(10) unsigned
* changetemplates_id : int(10) unsigned
* num : int(11)
v glpidb glpi_changetemplatepredefinedfields
* id : int(10) unsigned
* changetemplates_id : int(10) unsigned
* num : int(11)
* value : text
v glpidb glpi_changetemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_computertypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_computervirtualmachines
* id : int(10) unsigned
* entities_id : int(10) unsigned
* computers_id : int(10) unsigned
* name : varchar(255)
* virtualmachinestates_id : int(10) unsigned
* virtualmachinesystems_id : int(10) unsigned
* virtualmachinetypes_id : int(10) unsigned
* uuid : varchar(255)
* vcpu : int(11)
* ram : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_configs
* id : int(10) unsigned
* context : varchar(150)
* name : varchar(150)
* value : text
v glpidb 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 glpidb glpi_consumableitemtypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_contacts_suppliers
* id : int(10) unsigned
* suppliers_id : int(10) unsigned
* contacts_id : int(10) unsigned
v glpidb glpi_contacttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_contracts
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* num : varchar(255)
* contracttypes_id : int(10) unsigned
* locations_id : int(10) unsigned
* begin_date : date
* duration : int(11)
* notice : int(11)
* periodicity : int(11)
* billing : int(11)
* comment : text
* accounting_number : varchar(255)
* is_deleted : tinyint(4)
* week_begin_hour : time
* week_end_hour : time
* saturday_begin_hour : time
* saturday_end_hour : time
* use_saturday : tinyint(4)
* sunday_begin_hour : time
* sunday_end_hour : time
* use_sunday : tinyint(4)
* alert : int(11)
* renewal : int(11)
* template_name : varchar(255)
* is_template : tinyint(4)
* states_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_contracts_items
* id : int(10) unsigned
* contracts_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
v glpidb glpi_contracts_suppliers
* id : int(10) unsigned
* suppliers_id : int(10) unsigned
* contracts_id : int(10) unsigned
v glpidb glpi_contracttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_dashboards_dashboards
* id : int(10) unsigned
* key : varchar(100)
* name : varchar(100)
* context : varchar(100)
* users_id : int(10) unsigned
v glpidb glpi_dashboards_filters
* id : int(10) unsigned
* dashboards_dashboards_id : int(10) unsigned
* users_id : int(10) unsigned
* filter : longtext
v glpidb 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 glpidb glpi_dashboards_rights
* id : int(10) unsigned
* dashboards_dashboards_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpidb glpi_databaseinstancecategories
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_databaseinstancetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_devicebatterymodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb glpi_devicebatterytypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_devicecameramodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_devicecasemodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_devicecasetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_devicecontrolmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_devicedrivemodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_devicefirmwaremodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_devicefirmwaretypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_devicegenericmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_devicegenerictypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v glpidb glpi_devicegraphiccardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_deviceharddrivemodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb 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 glpidb glpi_devicememorymodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb glpi_devicememorytypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_devicemotherboardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_devicenetworkcardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_devicepcimodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb 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 glpidb glpi_devicepowersupplymodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb glpi_deviceprocessormodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_devicesensormodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_devicesensortypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v glpidb 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 glpidb glpi_devicesimcardtypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_devicesoundcardmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
v glpidb 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 glpidb glpi_displaypreferences
* id : int(10) unsigned
* itemtype : varchar(100)
* num : int(11)
* rank : int(11)
* users_id : int(10) unsigned
v glpidb 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 glpidb glpi_documents
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* filename : varchar(255)
* filepath : varchar(255)
* documentcategories_id : int(10) unsigned
* mime : varchar(255)
* date_mod : timestamp
* comment : text
* is_deleted : tinyint(4)
* users_id : int(10) unsigned
* tickets_id : int(10) unsigned
* sha1sum : char(40)
* is_blacklisted : tinyint(4)
* tag : varchar(255)
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb 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 glpidb glpi_domainrecordtypes
* id : int(10) unsigned
* name : varchar(255)
* fields : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpidb glpi_domainrelations
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpidb 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 glpidb glpi_domains_items
* id : int(10) unsigned
* domains_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* domainrelations_id : int(10) unsigned
* is_dynamic : tinyint(4)
* is_deleted : tinyint(4)
v glpidb glpi_domaintypes
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpidb glpi_dropdowntranslations
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* language : varchar(10)
* field : varchar(100)
* value : text
v glpidb 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 glpidb 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 glpidb 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 glpidb glpi_entities_knowbaseitems
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v glpidb glpi_entities_reminders
* id : int(10) unsigned
* reminders_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v glpidb glpi_entities_rssfeeds
* id : int(10) unsigned
* rssfeeds_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v glpidb 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 glpidb 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 glpidb 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 glpidb glpi_filesystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb 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 glpidb glpi_groups_problems
* id : int(10) unsigned
* problems_id : int(10) unsigned
* groups_id : int(10) unsigned
* type : int(11)
v glpidb 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 glpidb 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 glpidb glpi_groups_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* groups_id : int(10) unsigned
* type : int(11)
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_impactcompounds
* id : int(10) unsigned
* name : varchar(255)
* color : varchar(255)
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_interfacetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_ipaddresses_ipnetworks
* id : int(10) unsigned
* ipaddresses_id : int(10) unsigned
* ipnetworks_id : int(10) unsigned
v glpidb 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 glpidb glpi_ipnetworks_vlans
* id : int(10) unsigned
* ipnetworks_id : int(10) unsigned
* vlans_id : int(10) unsigned
v glpidb glpi_items_clusters
* id : int(10) unsigned
* clusters_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpidb 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 glpidb glpi_items_devicecameras
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* devicecameras_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* locations_id : int(10) unsigned
v glpidb glpi_items_devicecameras_imageformats
* id : int(10) unsigned
* items_devicecameras_id : int(10) unsigned
* imageformats_id : int(10) unsigned
* is_dynamic : tinyint(4)
* is_deleted : tinyint(4)
v glpidb glpi_items_devicecameras_imageresolutions
* id : int(10) unsigned
* items_devicecameras_id : int(10) unsigned
* imageresolutions_id : int(10) unsigned
* is_dynamic : tinyint(4)
* is_deleted : tinyint(4)
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_items_enclosures
* id : int(10) unsigned
* enclosures_id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* position : int(11)
v glpidb 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 glpidb glpi_items_operatingsystems
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* operatingsystems_id : int(10) unsigned
* operatingsystemversions_id : int(10) unsigned
* operatingsystemservicepacks_id : int(10) unsigned
* operatingsystemarchitectures_id : int(10) unsigned
* operatingsystemkernelversions_id : int(10) unsigned
* license_number : varchar(255)
* licenseid : varchar(255)
* company : varchar(255)
* owner : varchar(255)
* hostid : varchar(255)
* operatingsystemeditions_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
* is_deleted : tinyint(4)
* is_dynamic : tinyint(4)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* install_date : date
v glpidb glpi_items_problems
* id : int(10) unsigned
* problems_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpidb glpi_items_projects
* id : int(10) unsigned
* projects_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_items_tickets
* id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* tickets_id : int(10) unsigned
v glpidb 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 glpidb 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 glpidb glpi_itilfollowuptemplates
* id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* content : mediumtext
* requesttypes_id : int(10) unsigned
* is_private : tinyint(4)
* comment : text
v glpidb 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 glpidb glpi_itils_projects
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* projects_id : int(10) unsigned
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_knowbaseitems_knowbaseitemcategories
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* knowbaseitemcategories_id : int(10) unsigned
v glpidb 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 glpidb 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 glpidb glpi_knowbaseitems_users
* id : int(10) unsigned
* knowbaseitems_id : int(10) unsigned
* users_id : int(10) unsigned
v glpidb 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 glpidb 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 glpidb 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 glpidb glpi_linetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_logs
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* linked_action : int(11)
* user_name : varchar(255)
* date_mod : timestamp
* id_search_option : int(11)
* old_value : varchar(255)
* new_value : varchar(255)
v glpidb glpi_mailcollectors
* id : int(10) unsigned
* name : varchar(255)
* host : varchar(255)
* login : varchar(255)
* filesize_max : int(11)
* is_active : tinyint(4)
* date_mod : timestamp
* comment : text
* passwd : varchar(255)
* accepted : varchar(255)
* refused : varchar(255)
* errors : int(11)
* use_mail_date : tinyint(4)
* date_creation : timestamp
* requester_field : int(11)
* add_cc_to_observer : tinyint(4)
* collect_only_unread : tinyint(4)
* last_collect_date : timestamp
v glpidb glpi_manufacturers
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_monitortypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_networkequipments
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* ram : int(10) unsigned
* serial : varchar(255)
* otherserial : varchar(255)
* contact : varchar(255)
* contact_num : varchar(255)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* date_mod : timestamp
* comment : text
* locations_id : int(10) unsigned
* networks_id : int(10) unsigned
* networkequipmenttypes_id : int(10) unsigned
* networkequipmentmodels_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* is_deleted : tinyint(4)
* is_template : tinyint(4)
* template_name : varchar(255)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* states_id : int(10) unsigned
* ticket_tco : decimal(20,4)
* is_dynamic : tinyint(4)
* uuid : varchar(255)
* date_creation : timestamp
* autoupdatesystems_id : int(10) unsigned
* sysdescr : text
* cpu : int(11)
* uptime : varchar(255)
* last_inventory_update : timestamp
* snmpcredentials_id : int(10) unsigned
v glpidb glpi_networkequipmenttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_networkinterfaces
* id : int(10) unsigned
* name : varchar(255)
* comment : text
v glpidb 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 glpidb glpi_networkportaggregates
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* networkports_id_list : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_networkportaliases
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* networkports_id_alias : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_networkportconnectionlogs
* id : int(10) unsigned
* date : timestamp
* connected : tinyint(4)
* networkports_id_source : int(10) unsigned
* networkports_id_destination : int(10) unsigned
v glpidb glpi_networkportdialups
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_networkportfiberchannels
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* items_devicenetworkcards_id : int(10) unsigned
* networkportfiberchanneltypes_id : int(10) unsigned
* wwn : varchar(50)
* speed : int(11)
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_networkportfiberchanneltypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_networkportlocals
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_networkports_networkports
* id : int(10) unsigned
* networkports_id_1 : int(10) unsigned
* networkports_id_2 : int(10) unsigned
v glpidb glpi_networkports_vlans
* id : int(10) unsigned
* networkports_id : int(10) unsigned
* vlans_id : int(10) unsigned
* tagged : tinyint(4)
v glpidb 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 glpidb 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 glpidb glpi_networks
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_notifications_notificationtemplates
* id : int(10) unsigned
* notifications_id : int(10) unsigned
* mode : varchar(20)
* notificationtemplates_id : int(10) unsigned
v glpidb glpi_notificationtargets
* id : int(10) unsigned
* items_id : int(10) unsigned
* type : int(11)
* notifications_id : int(10) unsigned
v glpidb glpi_notificationtemplates
* id : int(10) unsigned
* name : varchar(255)
* itemtype : varchar(100)
* date_mod : timestamp
* comment : text
* css : text
* date_creation : timestamp
v glpidb glpi_notificationtemplatetranslations
* id : int(10) unsigned
* notificationtemplates_id : int(10) unsigned
* language : varchar(10)
* subject : varchar(255)
* content_text : text
* content_html : text
v glpidb 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 glpidb glpi_objectlocks
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* users_id : int(10) unsigned
* date : timestamp
v glpidb glpi_olalevelactions
* id : int(10) unsigned
* olalevels_id : int(10) unsigned
* action_type : varchar(255)
* field : varchar(255)
* value : varchar(255)
v glpidb glpi_olalevelcriterias
* id : int(10) unsigned
* olalevels_id : int(10) unsigned
* criteria : varchar(255)
* condition : int(11)
* pattern : varchar(255)
v glpidb 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 glpidb glpi_olalevels_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* olalevels_id : int(10) unsigned
* date : timestamp
v glpidb 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 glpidb glpi_operatingsystemarchitectures
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_operatingsystemeditions
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_operatingsystemkernels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_operatingsystemkernelversions
* id : int(10) unsigned
* operatingsystemkernels_id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_operatingsystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_operatingsystemservicepacks
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_operatingsystemversions
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_passivedcequipmenttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_pendingreasons_items
* id : int(10) unsigned
* pendingreasons_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* followup_frequency : int(11)
* followups_before_resolution : int(11)
* bump_count : int(11)
* last_bump_date : timestamp
* previous_status : int(11)
v glpidb 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 glpidb 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 glpidb glpi_peripheraltypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_phonepowersupplies
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_phonetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_planningeventcategories
* id : int(10) unsigned
* name : varchar(255)
* color : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_planningexternaleventtemplates
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* text : mediumtext
* comment : text
* duration : int(11)
* before_time : int(11)
* rrule : text
* state : int(11)
* planningeventcategories_id : int(10) unsigned
* background : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_plugin_actualtime_configs
* id : int(10) unsigned
* displayinfofor : smallint(6)
* showtimerpopup : tinyint(4)
* showtimerinbox : tinyint(4)
* autoopenrunning : tinyint(4)
* autoupdate_duration : tinyint(4)
* planned_task : tinyint(4)
* multiple_day : tinyint(4)
v glpidb glpi_plugin_actualtime_tasks
* id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* actual_begin : timestamp
* actual_end : timestamp
* users_id : int(10) unsigned
* actual_actiontime : int(10) unsigned
* origin_start : int(10) unsigned
* origin_end : int(10) unsigned
* override_begin : timestamp
* override_end : timestamp
v glpidb glpi_plugin_addressing_addressings
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* use_as_filter : tinyint(4)
* networks_id : int(10) unsigned
* locations_id : int(10) unsigned
* fqdns_id : int(10) unsigned
* vlans_id : int(10) unsigned
* begin_ip : varchar(255)
* end_ip : varchar(255)
* alloted_ip : tinyint(4)
* double_ip : tinyint(4)
* free_ip : tinyint(4)
* reserved_ip : tinyint(4)
* use_ping : tinyint(4)
* comment : text
* is_deleted : tinyint(4)
v glpidb glpi_plugin_addressing_configs
* id : int(10) unsigned
* alloted_ip : tinyint(4)
* double_ip : tinyint(4)
* free_ip : tinyint(4)
* reserved_ip : tinyint(4)
* use_ping : tinyint(4)
* used_system : tinyint(4)
v glpidb glpi_plugin_addressing_filters
* id : int(10) unsigned
* entities_id : int(10) unsigned
* plugin_addressing_addressings_id : int(10) unsigned
* name : varchar(255)
* begin_ip : varchar(255)
* end_ip : varchar(255)
* type : varchar(255)
v glpidb glpi_plugin_addressing_ipcomments
* id : int(10) unsigned
* plugin_addressing_addressings_id : int(10) unsigned
* ipname : varchar(255)
* comments : longtext
v glpidb glpi_plugin_addressing_pinginfos
* id : int(10) unsigned
* plugin_addressing_addressings_id : int(10) unsigned
* ipname : varchar(255)
* items_id : int(10) unsigned
* itemtype : varchar(100)
* ping_response : tinyint(4)
* ping_date : timestamp
v glpidb glpi_plugin_dashboard_config
* id : int(4)
* name : varchar(50)
* value : varchar(125)
* users_id : varchar(25)
v glpidb glpi_plugin_dashboard_count
* type : int(11)
* id : int(11)
* quant : int(11)
v glpidb glpi_plugin_dashboard_map
* id : int(4)
* entities_id : int(4)
* location : varchar(50)
* lat : float
* lng : float
v glpidb glpi_plugin_fields_containerdisplayconditions
* id : int(10) unsigned
* plugin_fields_containers_id : int(10) unsigned
* itemtype : varchar(100)
* search_option : varchar(255)
* condition : varchar(255)
* value : varchar(255)
* is_visible : tinyint(4)
v glpidb glpi_plugin_fields_containers
* id : int(10) unsigned
* name : varchar(255)
* label : varchar(255)
* itemtypes : longtext
* type : varchar(255)
* subtype : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* is_active : tinyint(4)
v glpidb glpi_plugin_fields_fields
* id : int(10) unsigned
* name : varchar(255)
* label : varchar(255)
* type : varchar(255)
* plugin_fields_containers_id : int(10) unsigned
* ranking : int(11)
* default_value : longtext
* is_active : tinyint(4)
* is_readonly : tinyint(4)
* mandatory : tinyint(4)
* multiple : tinyint(4)
* allowed_values : text
v glpidb glpi_plugin_fields_labeltranslations
* id : int(10) unsigned
* itemtype : varchar(30)
* items_id : int(10) unsigned
* language : varchar(5)
* label : varchar(255)
v glpidb glpi_plugin_fields_profiles
* id : int(10) unsigned
* profiles_id : int(10) unsigned
* plugin_fields_containers_id : int(10) unsigned
* right : char(1)
v glpidb glpi_plugin_fields_statusoverrides
* id : int(10) unsigned
* plugin_fields_fields_id : int(10) unsigned
* itemtype : varchar(100)
* states : varchar(255)
* is_readonly : tinyint(4)
* mandatory : tinyint(4)
v glpidb glpi_plugin_fields_ticketprazos
* id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(255)
* plugin_fields_containers_id : int(10) unsigned
* prazodochamadofield : varchar(255)
v glpidb glpi_plugin_glpiinventory_agentmodules
* id : int(10) unsigned
* modulename : varchar(255)
* is_active : tinyint(4)
* exceptions : text
v glpidb glpi_plugin_glpiinventory_collects
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* type : varchar(255)
* is_active : tinyint(4)
* comment : text
v glpidb glpi_plugin_glpiinventory_collects_files
* id : int(10) unsigned
* name : varchar(255)
* plugin_glpiinventory_collects_id : int(10) unsigned
* dir : varchar(255)
* limit : int(11)
* is_recursive : tinyint(4)
* filter_regex : varchar(255)
* filter_sizeequals : int(11)
* filter_sizegreater : int(11)
* filter_sizelower : int(11)
* filter_checksumsha512 : varchar(255)
* filter_checksumsha2 : varchar(255)
* filter_name : varchar(255)
* filter_iname : varchar(255)
* filter_is_file : tinyint(4)
* filter_is_dir : tinyint(4)
v glpidb glpi_plugin_glpiinventory_collects_files_contents
* id : int(10) unsigned
* computers_id : int(10) unsigned
* plugin_glpiinventory_collects_files_id : int(10) unsigned
* pathfile : text
* size : int(11)
v glpidb glpi_plugin_glpiinventory_collects_registries
* id : int(10) unsigned
* name : varchar(255)
* plugin_glpiinventory_collects_id : int(10) unsigned
* hive : varchar(255)
* path : text
* key : varchar(255)
v glpidb glpi_plugin_glpiinventory_collects_registries_contents
* id : int(10) unsigned
* computers_id : int(10) unsigned
* plugin_glpiinventory_collects_registries_id : int(10) unsigned
* key : varchar(255)
* value : varchar(255)
v glpidb glpi_plugin_glpiinventory_collects_wmis
* id : int(10) unsigned
* name : varchar(255)
* plugin_glpiinventory_collects_id : int(10) unsigned
* moniker : varchar(255)
* class : varchar(255)
* properties : varchar(255)
v glpidb glpi_plugin_glpiinventory_collects_wmis_contents
* id : int(10) unsigned
* computers_id : int(10) unsigned
* plugin_glpiinventory_collects_wmis_id : int(10) unsigned
* property : varchar(255)
* value : varchar(255)
v glpidb glpi_plugin_glpiinventory_configs
* id : int(10) unsigned
* type : varchar(255)
* value : varchar(255)
v glpidb glpi_plugin_glpiinventory_credentialips
* id : int(10) unsigned
* entities_id : int(10) unsigned
* plugin_glpiinventory_credentials_id : int(10) unsigned
* name : varchar(255)
* comment : text
* ip : varchar(255)
* date_mod : timestamp
v glpidb glpi_plugin_glpiinventory_credentials
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* username : varchar(255)
* password : varchar(255)
* comment : text
* date_mod : timestamp
* itemtype : varchar(255)
v glpidb glpi_plugin_glpiinventory_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(4)
* date_mod : timestamp
v glpidb glpi_plugin_glpiinventory_deploygroups
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* type : varchar(255)
v glpidb glpi_plugin_glpiinventory_deploygroups_dynamicdatas
* id : int(10) unsigned
* plugin_glpiinventory_deploygroups_id : int(10) unsigned
* fields_array : text
* can_update_group : tinyint(4)
* computers_id_cache : longtext
v glpidb glpi_plugin_glpiinventory_deploygroups_staticdatas
* id : int(10) unsigned
* plugin_glpiinventory_deploygroups_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpidb glpi_plugin_glpiinventory_deploymirrors
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_active : tinyint(4)
* is_recursive : tinyint(4)
* name : varchar(255)
* url : varchar(255)
* locations_id : int(10) unsigned
* comment : text
* date_mod : timestamp
v glpidb glpi_plugin_glpiinventory_deploypackages
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* date_mod : timestamp
* uuid : varchar(255)
* json : longtext
* plugin_glpiinventory_deploygroups_id : int(10) unsigned
v glpidb glpi_plugin_glpiinventory_deploypackages_entities
* id : int(10) unsigned
* plugin_glpiinventory_deploypackages_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v glpidb glpi_plugin_glpiinventory_deploypackages_groups
* id : int(10) unsigned
* plugin_glpiinventory_deploypackages_id : int(10) unsigned
* groups_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v glpidb glpi_plugin_glpiinventory_deploypackages_profiles
* id : int(10) unsigned
* plugin_glpiinventory_deploypackages_id : int(10) unsigned
* profiles_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
v glpidb glpi_plugin_glpiinventory_deploypackages_users
* id : int(10) unsigned
* plugin_glpiinventory_deploypackages_id : int(10) unsigned
* users_id : int(10) unsigned
v glpidb glpi_plugin_glpiinventory_deployuserinteractiontemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* date_creation : timestamp
* date_mod : timestamp
* json : longtext
v glpidb glpi_plugin_glpiinventory_inventorycomputerstats
* id : smallint(5) unsigned
* day : smallint(6)
* hour : tinyint(4)
* counter : int(11)
v glpidb glpi_plugin_glpiinventory_ipranges
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* ip_start : varchar(255)
* ip_end : varchar(255)
v glpidb glpi_plugin_glpiinventory_ipranges_snmpcredentials
* id : int(10) unsigned
* plugin_glpiinventory_ipranges_id : int(10) unsigned
* snmpcredentials_id : int(10) unsigned
* rank : int(11)
v glpidb glpi_plugin_glpiinventory_statediscoveries
* id : int(10) unsigned
* plugin_glpiinventory_taskjob_id : int(10) unsigned
* agents_id : int(10) unsigned
* start_time : timestamp
* end_time : timestamp
* date_mod : timestamp
* threads : int(11)
* nb_ip : int(11)
* nb_found : int(11)
* nb_error : int(11)
* nb_exists : int(11)
* nb_import : int(11)
v glpidb glpi_plugin_glpiinventory_taskjoblogs
* id : bigint(20) unsigned
* plugin_glpiinventory_taskjobstates_id : int(10) unsigned
* date : timestamp
* items_id : int(10) unsigned
* itemtype : varchar(100)
* state : int(11)
* comment : text
v glpidb glpi_plugin_glpiinventory_taskjobs
* id : int(10) unsigned
* plugin_glpiinventory_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
* restrict_to_task_entity : tinyint(4)
v glpidb glpi_plugin_glpiinventory_taskjobstates
* id : bigint(20) unsigned
* plugin_glpiinventory_taskjobs_id : int(10) unsigned
* items_id : int(10) unsigned
* itemtype : varchar(100)
* state : int(11)
* agents_id : int(10) unsigned
* specificity : text
* uniqid : varchar(255)
* date_start : timestamp
* nb_retry : int(11)
* max_retry : int(11)
v glpidb glpi_plugin_glpiinventory_tasks
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* date_creation : timestamp
* comment : text
* is_active : tinyint(4)
* datetime_start : timestamp
* datetime_end : timestamp
* plugin_glpiinventory_timeslots_prep_id : int(10) unsigned
* plugin_glpiinventory_timeslots_exec_id : int(10) unsigned
* last_agent_wakeup : timestamp
* wakeup_agent_counter : int(11)
* wakeup_agent_time : int(11)
* reprepare_if_successful : tinyint(4)
* is_deploy_on_demand : tinyint(4)
v glpidb glpi_plugin_glpiinventory_timeslotentries
* id : int(10) unsigned
* plugin_glpiinventory_timeslots_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* day : tinyint(4)
* begin : int(11)
* end : int(11)
v glpidb glpi_plugin_glpiinventory_timeslots
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* comment : text
* date_mod : timestamp
v glpidb glpi_plugin_mreporting_configs
* id : int(10) unsigned
* name : varchar(255)
* classname : varchar(255)
* is_active : tinyint(4)
* is_notified : tinyint(4)
* show_graph : tinyint(4)
* show_area : tinyint(4)
* spline : tinyint(4)
* show_label : varchar(10)
* flip_data : tinyint(4)
* unit : varchar(10)
* default_delay : varchar(10)
* condition : varchar(255)
* graphtype : varchar(255)
v glpidb glpi_plugin_mreporting_dashboards
* id : int(10) unsigned
* users_id : int(10) unsigned
* reports_id : int(10) unsigned
* configuration : varchar(500)
v glpidb glpi_plugin_mreporting_notifications
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* notepad : longtext
* date_envoie : date
* notice : int(10) unsigned
* alert : int(10) unsigned
* comment : text
* date_mod : timestamp
* is_deleted : tinyint(4)
v glpidb glpi_plugin_mreporting_preferences
* id : int(10) unsigned
* users_id : int(10) unsigned
* template : varchar(255)
* selectors : text
v glpidb glpi_plugin_mreporting_profiles
* id : int(10) unsigned
* profiles_id : int(10) unsigned
* reports : int(11)
* right : char(1)
v glpidb glpi_plugin_news_alerts
* id : int(10) unsigned
* date_mod : timestamp
* name : varchar(255)
* message : text
* date_start : timestamp
* date_end : timestamp
* type : int(11)
* is_deleted : tinyint(4)
* is_displayed_onlogin : tinyint(4)
* is_displayed_oncentral : tinyint(4)
* display_dates : tinyint(4)
* background_color : varchar(255)
* text_color : varchar(255)
* emphasis_color : varchar(255)
* size : varchar(255)
* icon : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* is_displayed_onhelpdesk : tinyint(4)
* date_creation : date
* is_close_allowed : tinyint(4)
* is_active : tinyint(4)
v glpidb glpi_plugin_news_alerts_targets
* id : int(10) unsigned
* plugin_news_alerts_id : int(10) unsigned
* itemtype : varchar(255)
* items_id : int(10) unsigned
* all_items : tinyint(4)
v glpidb glpi_plugin_news_alerts_users
* id : int(10) unsigned
* plugin_news_alerts_id : int(10) unsigned
* users_id : int(10) unsigned
* state : tinyint(4)
v glpidb glpi_plugs
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_printertypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_problems
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* is_deleted : tinyint(4)
* status : int(11)
* content : longtext
* date_mod : timestamp
* date : timestamp
* solvedate : timestamp
* closedate : timestamp
* time_to_resolve : timestamp
* users_id_recipient : int(10) unsigned
* users_id_lastupdater : int(10) unsigned
* urgency : int(11)
* impact : int(11)
* priority : int(11)
* itilcategories_id : int(10) unsigned
* impactcontent : longtext
* causecontent : longtext
* symptomcontent : longtext
* actiontime : int(11)
* begin_waiting_date : timestamp
* waiting_duration : int(11)
* close_delay_stat : int(11)
* solve_delay_stat : int(11)
* date_creation : timestamp
* locations_id : int(10) unsigned
v glpidb 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 glpidb glpi_problems_tickets
* id : int(10) unsigned
* problems_id : int(10) unsigned
* tickets_id : int(10) unsigned
v glpidb 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 glpidb 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 glpidb glpi_problemtemplatehiddenfields
* id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* num : int(11)
v glpidb glpi_problemtemplatemandatoryfields
* id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* num : int(11)
v glpidb glpi_problemtemplatepredefinedfields
* id : int(10) unsigned
* problemtemplates_id : int(10) unsigned
* num : int(11)
* value : text
v glpidb glpi_problemtemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpidb glpi_profilerights
* id : int(10) unsigned
* profiles_id : int(10) unsigned
* name : varchar(255)
* rights : int(11)
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_projecttasks_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* projecttasks_id : int(10) unsigned
v glpidb glpi_projecttaskteams
* id : int(10) unsigned
* projecttasks_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpidb 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 glpidb glpi_projecttasktypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_projectteams
* id : int(10) unsigned
* projects_id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
v glpidb glpi_projecttypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_queuednotifications
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* notificationtemplates_id : int(10) unsigned
* entities_id : int(10) unsigned
* is_deleted : tinyint(4)
* sent_try : int(11)
* create_time : timestamp
* send_time : timestamp
* sent_time : timestamp
* name : text
* sender : text
* sendername : text
* recipient : text
* recipientname : text
* replyto : text
* replytoname : text
* headers : text
* body_html : longtext
* body_text : longtext
* messageid : text
* documents : text
* mode : varchar(20)
* event : varchar(255)
v glpidb glpi_rackmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* product_number : varchar(255)
* date_mod : timestamp
* date_creation : timestamp
* pictures : text
v glpidb 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 glpidb 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 glpidb 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 glpidb glpi_refusedequipments
* id : int(10) unsigned
* name : varchar(255)
* itemtype : varchar(100)
* entities_id : int(10) unsigned
* ip : text
* mac : text
* rules_id : int(10) unsigned
* method : varchar(255)
* serial : varchar(255)
* uuid : varchar(255)
* agents_id : int(10) unsigned
* autoupdatesystems_id : int(10) unsigned
* date_creation : timestamp
* date_mod : timestamp
v glpidb glpi_registeredids
* id : int(10) unsigned
* name : varchar(255)
* items_id : int(10) unsigned
* itemtype : varchar(100)
* device_type : varchar(100)
v glpidb 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 glpidb glpi_reminders_users
* id : int(10) unsigned
* reminders_id : int(10) unsigned
* users_id : int(10) unsigned
v glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb 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 glpidb glpi_rssfeeds_users
* id : int(10) unsigned
* rssfeeds_id : int(10) unsigned
* users_id : int(10) unsigned
v glpidb glpi_ruleactions
* id : int(10) unsigned
* rules_id : int(10) unsigned
* action_type : varchar(255)
* field : varchar(255)
* value : varchar(255)
v glpidb glpi_rulecriterias
* id : int(10) unsigned
* rules_id : int(10) unsigned
* criteria : varchar(255)
* condition : int(11)
* pattern : text
v glpidb 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 glpidb glpi_rulerightparameters
* id : int(10) unsigned
* name : varchar(255)
* value : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb 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 glpidb glpi_savedsearches_users
* id : int(10) unsigned
* users_id : int(10) unsigned
* itemtype : varchar(100)
* savedsearches_id : int(10) unsigned
v glpidb glpi_slalevelactions
* id : int(10) unsigned
* slalevels_id : int(10) unsigned
* action_type : varchar(255)
* field : varchar(255)
* value : varchar(255)
v glpidb glpi_slalevelcriterias
* id : int(10) unsigned
* slalevels_id : int(10) unsigned
* criteria : varchar(255)
* condition : int(11)
* pattern : varchar(255)
v glpidb 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 glpidb glpi_slalevels_tickets
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* slalevels_id : int(10) unsigned
* date : timestamp
v glpidb 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 glpidb 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 glpidb 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 glpidb glpi_socketmodels
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_softwarelicenses
* id : int(10) unsigned
* softwares_id : int(10) unsigned
* softwarelicenses_id : int(10) unsigned
* completename : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* number : int(11)
* softwarelicensetypes_id : int(10) unsigned
* name : varchar(255)
* serial : varchar(255)
* otherserial : varchar(255)
* softwareversions_id_buy : int(10) unsigned
* softwareversions_id_use : int(10) unsigned
* expire : date
* comment : text
* date_mod : timestamp
* is_valid : tinyint(4)
* date_creation : timestamp
* is_deleted : tinyint(4)
* locations_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* users_id : int(10) unsigned
* groups_id_tech : int(10) unsigned
* groups_id : int(10) unsigned
* is_helpdesk_visible : tinyint(4)
* is_template : tinyint(4)
* template_name : varchar(255)
* states_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* contact : varchar(255)
* contact_num : varchar(255)
* allow_overquota : tinyint(4)
* pictures : text
v glpidb 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 glpidb 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 glpidb 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 glpidb glpi_solutiontemplates
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* content : mediumtext
* solutiontypes_id : int(10) unsigned
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_ssovariables
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_states
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
* states_id : int(10) unsigned
* completename : text
* level : int(11)
* ancestors_cache : longtext
* sons_cache : longtext
* is_visible_computer : tinyint(4)
* is_visible_monitor : tinyint(4)
* is_visible_networkequipment : tinyint(4)
* is_visible_peripheral : tinyint(4)
* is_visible_phone : tinyint(4)
* is_visible_printer : tinyint(4)
* is_visible_softwareversion : tinyint(4)
* is_visible_softwarelicense : tinyint(4)
* is_visible_line : tinyint(4)
* is_visible_certificate : tinyint(4)
* is_visible_rack : tinyint(4)
* is_visible_passivedcequipment : tinyint(4)
* is_visible_enclosure : tinyint(4)
* is_visible_pdu : tinyint(4)
* is_visible_cluster : tinyint(4)
* is_visible_contract : tinyint(4)
* is_visible_appliance : tinyint(4)
* is_visible_databaseinstance : tinyint(4)
* is_visible_cable : tinyint(4)
* is_visible_unmanaged : tinyint(4)
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb 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 glpidb glpi_suppliertypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_tasktemplates
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* content : mediumtext
* taskcategories_id : int(10) unsigned
* actiontime : int(11)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
* state : int(11)
* is_private : tinyint(4)
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
v glpidb 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 glpidb 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 glpidb glpi_tickets
* id : int(10) unsigned
* entities_id : int(10) unsigned
* name : varchar(255)
* date : timestamp
* closedate : timestamp
* solvedate : timestamp
* takeintoaccountdate : timestamp
* date_mod : timestamp
* users_id_lastupdater : int(10) unsigned
* status : int(11)
* users_id_recipient : int(10) unsigned
* requesttypes_id : int(10) unsigned
* content : longtext
* urgency : int(11)
* impact : int(11)
* priority : int(11)
* itilcategories_id : int(10) unsigned
* type : int(11)
* global_validation : int(11)
* slas_id_ttr : int(10) unsigned
* slas_id_tto : int(10) unsigned
* slalevels_id_ttr : int(10) unsigned
* time_to_resolve : timestamp
* time_to_own : timestamp
* begin_waiting_date : timestamp
* sla_waiting_duration : int(11)
* ola_waiting_duration : int(11)
* olas_id_tto : int(10) unsigned
* olas_id_ttr : int(10) unsigned
* olalevels_id_ttr : int(10) unsigned
* ola_tto_begin_date : timestamp
* ola_ttr_begin_date : timestamp
* internal_time_to_resolve : timestamp
* internal_time_to_own : timestamp
* waiting_duration : int(11)
* close_delay_stat : int(11)
* solve_delay_stat : int(11)
* takeintoaccount_delay_stat : int(11)
* actiontime : int(11)
* is_deleted : tinyint(4)
* locations_id : int(10) unsigned
* validation_percent : int(11)
* date_creation : timestamp
v glpidb 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 glpidb glpi_tickets_contracts
* id : int(10) unsigned
* tickets_id : int(10) unsigned
* contracts_id : int(10) unsigned
v glpidb glpi_tickets_tickets
* id : int(10) unsigned
* tickets_id_1 : int(10) unsigned
* tickets_id_2 : int(10) unsigned
v glpidb 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 glpidb 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 glpidb glpi_tickettemplatehiddenfields
* id : int(10) unsigned
* tickettemplates_id : int(10) unsigned
* num : int(11)
v glpidb glpi_tickettemplatemandatoryfields
* id : int(10) unsigned
* tickettemplates_id : int(10) unsigned
* num : int(11)
v glpidb glpi_tickettemplatepredefinedfields
* id : int(10) unsigned
* tickettemplates_id : int(10) unsigned
* num : int(11)
* value : text
v glpidb glpi_tickettemplates
* id : int(10) unsigned
* name : varchar(255)
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* comment : text
v glpidb 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 glpidb glpi_transfers
* id : int(10) unsigned
* name : varchar(255)
* keep_ticket : int(11)
* keep_reservation : int(11)
* keep_history : int(11)
* keep_device : int(11)
* keep_infocom : int(11)
* keep_dc_monitor : int(11)
* clean_dc_monitor : int(11)
* keep_dc_phone : int(11)
* clean_dc_phone : int(11)
* keep_dc_peripheral : int(11)
* clean_dc_peripheral : int(11)
* keep_dc_printer : int(11)
* clean_dc_printer : int(11)
* keep_supplier : int(11)
* clean_supplier : int(11)
* keep_contact : int(11)
* clean_contact : int(11)
* keep_contract : int(11)
* clean_contract : int(11)
* keep_software : int(11)
* clean_software : int(11)
* keep_document : int(11)
* clean_document : int(11)
* keep_cartridgeitem : int(11)
* clean_cartridgeitem : int(11)
* keep_cartridge : int(11)
* keep_consumable : int(11)
* date_mod : timestamp
* date_creation : timestamp
* comment : text
* keep_disk : int(11)
* keep_certificate : int(11)
* clean_certificate : int(11)
* lock_updated_fields : int(11)
* keep_location : int(11)
v glpidb glpi_unmanageds
* id : int(10) unsigned
* entities_id : int(10) unsigned
* is_recursive : tinyint(4)
* name : varchar(255)
* serial : varchar(255)
* otherserial : varchar(255)
* contact : varchar(255)
* contact_num : varchar(255)
* date_mod : timestamp
* comment : text
* locations_id : int(10) unsigned
* networks_id : int(10) unsigned
* manufacturers_id : int(10) unsigned
* is_deleted : tinyint(4)
* users_id : int(10) unsigned
* groups_id : int(10) unsigned
* states_id : int(10) unsigned
* users_id_tech : int(10) unsigned
* groups_id_tech : int(10) unsigned
* is_dynamic : tinyint(4)
* date_creation : timestamp
* autoupdatesystems_id : int(10) unsigned
* sysdescr : text
* agents_id : int(10) unsigned
* itemtype : varchar(100)
* accepted : tinyint(4)
* hub : tinyint(4)
* ip : varchar(255)
* snmpcredentials_id : int(10) unsigned
* last_inventory_update : timestamp
v glpidb 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 glpidb glpi_usercategories
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_useremails
* id : int(10) unsigned
* users_id : int(10) unsigned
* is_default : tinyint(4)
* is_dynamic : tinyint(4)
* email : varchar(255)
v glpidb glpi_users
* id : int(10) unsigned
* name : varchar(255)
* password : varchar(255)
* password_last_update : timestamp
* phone : varchar(255)
* phone2 : varchar(255)
* mobile : varchar(255)
* realname : varchar(255)
* firstname : varchar(255)
* locations_id : int(10) unsigned
* language : char(10)
* use_mode : int(11)
* list_limit : int(11)
* is_active : tinyint(4)
* comment : text
* auths_id : int(10) unsigned
* authtype : int(11)
* last_login : timestamp
* date_mod : timestamp
* date_sync : timestamp
* is_deleted : tinyint(4)
* profiles_id : int(10) unsigned
* entities_id : int(10) unsigned
* usertitles_id : int(10) unsigned
* usercategories_id : int(10) unsigned
* date_format : int(11)
* number_format : int(11)
* names_format : int(11)
* csv_delimiter : char(1)
* is_ids_visible : tinyint(4)
* use_flat_dropdowntree : tinyint(4)
* use_flat_dropdowntree_on_search_result : tinyint(4)
* show_jobs_at_login : tinyint(4)
* priority_1 : char(20)
* priority_2 : char(20)
* priority_3 : char(20)
* priority_4 : char(20)
* priority_5 : char(20)
* priority_6 : char(20)
* followup_private : tinyint(4)
* task_private : tinyint(4)
* default_requesttypes_id : int(10) unsigned
* password_forget_token : char(40)
* password_forget_token_date : timestamp
* user_dn : text
* user_dn_hash : varchar(32)
* registration_number : varchar(255)
* show_count_on_tabs : tinyint(4)
* refresh_views : int(11)
* set_default_tech : tinyint(4)
* personal_token : varchar(255)
* personal_token_date : timestamp
* api_token : varchar(255)
* api_token_date : timestamp
* cookie_token : varchar(255)
* cookie_token_date : timestamp
* display_count_on_home : int(11)
* notification_to_myself : tinyint(4)
* duedateok_color : varchar(255)
* duedatewarning_color : varchar(255)
* duedatecritical_color : varchar(255)
* duedatewarning_less : int(11)
* duedatecritical_less : int(11)
* duedatewarning_unit : varchar(255)
* duedatecritical_unit : varchar(255)
* display_options : text
* is_deleted_ldap : tinyint(4)
* pdffont : varchar(255)
* picture : varchar(255)
* begin_date : timestamp
* end_date : timestamp
* keep_devices_when_purging_item : tinyint(4)
* privatebookmarkorder : longtext
* backcreated : tinyint(4)
* task_state : int(11)
* palette : char(20)
* page_layout : char(20)
* fold_menu : tinyint(4)
* savedsearches_pinned : text
* timeline_order : char(20)
* itil_layout : text
* richtext_layout : char(20)
* set_default_requester : tinyint(4)
* lock_autolock_mode : tinyint(4)
* lock_directunlock_notification : tinyint(4)
* date_creation : timestamp
* highcontrast_css : tinyint(4)
* plannings : text
* sync_field : varchar(255)
* groups_id : int(10) unsigned
* users_id_supervisor : int(10) unsigned
* timezone : varchar(50)
* default_dashboard_central : varchar(100)
* default_dashboard_assets : varchar(100)
* default_dashboard_helpdesk : varchar(100)
* default_dashboard_mini_ticket : varchar(100)
* default_central_tab : tinyint(4)
* nickname : varchar(255)
* timeline_action_btn_layout : tinyint(4)
* timeline_date_format : tinyint(4)
v glpidb glpi_usertitles
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_virtualmachinestates
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_virtualmachinesystems
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb glpi_virtualmachinetypes
* id : int(10) unsigned
* name : varchar(255)
* comment : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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 glpidb glpi_vobjects
* id : int(10) unsigned
* itemtype : varchar(100)
* items_id : int(10) unsigned
* data : text
* date_mod : timestamp
* date_creation : timestamp
v glpidb 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
Criar relacionamento
FOREIGN KEY
on delete
on update
Apagar relacionamento