TABLES
6
VIEWS
0
COLUMNS
61
Constraints
2
Database Properties
Database Type: PostgreSQL - 13.2
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 | 13 | Table | |
event_all | 0 | 0 | 8 | 13 | Table | |
notification | 0 | 0 | 13 | 10 | Table | |
notification_all | 0 | 1 | 13 | 10 | Table | |
notification_daily_1 | 0 | 0 | 13 | 0 | Table |