customer_session

✎ View and edit SQL

This data as json

0 records

CREATE TABLE customer_session (
    session_id          INTEGER PRIMARY KEY AUTOINCREMENT,
    customer_id         INTEGER NOT NULL REFERENCES customer(customer_id),
    conversation_id     INTEGER NOT NULL REFERENCES conversation(conversation_id),
    fsm_state           TEXT NOT NULL DEFAULT 'greeting',
    context_data        TEXT NOT NULL DEFAULT '{}',
    turn_count          INTEGER NOT NULL DEFAULT 0,
    last_llm_response   TEXT,
    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_session_conversation ON customer_session(conversation_id);