home / sales_assistant

Eventos do Agente

0 rows where seller_id = 0 sorted by created_at descending

✎ View and edit SQL

This data as json

0 records

CREATE TABLE agent_event (
    event_id            INTEGER PRIMARY KEY AUTOINCREMENT,
    conversation_id     INTEGER NOT NULL REFERENCES conversation(conversation_id),
    seller_id           INTEGER NOT NULL REFERENCES seller(seller_id),
    agent_type          TEXT NOT NULL,
    event_type          TEXT NOT NULL,
    payload             TEXT NOT NULL DEFAULT '{}',
    created_at          TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    CHECK (agent_type IN ('consumer', 'seller')),
    CHECK (event_type IN ('intent_detected', 'escalation', 'nudge_created', 'proposal_drafted',
                          'proposal_sent', 'proposal_responded', 'order_created', 'handoff'))
);
CREATE INDEX idx_agent_event_conversation ON agent_event(conversation_id);
CREATE INDEX idx_agent_event_seller ON agent_event(seller_id);
Powered by Datasette · Queries took 1.2ms