seller_nudge

✎ View and edit SQL

This data as json

0 records

CREATE TABLE seller_nudge (
    nudge_id            INTEGER PRIMARY KEY AUTOINCREMENT,
    seller_id           INTEGER NOT NULL REFERENCES seller(seller_id),
    conversation_id     INTEGER NOT NULL REFERENCES conversation(conversation_id),
    nudge_type          TEXT NOT NULL,
    priority            INTEGER NOT NULL DEFAULT 1,
    summary             TEXT NOT NULL DEFAULT '',
    suggested_action    TEXT NOT NULL DEFAULT '',
    dismissed           INTEGER NOT NULL DEFAULT 0,
    dismissed_at        TEXT,
    responded_at        TEXT,
    sent_at             TEXT,
    created_at          TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    expires_at          TEXT,
    CHECK (nudge_type IN ('hot_lead', 'unanswered_query', 'new_conversation', 'followup_24h',
                          'followup_72h', 'warm_lead', 'oos_alert', 'daily_summary')),
    CHECK (priority >= 0 AND priority <= 3),
    CHECK (dismissed IN (0, 1))
);
CREATE INDEX idx_seller_nudge_undismissed ON seller_nudge(seller_id, dismissed, priority DESC);
CREATE INDEX idx_seller_nudge_conversation ON seller_nudge(conversation_id);