customer_persona

0 rows where customer_id = 1

✎ View and edit SQL

This data as json

0 records

CREATE TABLE customer_persona (
    persona_id      INTEGER PRIMARY KEY AUTOINCREMENT,
    customer_id     INTEGER NOT NULL UNIQUE REFERENCES customer(customer_id) ON DELETE CASCADE,
    tone_preference TEXT NOT NULL DEFAULT '',     -- 'formal', 'casual', 'direto', ''
    preferred_name  TEXT NOT NULL DEFAULT '',     -- How they like to be called
    channel_pref    TEXT NOT NULL DEFAULT '',     -- Preferred communication channel/style
    recurring_topic TEXT NOT NULL DEFAULT '',     -- What they always ask about (produtos, preços, agendamento...)
    objection_style TEXT NOT NULL DEFAULT '',     -- 'preco', 'prazo', 'qualidade', ''
    callback_context TEXT NOT NULL DEFAULT '',    -- Hook from last conversation (max 300 chars)
    summary_snippet TEXT NOT NULL DEFAULT '',     -- Auto-generated 1-sentence profile summary
    last_updated    TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    created_at      TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now'))
);
CREATE INDEX idx_customer_persona_customer ON customer_persona(customer_id);