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

Version 1 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.

 

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  

 

 

  • No labels