SQLite Web: app.db

id

Primary key. INTEGER

chatbot_id

INTEGER NOT NULL

conversation_id

INTEGER NOT NULL

bot_message_id

INTEGER NOT NULL

user_message_id

INTEGER

context_window_json

[{"id": 7803, "message_id": "2A0E0BCFA271949A96DB", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-27T22:45:37.537093", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/1636/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7804, "message_id": "2A2AF189442E80737A71", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-27T22:45:37.720187", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/1637/download", "media_mime_type": "image/jpeg"}, {"id": 7805, "message_id": "2A66A7516A440094E967", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-27T22:45:38.049446", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/1638/download", "media_mime_type": "image/jpeg"}, {"id": 7806, "message_id": "2A29FB1A9C27AA832136", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-27T22:45:38.160481", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/1639/download", "media_mime_type": "image/jpeg"}, {"id": 7807, "message_id": "2A71654A3ABA616A8E38", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-27T22:45:38.387804", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/1640/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15233, "message_id": "meta_1131050983415192_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQUY1Q0I0OEU2ODNDMDZCMDUwMQA=", "sender": "user", "message_type": "text", "content": "Hi", "created_at": "2026-04-14T00:52:17.570337", "media_url": null, "media_mime_type": null}, {"id": 15234, "message_id": "meta_1131050983415192_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTREN0U3MTQ5QjMxNzRBOThCOAA=", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**فين أخويا هاني؟ مزيان؟ كلشي مزيان؟**\n**الحمد لله، الحمد لله، الحمد لله، كلشي بخير.**\n**أنت كولي يا خويا كي داير؟ واش راك مزيان ولا لا؟**\n**أنا بغيتك تكون مزيان.**", "created_at": "2026-04-14T00:53:44.959258", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/3924/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15235, "message_id": "bot_meta_1131050983415192_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTREN0U3MTQ5QjMxNzRBOThCOAA=_4399", "sender": "bot", "message_type": "text", "content": "بارك الله فيك، نتوما بخير؟ 😊 كيفاش نقدر نعاونك اليوم؟", "created_at": "2026-04-14T00:54:09.130635", "media_url": null, "media_mime_type": null}, {"id": 15236, "message_id": "meta_1131050983415192_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQURDNUIxQjhEMzJFQUU5OEQyNAA=", "sender": "user", "message_type": "text", "content": "Haniliya", "created_at": "2026-04-14T00:56:37.786344", "media_url": null, "media_mime_type": null}, {"id": 15237, "message_id": "bot_meta_1131050983415192_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQURDNUIxQjhEMzJFQUU5OEQyNAA=_4602", "sender": "bot", "message_type": "text", "content": "كنعتدر، مفهمتش الرسالة بالضبط. واش تقدر توضح ليا شنو قصدك أو كيفاش نقدر نعاونك؟", "created_at": "2026-04-14T00:56:48.531588", "media_url": null, "media_mime_type": null}, {"id": 17690, "message_id": "meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTk0QUFCMkY2NTE2RUI3QThBQQA=", "sender": "user", "message_type": "text", "content": "Slm", "created_at": "2026-04-23T09:51:29.785228", "media_url": null, "media_mime_type": null}, {"id": 17691, "message_id": "bot_meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTk0QUFCMkY2NTE2RUI3QThBQQA=_7638", "sender": "bot", "message_type": "text", "content": "وعليكم السلام 😊 كيفاش نقدر نعاونك اليوم؟", "created_at": "2026-04-23T09:51:41.165171", "media_url": null, "media_mime_type": null}]

TEXT NOT NULL

bot_answer

TEXT NOT NULL

label

TEXT

corrected_answer

TEXT

reviewed_by

INTEGER

reviewed_at

TEXT

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

updated_at

TEXT

synced_to_examples

INTEGER NOT NULL (default 0

synced_at

TEXT

expected_answer

TEXT

steps_of_thinking

TEXT

tool_called

TEXT

app.db — training_review_items

Update row 1363 in training_review_items