CREATE TABLE "conversations" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
chatbot_id INTEGER NOT NULL,
channel TEXT NOT NULL DEFAULT 'whatsapp',
user_id TEXT NOT NULL,
instance_id INTEGER,
conversation_name TEXT,
is_dev_mode INTEGER DEFAULT 0,
bot_paused INTEGER DEFAULT 0,
bot_paused_at TEXT,
started_at TEXT NOT NULL,
last_message_at TEXT NOT NULL,
message_count INTEGER DEFAULT 0,
unread_count INTEGER DEFAULT 0,
max_follow_ups INTEGER,
status TEXT DEFAULT 'open',
tags TEXT,
profile_picture_url TEXT,
contact_name TEXT,
is_online INTEGER DEFAULT 0,
last_seen TEXT,
is_group INTEGER DEFAULT 0,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
FOREIGN KEY (instance_id) REFERENCES evolution_instances(id) ON DELETE SET NULL,
UNIQUE(chatbot_id, channel, user_id, is_dev_mode)
)