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 |
|---|---|---|---|---|
| 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 |