TABLES
6
VIEWS
0
COLUMNS
61
Constraints
2
Database Properties
Database Type: PostgreSQL - 9.6.6
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| acknowledgednotification | 0 | 1 | 6 | 0 | Table | This table keeps track of notifications for a particular device_id(s) acknowledged by a user. If there are multiple maps for a user, these devices/nodes will be marked acknowledged across all the maps. If no map exists for a user, this info will be persisted in this table and sent back to UI on getMapNodes. It is parent table that is partitioned over zone schema |
| event | 0 | 0 | 8 | 8 | Table | |
| event_all | 0 | 0 | 8 | 8 | Table | |
| notification | 0 | 0 | 13 | 0 | Table | |
| notification_all | 0 | 1 | 13 | 0 | Table | |
| notification_daily_1 | 0 | 0 | 13 | 0 | Table |