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": 5592, "message_id": "AC6A79DD4BDE6DCC40957F9F93C32CD6", "sender": "user", "message_type": "text", "content": "Hbiba ana mrida  b l agrippe  bla manji .yak", "created_at": "2026-03-17T08:40:45.817234", "media_url": null, "media_mime_type": null}, {"id": 5593, "message_id": "bot_AC6A79DD4BDE6DCC40957F9F93C32CD6_2306", "sender": "bot", "message_type": "text", "content": "سلامتك الله يشافيك. إذا كنتِ مريضة وماقدرتيش تجي للموعد، يمكن لك تتاصلي بينا باش ننسقو موعد آخر يناسبك. واش نبلغ الفريق باش يتاصلو بيك؟", "created_at": "2026-03-17T08:40:57.247630", "media_url": null, "media_mime_type": null}, {"id": 5594, "message_id": "AC2863C272EB5D6078716448D13B0ACC", "sender": "user", "message_type": "text", "content": "لا شكرا انا جاية", "created_at": "2026-03-17T08:52:25.011067", "media_url": null, "media_mime_type": null}, {"id": 5595, "message_id": "bot_AC2863C272EB5D6078716448D13B0ACC_6162", "sender": "bot", "message_type": "text", "content": "مرحبا بك! نتمنى لك الشفاء العاجل. إذا احتجتي لأي مساعدة أخرى، راني هنا. 😊", "created_at": "2026-03-17T08:52:36.319686", "media_url": null, "media_mime_type": null}, {"id": 5597, "message_id": "AC398137210B4B4B90C26F08986D781E", "sender": "user", "message_type": "text", "content": "شكرا جزيلا الله يحفظكم", "created_at": "2026-03-17T08:53:18.965217", "media_url": null, "media_mime_type": null}, {"id": 5598, "message_id": "bot_AC398137210B4B4B90C26F08986D781E_3204", "sender": "bot", "message_type": "text", "content": "بارك الله فيك! الله يحفظك ويشافيك. إذا احتجتي أي حاجة، راني هنا. 😊", "created_at": "2026-03-17T08:53:29.505710", "media_url": null, "media_mime_type": null}, {"id": 6806, "message_id": "AC8D7337106DD8D42C7800209047F703", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-03-24T05:46:15.793859", "media_url": null, "media_mime_type": null}, {"id": 6807, "message_id": "ACDA1A70D19722AC4215FB4FBE9371C3", "sender": "user", "message_type": "text", "content": "عندي موعداليوم", "created_at": "2026-03-24T06:44:48.565700", "media_url": null, "media_mime_type": null}, {"id": 6808, "message_id": "ACFBAEE9D578EAA6E82BD60D5F2CF9AB", "sender": "user", "message_type": "text", "content": "شكرا", "created_at": "2026-03-24T06:44:59.661214", "media_url": null, "media_mime_type": null}, {"id": 6831, "message_id": "AC65E7198A08FE5B47D830316164895C", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using both Arabic and Latin scripts) to capture the mix of Darija and French loanwords:\n\n### Arabic Script\n\"السلام، كيدايرة لاباس عليك؟ بخير؟ الصحة مزيان؟ بالنسبة للرونديفو (rendez-vous) راه حتى للسيمانة الجاية. حتى للسيمانة الجاية مدام لطيفة. حنا راه ماخدامينش، غاندخلو حتى لنهار 30 إن شاء الله في الشهر. يعني راه عاطيك رونديفو (rendez-vous) على حساب الاثنين الماجي، الثلاث الماجي ولا ماعرفت الاثنين، ماعقلتش بالضبط. المهم راه غابيل (rappel) دالميساج غادي يوصلك. أما حنا راه ماخدامينش هاد السيمانة هادي حتى للسيمانة الجاية إن شاء الله.\"\n\n### Latin Script (Phonetic)\n\"Salam, ki dayra labas 3lik? Bikhir? S7a mzian? Bnessba l'rendez-vous rah 7ta l'simana ljaya. 7ta l'simana ljaya Madame Latifa. 7na rah ma khdaminnch, ghandkhlo 7ta l'nhar 30 inchallah f'shahr. Ya3ni rah 3atik rendez-vous 3la 7sab tnin lmaji, tlat lmaji wlla ma3reft tnin, ma 3qaltch b'debt. Lmouhim rah rappel d'message ghay wsslek. Ama 7na rah ma khdaminnch had simana hadi, 7ta l'simana ljaya inchallah.\"\n\n### English Translation (for context)\n\"Hello, how are you? Are you doing well? Is your health good? Regarding the appointment, it's not until next week. Until next week, Madame Latifa. We are not working; we will be back on the 30th of the month, God willing. So, I’ve given you an appointment for next Monday, or maybe next Tuesday—I don't remember exactly. Anyway, a message reminder will reach you. As for us, we aren't working this week, only next week, God willing.\"", "created_at": "2026-03-24T21:30:56.723759", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/1370/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8775, "message_id": "AC48CA044ED7CB13254AFA86DE9101D0", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-03-30T11:20:55.170037", "media_url": null, "media_mime_type": null}, {"id": 8776, "message_id": "bot_AC48CA044ED7CB13254AFA86DE9101D0_8789", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Je voulais vous informer que le cabinet est fermé cette semaine et rouvrira le 30 mars. Votre rendez-vous est prévu pour la semaine prochaine. Si vous avez des questions ou besoin d'aide, n'hésitez pas à me le faire savoir !", "created_at": "2026-03-30T11:21:19.001746", "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 456 in training_review_items