notifications constant

String const notifications

Durable notification delivery queue + inbox. payload is the canonical AtNotification JSON; the other columns are indexed extracts for the three query shapes (since-time monitor scans, startup re-enqueue of queued, expiry sweep).

Implementation

static const String notifications = '''
CREATE TABLE IF NOT EXISTS notifications (
id                    TEXT PRIMARY KEY NOT NULL,
payload               TEXT NOT NULL,
notification_datetime INTEGER NOT NULL,
type                  TEXT NOT NULL,
status                TEXT NOT NULL,
expires_at            INTEGER
) WITHOUT ROWID;
''';