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": 45735, "message_id": "3EB085DEFD3B9390E51BFC", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ACHRAYH Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 26 juin 2026* à *15:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الجمعة 26 يونيو 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-19T16:05:39.727742", "media_url": null, "media_mime_type": null}, {"id": 47732, "message_id": "A5901E7BCFE904AB71123BCBA9706F06", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here's the transcription of the audio in Moroccan Darija:\n\n\"السلام عليكم محمد، كي نتينا مزيان؟ بخير؟ الصحة لاباس؟ محمد بغيت نقولك، تقدر تجي نهار الجمعة ف الصباح، حيت الدكتور ما غيكونش الجمعة ف العشية.\"", "created_at": "2026-06-24T11:32:33.144016", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13228/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47734, "message_id": "AC265C78B26A83243109BF40388F331C", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic script and Latin script (Darija):\n\n**Arabic Script:**\nأهلاً، كيف صْبحتي؟ لاباس عليك؟ مزيان؟ كولشي بخير؟ إيه، شمن ساعة ف الصباح مثلاً؟\n\n**Latin Script:**\nAhlan, kif sbehti? Labas 3lik? Mezyan? Kolchi bikhir? Eh, chmen sa3a f sbah matalan?", "created_at": "2026-06-24T11:35:10.461672", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13229/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47735, "message_id": "A5C56D0D0AF6B1243B6E860BE4370F60", "sender": "bot", "message_type": "voice", "content": "[Voice message] نهار الجمعة إن شاء الله مع الـ 11، مزيانة؟", "created_at": "2026-06-24T11:37:06.642309", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13230/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47736, "message_id": "ACA893F926D8044005FFBC9C270327CE", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure, here is the transcription of the audio:\n\n**Arabic script:**\n\"شوف، ونقدرو نأجلو الموعد نتاع نهار لرباع لي ماجي.\"\n\n**Latin script:**\n\"Shouf, o nqdrou n'ajjlou l-maw'id nta' nhar l-reb'a li maji.\"\n\n**English translation (for context):**\n\"Look, and we can postpone the appointment of next Wednesday.\"", "created_at": "2026-06-24T11:43:04.025771", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13231/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47737, "message_id": "3EB0B6A7250E9F90D2BC1D", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ACHRAYH Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 26 juin 2026* à *11:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الجمعة 26 يونيو 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-24T11:43:10.919080", "media_url": null, "media_mime_type": null}, {"id": 47739, "message_id": "AC4C90A7B58A493BB8113B91EA4F4021", "sender": "user", "message_type": "text", "content": "?", "created_at": "2026-06-24T11:55:15.910159", "media_url": null, "media_mime_type": null}, {"id": 48372, "message_id": "3EB0328CE469B3FAABB717", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ACHRAYH Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mercredi 01 juillet 2026* à *11:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الأربعاء 1 يوليوز 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-25T09:58:57.839098", "media_url": null, "media_mime_type": null}, {"id": 48447, "message_id": "AC78243AF85E71E615C2783FC60F5210", "sender": "user", "message_type": "text", "content": "Merci beaucoup", "created_at": "2026-06-25T12:28:41.532277", "media_url": null, "media_mime_type": null}, {"id": 48448, "message_id": "bot_AC78243AF85E71E615C2783FC60F5210_5526", "sender": "bot", "message_type": "text", "content": "Avec plaisir, à bientôt 😊", "created_at": "2026-06-25T12:29:14.385948", "media_url": null, "media_mime_type": null}, {"id": 48449, "message_id": "AC17895CA82C48299E75B377C9C24DD0", "sender": "user", "message_type": "text", "content": "🙏", "created_at": "2026-06-25T12:29:31.343872", "media_url": null, "media_mime_type": null}, {"id": 48450, "message_id": "bot_AC17895CA82C48299E75B377C9C24DD0_8782", "sender": "bot", "message_type": "text", "content": "Avec plaisir 🙏🏻", "created_at": "2026-06-25T12:29:43.037136", "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 4005 in training_review_items