PAGE OUTDATED¶

The current page is out-of-date. Please refer to the new documentation to know about database model:
http://glpi-developer-documentation.readthedocs.io/en/latest/devapi/database/dbmodel.html

GLPI Database Model¶

Database description¶

• Description de la base données GLPI 0.72
• Description de la base données GLPI 0.78
• Schéma de la base de données GLPI

Nommage des tables de la base de donnée / tables naming of database¶

français¶

Les noms des tables sont liés aux noms des classes PHP.
On préfixe 'glpi_' et on met le nom au pluriel.
Voici quelques exemples :

• classe Ticket => table glpi_tickets
• classe ITILCategory => table glpi_itilcategories
• classe Computer_SoftwareVersion => glpi_computers_softwareversions
• classe PluginExampleProfile => glpi_plugin_example_profiles

english¶

The table names are linked with PHP classes names.
We add prefix 'glpi_' and put class name in the plural.
This is some examples :

• class Ticket => table glpi_tickets
• class ITILCategory => table glpi_itilcategories
• class Computer_SoftwareVersion => glpi_computers_softwareversions
• class PluginExampleProfile => glpi_plugin_example_profiles

Nommage des champs foreignkey / foreignkey fields naming¶

français¶

Lorsque l'on veut avoir une référence à une autre table, on ajoute un champ dont le nommage est :

1. On prend le nom de la table en relation
2. On enlève le préfix glpi_
3. On ajoute le suffixe _id

Voici des exemples

• table glpi_tickets => champ tickets_id
• table glpi_itilcategories => champ itilcategories_id
• table glpi_plugin_example_profiles => champ plugin_example_profiles_id

english¶

When we want to have a reference to another table, we add a field with naming is:

1. We get the table name related
2. We remove the prefix glpi_
3. We add the suffix _id

This is some examples

• table glpi_tickets => field tickets_id
• table glpi_itilcategories => field itilcategories_id
• table glpi_plugin_example_profiles => field plugin_example_profiles_id

Mysql Workbench scheme¶

Created using : MySQL Workbench (for Linux, version 5.2.38)

Available diagram : Softwares, Users, Tickets