TABLES
12
VIEWS
0
COLUMNS
124
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 | 14 | Table | |
| event_all | 0 | 0 | 8 | 3164 | Table | |
| event_daily_1 | 0 | 0 | 8 | 1770 | Table | |
| event_weekly_1 | 0 | 0 | 8 | 516 | Table | |
| event_weekly_2 | 0 | 0 | 8 | 864 | Table | |
| notification | 0 | 0 | 13 | 643 | Table | |
| notification_all | 0 | 1 | 13 | 31527 | Table | |
| notification_daily_1 | 0 | 0 | 13 | 2396 | Table | |
| notification_daily_2 | 0 | 0 | 13 | 4 | Table | |
| notification_weekly_1 | 0 | 0 | 13 | 15609 | Table | |
| notification_weekly_2 | 0 | 0 | 13 | 12875 | Table |