Copyright © 2008 Nicolas Noirbent - Mandriva
| Revision History | ||
|---|---|---|
| Revision 1.0 | 2008-10-07 | NN |
|
Documentation for schema v.4 |
||
Abstract
Table of Contents
The inventory database holds data on the computers managed by Pulse 2, namely their hardware (available storage, memory, connected printers/modems etc.) and software (installed software packages, registry keys etc.) configuration.
The inventory database has a number of hardware/software element tables, each describing a given computer part in detail, with fields specific to the part (e.g. the available space, in the Drive table).
Every table is linked to the Inventory and Machine tables using a table dedicated to this linking feature. For example, the Modem table is linked to the Inventory and Machine tables using the hasModem table.
This table holds a list of the inventories stored in the database.
The table primary key
The date the inventory was retrieved
The time the inventory was retrieved
Whether this inventory is the last one we retrieved for this machine
The table primary key
The machine's name
A foreign key to the "Inventory" table, pointing to the last inventory retrieved for this machine.
The "hasXxx" tables (e.g. "hasModem", "hasStorage", etc.) are used to link the "Machine", "Inventory" and parts tables. For example, the "hasStorage" table links together the "Machine", "Inventory" and "Storage" tables.
For example, the "hasStorage" table :
A foreign key to the "Machine" table
A foreign key to the "Inventory" table
A foreign key to the "hasStorage" table. For the "Modem" table it would be "modem" and "hasModem", for the "Drive" table it would be "drive" and "hasDrive", etc.