Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
notification Table zone_id int4 10 √ null
notification Table time timestamp 29 √ now()
event Table delivered timestamp 29 √ null
event_all Table message text 2147483647 √ null
event Table message text 2147483647 √ null
event_all Table event_references _text 2147483647 √ null
notification_daily_1 Table notification_type text 2147483647 √ null
event_all Table type text 2147483647 √ null
notification Table delivered timestamp 29 √ null
acknowledgednotification Table notification_id int4 10 null

Id of the notification that is acknowledged.
notification_all Table notification_type text 2147483647 √ null
notification Table priority text 2147483647 √ null
notification Table type text 2147483647 √ null
acknowledgednotification Table time timestamp 29 √ now()

Timestamp when this record was inserted/updated. Timestamp is based on Spectre's configured timezone.
notification Table details _text 2147483647 √ null
notification_all Table id serial 10 √ nextval('event.notification_all_id_seq'::regclass)
notification Table message text 2147483647 √ null
notification_all Table time timestamp 29 √ now()
event_all Table time timestamp 29 √ now()
notification_daily_1 Table users _text 2147483647 √ null
notification_daily_1 Table details _text 2147483647 √ null
notification Table subscriptiontype text 2147483647 √ null
event Table type text 2147483647 √ null
event_all Table zone_id int4 10 √ null
notification_all Table zone_id int4 10 √ null
acknowledgednotification Table id serial 10 √ nextval('event.acknowledgednotification_id_seq'::regclass)

unique identifier for the acknowledgednotification record
notification_all Table details _text 2147483647 √ null
notification_all Table name text 2147483647 √ null
event Table event_references _text 2147483647 √ null
notification_all Table users _text 2147483647 √ null
event Table time timestamp 29 √ now()
notification_daily_1 Table priority text 2147483647 √ null
notification Table users _text 2147483647 √ null
notification_daily_1 Table event_references _text 2147483647 √ null
event_all Table delivered timestamp 29 √ null
event Table details _text 2147483647 √ null
notification_daily_1 Table zone_id int4 10 √ null
notification_all Table message text 2147483647 √ null
notification_all Table delivered timestamp 29 √ null
acknowledgednotification Table 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.
acknowledgednotification Table zone_id int4 10 null

Id of the zone in which the notification is acknowledged
event_all Table details _text 2147483647 √ null
notification_daily_1 Table message text 2147483647 √ null
notification Table id serial 10 √ nextval('event.notification_all_id_seq'::regclass)
notification_daily_1 Table time timestamp 29 √ now()
event Table zone_id int4 10 √ null
notification Table notification_type text 2147483647 √ null
notification_daily_1 Table subscriptiontype text 2147483647 √ null
notification_all Table priority text 2147483647 √ null
event Table id serial 10 √ nextval('event.event_all_id_seq'::regclass)
notification_daily_1 Table id serial 10 √ nextval('event.notification_all_id_seq'::regclass)
notification_all Table subscriptiontype text 2147483647 √ null
notification_daily_1 Table type text 2147483647 √ null
notification Table event_references _text 2147483647 √ null
notification_daily_1 Table delivered timestamp 29 √ null
notification_daily_1 Table name text 2147483647 √ null
notification_all Table type text 2147483647 √ null
notification Table name text 2147483647 √ null
acknowledgednotification Table user_id int4 10 null

Id of the user that acknowledged the notification.
notification_all Table event_references _text 2147483647 √ null
event_all Table id serial 10 √ nextval('event.event_all_id_seq'::regclass)