Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('event.acknowledgednotification_id_seq'::regclass) |
|
|
unique identifier for the acknowledgednotification record |
|||
| notification_id | int4 | 10 | null |
|
|
Id of the notification that is acknowledged. |
||||
| zone_id | int4 | 10 | null |
|
|
Id of the zone in which the notification is acknowledged |
||||
| acknowledged | bool | 1 | √ | true |
|
|
Boolean indicating whether the notification is acknowledged or not. The way code works is that we would only see entry in this table where this flag is set to true. |
|||
| user_id | int4 | 10 | null |
|
|
Id of the user that acknowledged the notification. |
||||
| time | timestamp | 29,6 | √ | now() |
|
|
Timestamp when this record was inserted/updated. Timestamp is based on Spectre's configured timezone. |
Table contained 0 rows
Relationships
Close relationships within degrees of separation
