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": 27838, "message_id": "A506EA15F635EB62813E17722E4A32C3", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-05-12T15:02:06.933610", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/8052/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 28745, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjQ0MzMxOTkyFQIAERggQTU3REZDQjdGNUMzQzQ3RTAxNjhGQzM3RTFEQTFGODQA", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-05-13T16:45:26.311236", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/8334/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 28747, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjQ0MzMxOTkyFQIAEhgUMkFEOUVEMUUyRjM0MDI4NzI3ODgA", "sender": "user", "message_type": "text", "content": "Sff", "created_at": "2026-05-13T16:46:00.262317", "media_url": null, "media_mime_type": null}, {"id": 31475, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjQ0MzMxOTkyFQIAERggQTUwRjk0MDU4MzJENEY4NUY0NDQyQUQzNjg0NkY1ODgA", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-05-18T11:45:44.994869", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9082/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 31476, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjQ0MzMxOTkyFQIAEhgUMkFFQ0Q0ODVDMzhBNTU4NzFEMDEA", "sender": "user", "message_type": "text", "content": "Sf wakha", "created_at": "2026-05-18T11:49:44.241781", "media_url": null, "media_mime_type": null}, {"id": 32835, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjQ0MzMxOTkyFQIAERggQTUxMkU0ODVCMkVGQ0I3QzlCQjM2NDIyRDBFNEIzM0IA", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-05-20T12:02:07.869707", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9443/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 32838, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjQ0MzMxOTkyFQIAEhgUMkEwRTE1OEQzNUJENEFGOEM4MDYA", "sender": "user", "message_type": "text", "content": "Sff", "created_at": "2026-05-20T12:05:01.066459", "media_url": null, "media_mime_type": null}, {"id": 38239, "message_id": "2A26F832F0A08378561E", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using both Arabic and Latin scripts):\n\n### **Arabic Script:**\nالسلام عليكم شيماء، كيدايرة لاباس مزيان بخير؟ شوف شيماء الـ **rendez-vous** ديال غدا صافي راه **annulé**، مانجيش غدا.\n\n### **Latin Script:**\n\"Salamo alaykom Chaimae, kidayra labas mezian bkhir? Chouf Chaimae, **rendez-vous** dyal ghedda safi rah **annulé**, mangich ghedda.\"\n\n***\n\n**Breakdown of terms used:**\n*   **Rendez-vous:** French for \"appointment.\"\n*   **Annulé:** French for \"cancelled.\"\n*   **Ghedda:** Darija for \"tomorrow.\"\n*   **Mangich:** Darija for \"I won't come.\"", "created_at": "2026-06-02T21:45:11.075205", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10662/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 38243, "message_id": "bot_2A26F832F0A08378561E_5604", "sender": "bot", "message_type": "text", "content": "واخا Chaimae، بلغنا الفريق بطلب الإلغاء ديالك وغادي يتواصلوا معاك إن شاء الله إذا احتاجو شي توضيح.\n\nيلا بغيتي تحجزي موعد جديد ولا عندك أي سؤال، راني هنا نعاونك.", "created_at": "2026-06-02T21:45:30.739928", "media_url": null, "media_mime_type": null}, {"id": 38244, "message_id": "A50A08D385B35B00A1BA22933FA765B4", "sender": "bot", "message_type": "text", "content": "<reply_to>[Audio Message]</reply_to> Ok", "created_at": "2026-06-02T21:45:48.222440", "media_url": null, "media_mime_type": null}, {"id": 40617, "message_id": "2A87EF21F1D19C5D21EB", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic Script (Darija):**\n\"السلام عليكم شيماء، كي سيتي مزيانة؟ بخير؟ شيماء بغيت نشبر رونديفو نهار الأربعاء ف الصباح.\"\n\n**Latin Script (Transliteration):**\n\"Salam o alaykoum Chaymae, ki sitti meziana? Bikher? Chaymae bghit nchber un rendez-vous nhar l’arba3 f sbah.\"\n\n**Translation (for context):**\n\"Peace be upon you Chaymae, how are you? Good? Fine? Chaymae, I want to take/book an appointment for Wednesday morning.\"", "created_at": "2026-06-08T21:40:28.023281", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11283/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40619, "message_id": "bot_2A87EF21F1D19C5D21EB_3135", "sender": "bot", "message_type": "text", "content": "مرحبا Chaimae 😊 باش نسجل الطلب ديالك كامل، ممكن تقولي ليا شنو السبب ديال هاد الموعد أو العلاج اللي محتاجة؟\n\nدير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-06-08T21:40:46.845446", "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 3300 in training_review_items