Mensagens

4 rows where conversation_id = 1 sorted by created_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sender_type, sender_id, telegram_message_id, created_at, created_at (date)

message_id conversation_id sender_type sender_id telegram_message_id content content_type metadata intent_label created_at ▲
3 1 1 customer 208566864 7 oi novamente text {}   2026-06-15T19:04:44Z
4 1 1 consumer_agent 0 0 Oi de novo! 😄 Eu sou a assistente virtual da loja — tô aqui pra te ajudar com tudo que precisar! Se quiser saber sobre produtos, preços, ver se tem algo no estoque, ou calcular parcelamento no cartão… text {}   2026-06-15T19:04:44Z
1 1 1 customer 208566864 4 quem é voce? text {}   2026-06-14T05:50:37Z
2 1 1 consumer_agent 0 0 [LLM Error: Error code: 400 - {'error': {'message': 'Failed to deserialize the JSON body into the target type: tools[0]: missing field `type` at line 1 column 1403', 'type': 'invalid_request_error', '… text {}   2026-06-14T05:50:37Z

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);