TABLES
31
VIEWS
1
COLUMNS
167
Constraints
25
Database Properties
Database Type: PostgreSQL - 9.6.6
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| admap | 0 | 1 | 3 | 0 | Table | |
| attribute | 1 | 1 | 4 | 42673 | Table | |
| attribute_cidr | 0 | 2 | 5 | 50 | Table | |
| attributetype | 8 | 0 | 4 | 10 | Table | |
| collector | 18 | 4 | 10 | 1 | Table | |
| config | 0 | 0 | 2 | 5 | Table | |
| dashboard | 0 | 1 | 5 | 0 | Table | |
| dataview | 2 | 1 | 6 | 69 | Table | |
| dataview_link | 0 | 2 | 2 | 46 | Table | |
| displayinfo | 0 | 1 | 7 | 1 | Table | |
| enterprise | 0 | 0 | 2 | 0 | Table | This table contains a listing of IANA Private Enteprise Numbers. We use these to map sysObject IDs gathered via SNMP to vendors |
| feed | 1 | 0 | 19 | 26 | Table | |
| feed_config | 0 | 1 | 4 | 48 | Table | |
| interface | 3 | 1 | 15 | 3 | Table | |
| loglevel | 0 | 0 | 5 | 3 | Table | |
| macvendor | 3 | 0 | 5 | 33198 | Table | |
| meta | 0 | 0 | 2 | 8 | Table | |
| normalized_vendor | 0 | 0 | 2 | 9 | Table | |
| notificationpolicy | 1 | 0 | 10 | 36 | Table | |
| notificationsubscription | 0 | 3 | 9 | 31 | Table | |
| organization | 3 | 0 | 3 | 1 | Table | |
| permission | 0 | 0 | 2 | 8 | Table | |
| role | 2 | 1 | 3 | 4 | Table | |
| role_permission | 0 | 0 | 2 | 8 | Table | |
| session | 0 | 1 | 8 | 3 | Table | |
| spectre_timezone | 0 | 0 | 1 | 0 | View | View that gives server timezone. This view is created so that we can use it as external table from x15 side as there is no function in x15 to retrieve server timezone. |
| system | 2 | 0 | 7 | 1 | Table | Data about every Spectre system that is connected to this system is recorded. There is only one entry per system, no matter what the system does. |
| user | 12 | 0 | 7 | 4 | Table | |
| user_apikey | 0 | 1 | 3 | 0 | Table | |
| user_certificate | 0 | 1 | 3 | 0 | Table | |
| user_role | 0 | 2 | 2 | 4 | Table | |
| zone | 38 | 1 | 5 | 1 | Table |