TABLES
7
VIEWS
0
COLUMNS
33
Constraints
4
Anomalies
2
Routines
0
Database Properties
Database Type: PostgreSQL - 9.6.10
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| read_errors | 0 | 3 | 6 | 0 | Table | errors that are detected during new reports collection |
| states | 1 | 0 | 3 | 4 | Table | states for each row stored in reported table |
| reported | 0 | 3 | 10 | 5613 | Table | notifications reported to user or skipped due to some conditions |
| migration_info | 0 | 0 | 1 | 1 | Table | information about the latest DB schema and migration status |
| new_reports | 3 | 0 | 6 | 0 | Table | new reports consumed from Kafka topic and stored to database in shrunk format |
| notification_types | 1 | 0 | 4 | 2 | Table | list of all notification types used by Notification service |
| event_targets | 1 | 0 | 3 | 2 | Table | specification of all event targets currently supported |