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": 32223, "message_id": "bot_AC077FFD9ED8F6EE02D827899B4862F9_7650", "sender": "bot", "message_type": "text", "content": "غادي نبلغ الفريق الطبي ديالنا وغادي يتواصلوا معكوم في أقرب وقت إن شاء الله 🙏🏻", "created_at": "2026-05-19T11:26:16.308819", "media_url": null, "media_mime_type": null}, {"id": 32224, "message_id": "AC81168A5A13D1CDB8B39F71F4E18586", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (Arabic script):\n\n**\"إيه أختي، بالنسبة لينا حنا ديجا واحد لافامي تصايبو عندكم في رياض صولتي، هما نيت اللي عطاونا النمرة صراحة وشكروا لينا الطبيب.\"**\n\n---\n\n**Transcription in Latin script:**\n\"Iyeh a khti, bnissba lihna deja wahed l'famille tsaybou andkoum f Riad Soulti, huma nit li ataouna l'nemra saraha w chekrou lina tbib.\"", "created_at": "2026-05-19T11:26:49.722797", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/9285/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 32225, "message_id": "bot_AC81168A5A13D1CDB8B39F71F4E18586_1129", "sender": "bot", "message_type": "text", "content": "شكراً بزاف على الثقة والكلام الزوين ديالكوم! الفريق غادي يتواصلوا معكوم بهاد الموضوع إن شاء الله 🙏🏻", "created_at": "2026-05-19T11:27:07.792788", "media_url": null, "media_mime_type": null}, {"id": 37363, "message_id": "ACC6126A5972E0C9E4794E21E47E120F", "sender": "user", "message_type": "text", "content": "Salam khtie", "created_at": "2026-06-01T10:24:01.756278", "media_url": null, "media_mime_type": null}, {"id": 37364, "message_id": "bot_ACC6126A5972E0C9E4794E21E47E120F_7660", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، مرحبا الله أودي! كيفاش نقدر نعاونكوم اليوم؟ 😊", "created_at": "2026-06-01T10:24:15.567868", "media_url": null, "media_mime_type": null}, {"id": 37365, "message_id": "AC3B24DD84054165BF812F5BD4E76513", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام، كيديرة لاباس؟ بغيت عفاك ناخد رونديفو.\n\n**Transcription in Latin script:**\nSalam, kidaera labas? Bghit afak nakhd rendez-vous.", "created_at": "2026-06-01T10:24:29.437188", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10431/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37366, "message_id": "ACB7231E5F41BE8AB293E40A7A40B5B0", "sender": "user", "message_type": "voice", "content": "[Voice message] صفت ليا عفاك النمرة ديالكم ديال الفيكس.", "created_at": "2026-06-01T10:24:38.038322", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10432/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37367, "message_id": "bot_ACB7231E5F41BE8AB293E40A7A40B5B0_8635", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 بكل سرور! باش نحجزو ليكوم موعد، ممكن تعطيني الإسم الكامل ديالكوم ونوع العلاج اللي محتاجين؟\n\nبالنسبة للنمرة ديال الفيكس ديال العيادة: 05 37 86 02 03.", "created_at": "2026-06-01T10:24:57.096521", "media_url": null, "media_mime_type": null}, {"id": 37394, "message_id": "ACA7ECA8A9D462B5AE2B5D229F48D705", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-01T10:50:07.733430", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10443/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37397, "message_id": "AC081077F9E70F545C31F48C562D36BC", "sender": "user", "message_type": "text", "content": "Safi khtie nachalh", "created_at": "2026-06-01T10:50:49.998296", "media_url": null, "media_mime_type": null}, {"id": 42655, "message_id": "ACC1FCC8CFB1CB61E36E13926BCB2EDA", "sender": "user", "message_type": "text", "content": "سلام ختي", "created_at": "2026-06-12T21:23:16.303829", "media_url": null, "media_mime_type": null}, {"id": 42656, "message_id": "bot_ACC1FCC8CFB1CB61E36E13926BCB2EDA_1051", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Dr DINANI Hicham وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-06-12T21:23:30.044545", "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 3482 in training_review_items