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": 49827, "message_id": "AC444E8B6B46E720B8109121C8250598", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-07-01T07:11:11.800670", "media_url": null, "media_mime_type": null}, {"id": 49828, "message_id": "bot_AC444E8B6B46E720B8109121C8250598_5519", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Dr DINANI Hicham وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-07-01T07:11:24.901074", "media_url": null, "media_mime_type": null}, {"id": 49829, "message_id": "ACE8DB2762075569DEA815B5A8F493F6", "sender": "user", "message_type": "voice", "content": "[Voice message] Here's the transcription in both Arabic and Latin scripts:\n\n**Arabic Script:**\n\"السلام عليكم، أنا ماما د عبد الله، عفاك بغيت ناخد رانديفو نهار التلات الجاي إن شاء الله، باش نكملو ليه داكشي اللي بقى.\"\n\n**Latin Script:**\n\"Assalamu alaykum, ana mama d'Abdullah, aafak bghit nakhod rendez-vous nhar tlat jay nchallah, bach nkemlo lih dakchi li bqa.\"", "created_at": "2026-07-01T07:11:36.079850", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/13943/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 49830, "message_id": "bot_ACE8DB2762075569DEA815B5A8F493F6_2049", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 شكراً على الرسالة. باش نسجلو الطلب ديال عبد الله، بغيت غير تأكدي ليا الإسم الكامل ديالو مكتوب هنا، وشنو نوع العلاج أو الخدمة اللي خاصو يكملها إن شاء الله؟", "created_at": "2026-07-01T07:11:53.727433", "media_url": null, "media_mime_type": null}, {"id": 49831, "message_id": "ACD491C5B2DCE06DDC974A636D53F25A", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"سميتو عبد الله مسلم، ممكن نقيو ليه سنانو، يعني باقي شي حاجة ما تنقاتش.\"\n\n**Latin Script:**\n\"Smito Abdullah Muslim, momkin nqiw lih snano, ya3ni baqi chi haja ma tnaqat-sh.\"\n\n**English Translation (for context):**\n\"His name is Abdullah Muslim, can we clean his teeth? I mean, there is still something that hasn't been cleaned yet.\"", "created_at": "2026-07-01T07:12:53.459496", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/13944/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 49833, "message_id": "bot_ACD491C5B2DCE06DDC974A636D53F25A_943", "sender": "bot", "message_type": "text", "content": "شكراً بزاف، سجلت الطلب ديالكوم لعبد الله مسلم لتنقية الأسنان نهار التلات الجاي. الفريق غادي يتواصلوا بيكوم باش يأكدو الموعد إن شاء الله 🙏🏻", "created_at": "2026-07-01T07:13:12.325807", "media_url": null, "media_mime_type": null}, {"id": 49834, "message_id": "AC78EDB31CB41BA8712DA6B07B009C98", "sender": "user", "message_type": "voice", "content": "[Voice message] The transcription of the audio is as follows:\n\n**Arabic Script:**\n\"ماشي عبد الله مسلم، عبد الله بوفلان.\"\n\n**Latin Script:**\n\"Machi Abdallah Moslem, Abdallah Boufoulane.\"\n\n**Translation (for context):**\n\"Not Abdallah Muslim, [it's] Abdallah Boufoulane (So-and-so).\"", "created_at": "2026-07-01T07:15:06.138830", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/13945/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 49836, "message_id": "bot_AC78EDB31CB41BA8712DA6B07B009C98_1572", "sender": "bot", "message_type": "text", "content": "شكراً بزاف على التصحيح، غادي نبلغ الفريق الطبي ديالنا بالاسم الصحيح عبد الله بوفلان وغادي يتواصلوا معكوم في أقرب وقت إن شاء الله 🙏🏻", "created_at": "2026-07-01T07:15:22.849640", "media_url": null, "media_mime_type": null}, {"id": 49837, "message_id": "AC1F7C5051E2721866FDAE915B0BF133", "sender": "user", "message_type": "text", "content": "شكرا🙂", "created_at": "2026-07-01T07:16:07.019510", "media_url": null, "media_mime_type": null}, {"id": 49838, "message_id": "bot_AC1F7C5051E2721866FDAE915B0BF133_6373", "sender": "bot", "message_type": "text", "content": "العفو، أي خدمة أخرى أنا رهن الإشارة ديالكوم! 😊", "created_at": "2026-07-01T07:16:20.937082", "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 4123 in training_review_items