18 lines
534 B
SQL
18 lines
534 B
SQL
-- VTM conversation states table
|
|
|
|
CREATE TABLE IF NOT EXISTS conversation_states (
|
|
session_id VARCHAR(255) PRIMARY KEY,
|
|
user_id UUID,
|
|
workflow VARCHAR(50),
|
|
step VARCHAR(50),
|
|
context JSONB,
|
|
created_at TIMESTAMP DEFAULT NOW(),
|
|
updated_at TIMESTAMP DEFAULT NOW(),
|
|
expires_at TIMESTAMP
|
|
);
|
|
|
|
CREATE INDEX idx_conversation_user ON conversation_states(user_id);
|
|
CREATE INDEX idx_conversation_workflow ON conversation_states(workflow);
|
|
CREATE INDEX idx_conversation_expires ON conversation_states(expires_at);
|
|
|