Mensagens

2 rows where conversation_id = 2 sorted by created_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date)

message_id conversation_id sender_type sender_id telegram_message_id content content_type metadata intent_label created_at ▲
6 2 2 consumer_agent 0 0 Oi! Tudo bem com você? 😊 Eu sou a assistente de vendas aqui do nosso negócio. Estou aqui pra te ajudar com o que você precisar — seja pra conhecer nossos produtos, ver preços, calcular parcelamento o… text {}   2026-06-16T23:47:34Z
5 2 2 customer 208566864 15 Oi text {}   2026-06-16T23:47:28Z

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE message (
    message_id            INTEGER PRIMARY KEY AUTOINCREMENT,
    conversation_id       INTEGER NOT NULL REFERENCES conversation(conversation_id) ON DELETE CASCADE,
    sender_type           TEXT NOT NULL,
    sender_id             INTEGER NOT NULL,
    telegram_message_id   INTEGER NOT NULL,
    content               TEXT NOT NULL,
    content_type          TEXT NOT NULL DEFAULT 'text',
    metadata              TEXT NOT NULL DEFAULT '{}',
    intent_label          TEXT,
    created_at            TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    CHECK (sender_type IN ('customer', 'consumer_agent', 'seller', 'seller_agent')),
    CHECK (content_type IN ('text', 'photo', 'document', 'location', 'contact'))
);
CREATE INDEX idx_message_conversation_id ON message(conversation_id);
CREATE INDEX idx_message_created_at ON message(created_at);