TABLES
28
VIEWS
1
COLUMNS
155
Constraints
24
Database Properties
Database Type: PostgreSQL - 9.6.6
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| attribute | 1 | 1 | 4 | 42640 | Table | |
| attribute_cidr | 0 | 2 | 5 | 480049 | Table | |
| attributetype | 14 | 0 | 4 | 39 | Table | |
| collector | 32 | 4 | 10 | 5 | 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 | |
| feed | 1 | 0 | 15 | 19 | Table | |
| feed_config | 0 | 1 | 4 | 30 | Table | |
| interface | 3 | 1 | 15 | 1 | Table | |
| loglevel | 0 | 0 | 5 | 3 | Table | |
| macvendor | 5 | 0 | 5 | 30381 | Table | |
| meta | 0 | 0 | 2 | 10 | 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 | 1 | 1 | 3 | 4 | Table | |
| role_permission | 0 | 0 | 2 | 8 | Table | |
| session | 0 | 1 | 8 | 28 | 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 | 16 | 0 | 6 | 4 | Table | |
| user_apikey | 0 | 1 | 3 | 0 | Table | |
| user_certificate | 0 | 1 | 3 | 0 | Table | |
| user_role | 0 | 2 | 2 | 4 | Table | |
| zone | 36 | 1 | 5 | 3 | Table |