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 :
- On prend le nom de la table en relation
- On enlève le préfix glpi_
- 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:
- We get the table name related
- We remove the prefix glpi_
- 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