Skip to end of banner
Go to start of banner

DB Schema - component tables

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

DB Schema - component tables

Open-AudIT links device components of a device to the "system" table. The system table contains the main pieces of information for every device. If a device is in Open-AudIT, it has an entry in the system table.

Every component table contains five standard columns. These are explained on the page for Matching and Storing Device Attributes.

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
idint 10 
system_idint 10 
currentenumy ('y', 'n')
last_seendatetime2000-01-01 00:00:00  
first_seendatetime2000-01-01 00:00:00  

Other attributes are also stored, depending on the component in question.

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.

  • No labels