...
Every component table contains five six standard columns. These are explained on the page for Matching and Storing Device AttributesChanges.
Each component table is joined to the system table by component.system_id = system.id and uses "on delete cascade". Hence if you delete the entry in the system table for a device, the joined component tables will also have the data for this device deleted.
...
Name | Type | Default | Max Length | Valid Values | ||
|---|---|---|---|---|---|---|
| id | int | 10 | ||||
| system_id | int | 10 | ||||
| current | enum | y | ('y', 'n') | |||
| last_seen | datetime | 2000-01-01 00:00:00 | ||||
| first_seen | datetime | 2000-01-01 00:00:00 | ||||
| name | varchar | 200 |
Other attributes are also stored, depending on the component in question (size, etc).
The following are the tables for the relevant attributes - attachment, bios, disk, dns, file, ip, log, memory, module, monitor, motherboard, netstat, network, nmap, optical, pagefile, partition, print_queue, processor, route, san, scsi, server, server_item, service, share, software, software_key, sound, task, user, user_group, variable, video, vm, windows.
The schema for these tables can be view in the application if you have the admin role. Go to menu -> Admin -> Database -> List Tables and then click the View button for any table.
Below is the table for partition (a typical example).
| Code Block |
|---|
CREATE TABLE `partition` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`system_id` int(10) unsigned DEFAULT NULL,
`current` enum('y','n') NOT NULL DEFAULT 'y',
`first_seen` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`last_seen` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`name` varchar(200) NOT NULL DEFAULT '',
`serial` varchar(100) NOT NULL DEFAULT '',
`description` text NOT NULL,
`device` varchar(100) NOT NULL DEFAULT '',
`hard_drive_index` varchar(100) NOT NULL DEFAULT '',
`partition_disk_index` varchar(50) NOT NULL DEFAULT '',
`mount_type` enum('mount point','partition','other') NOT NULL DEFAULT 'partition',
`mount_point` varchar(100) NOT NULL DEFAULT '',
`size` int(10) unsigned NOT NULL DEFAULT '1',
`free` int(10) unsigned NOT NULL DEFAULT '1',
`used` int(10) unsigned NOT NULL DEFAULT '1',
`format` varchar(20) NOT NULL DEFAULT '',
`bootable` varchar(10) NOT NULL DEFAULT '',
`type` varchar(100) NOT NULL DEFAULT 'local',
PRIMARY KEY (`id`),
KEY `system_id` (`system_id`),
CONSTRAINT `partition_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |