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": 12557, "message_id": "2A60190AE7E2DF3429F4", "sender": "user", "message_type": "text", "content": "Bonsoir", "created_at": "2026-04-07T19:11:41.771817", "media_url": null, "media_mime_type": null}, {"id": 12558, "message_id": "bot_2A60190AE7E2DF3429F4_3730", "sender": "bot", "message_type": "text", "content": "Bonsoir 😊 Comment puis-je vous aider aujourd'hui au Centre Dentaire Dr DINANI Hicham ?", "created_at": "2026-04-07T19:11:54.131481", "media_url": null, "media_mime_type": null}, {"id": 15161, "message_id": "2A9C964F9156263C4971", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم، عافاك بغيت ناخد شي رانديفو.", "created_at": "2026-04-13T20:28:32.383408", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/3897/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15162, "message_id": "bot_2A9C964F9156263C4971_8815", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله 😊 باش نحجز ليك موعد، خاصّني غير الإسم الكامل ديالك ونوع العلاج اللي محتاج. واش تقدر تكتبهوم ليا؟", "created_at": "2026-04-13T20:28:48.417010", "media_url": null, "media_mime_type": null}, {"id": 15163, "message_id": "2A8DA803FD15077E4909", "sender": "user", "message_type": "voice", "content": "[Voice message] هذا هو تفريغ المقطع الصوتي:\n\n**بالعربية:**\n\"اسم ديالي هو محمد أمين.\"\n\n**باللاتينية:**\n\"Ism dyali houwa Mohammed Amine.\"", "created_at": "2026-04-13T20:29:15.958835", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/3898/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15164, "message_id": "bot_2A8DA803FD15077E4909_3432", "sender": "bot", "message_type": "text", "content": "شكرا محمد أمين 😊 باش نكملو الحجز، واش تقدر تقولي نوع العلاج اللي محتاج والوقت اللي يناسبك؟", "created_at": "2026-04-13T20:29:31.373005", "media_url": null, "media_mime_type": null}, {"id": 17033, "message_id": "2A99832AE6DB0377C181", "sender": "user", "message_type": "text", "content": ".", "created_at": "2026-04-17T01:55:23.342400", "media_url": null, "media_mime_type": null}, {"id": 17034, "message_id": "bot_2A99832AE6DB0377C181_2138", "sender": "bot", "message_type": "text", "content": "كنعتدر، الرسالة ما كانتش واضحة. واش ممكن توضح ليا شنو محتاج بالضبط أو الوقت اللي مناسبك للرانديفو؟", "created_at": "2026-04-17T01:55:38.252315", "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 1276 in training_review_items