Conversas

0 rows where seller_id = 3 sorted by last_activity descending

✎ View and edit SQL

This data as json

0 records

CREATE TABLE conversation (
    conversation_id     INTEGER PRIMARY KEY AUTOINCREMENT,
    seller_id           INTEGER NOT NULL REFERENCES seller(seller_id) ON DELETE CASCADE,
    customer_id         INTEGER NOT NULL REFERENCES customer(customer_id) ON DELETE CASCADE,
    status              TEXT NOT NULL DEFAULT 'active',
    state               TEXT NOT NULL DEFAULT 'greeting',
    escalation_level    INTEGER NOT NULL DEFAULT 0,
    source_channel      TEXT NOT NULL DEFAULT 'telegram',
    agent_type_active   TEXT NOT NULL DEFAULT 'consumer',
    context_summary     TEXT,
    metadata            TEXT NOT NULL DEFAULT '{}',
    started_at          TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    last_activity       TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    closed_at           TEXT,
    CHECK (status IN ('active', 'closed', 'abandoned')),
    CHECK (escalation_level IN (0, 1, 2)),
    CHECK (agent_type_active IN ('consumer', 'seller'))
);
CREATE INDEX idx_conversation_seller_customer ON conversation(seller_id, customer_id);
CREATE INDEX idx_conversation_status ON conversation(status);
CREATE INDEX idx_conversation_last_activity ON conversation(last_activity);