Forum GLPI-Project

petdoctors

Member

Registered: 2006-10-09

Posts: 21

GLPI Database Structure

Hi,

I am just about to start producing some reports from the GLPI MYSQL database using Agata reports and I was surprised to see that every defined device type has a separate table eg: glpi_device_gfxcard, glpi_device_moboard etc. and wondered why there was not a single table for inventory items, with each item having a type field (eg: 1 - gfxcard, 2=moboard etc.) as this would not only simplify reporting but would also make it easier to add new item types to the list.

I can see this would complicate field naming, but this could be resolved by having field names for each field/table stored in a separate table.

I appreciate that this might be a major structural change but might make customisation easier in the future?

Regards,

Nigel Kendrick

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: GLPI Database Structure

devices use several tables because the tables do not contains the same informations.
interface for hdd, memory for gfxcard etc etc

database do not use a naming convention for the moment;
But it is planned to clean it in the future.

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat