Clientes

1 row sorted by last_seen

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_seen (date), last_seen (date), created_at (date), updated_at (date)

customer_id telegram_id phone full_name username first_seen last_seen ▼ total_conversations lifetime_value_cents tags metadata created_at updated_at
1 208566864   Patryck   2026-06-14T05:50:28Z 2026-06-23T04:25:54Z 0 0 [] {} 2026-06-14T05:50:28Z 2026-06-14T05:50:28Z

Advanced export

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

CSV options: 

CREATE TABLE customer (
    customer_id             INTEGER PRIMARY KEY AUTOINCREMENT,
    telegram_id             INTEGER NOT NULL UNIQUE,
    phone                   TEXT DEFAULT NULL,
    full_name               TEXT NOT NULL DEFAULT '',
    username                TEXT DEFAULT NULL,
    first_seen              TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    last_seen               TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    total_conversations     INTEGER NOT NULL DEFAULT 0,
    lifetime_value_cents    INTEGER NOT NULL DEFAULT 0,
    tags                    TEXT NOT NULL DEFAULT '[]',
    metadata                TEXT NOT NULL DEFAULT '{}',
    created_at              TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    updated_at              TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now'))
);
CREATE INDEX idx_customer_telegram_id ON customer(telegram_id);
CREATE INDEX idx_customer_last_seen ON customer(last_seen);