detection_signals

5,154 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE detection_signals (
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    fired_at        TEXT NOT NULL,
    rule_name       TEXT NOT NULL,
    severity        TEXT NOT NULL,        -- 'critical' | 'warning' | 'info'
    store           TEXT,                 -- 'centralvapors' | 'wholesale' | NULL
    summary         TEXT NOT NULL,        -- one-line for dashboard display
    payload_json    TEXT NOT NULL,        -- rule-specific context
    related_event_ids TEXT,               -- JSON array of triggering event IDs
    dedupe_key      TEXT NOT NULL,        -- (rule_name, dedupe_key) is UNIQUE
    acknowledged_at TEXT,
    acknowledged_by TEXT,
    UNIQUE(rule_name, dedupe_key)
);
CREATE INDEX idx_detection_signals_fired
    ON detection_signals(fired_at DESC);
CREATE INDEX idx_detection_signals_unack
    ON detection_signals(acknowledged_at, fired_at DESC)
    WHERE acknowledged_at IS NULL;