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": 30157, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjI4OTA5MTgzFQIAEhgUM0FBQzJGQzgzRUI0NjU3RTM1Q0MA", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-05-15T15:52:11.760800", "media_url": null, "media_mime_type": null}, {"id": 30493, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjI4OTA5MTgzFQIAERggQTU0OTdEMjA0NzlFQTg2MjhCM0I5MUQyNjZFN0M4OEUA", "sender": "bot", "message_type": "text", "content": "Rym", "created_at": "2026-05-16T08:44:36.181847", "media_url": null, "media_mime_type": null}, {"id": 34167, "message_id": "3EB01C1415293EEA08A23C", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HADDIOUI Rym *\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 23 mai 2026* à *10: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لديكم موعد مع ** يوم *السبت 23 ماي 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-22T16:08:54.805510", "media_url": null, "media_mime_type": null}, {"id": 34477, "message_id": "3EB049EFB4EE5FA0E04431", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *1000,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-11600,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-05-23T09:14:12.228050", "media_url": null, "media_mime_type": null}, {"id": 34478, "message_id": "3EB00A6EBDA17FBF6F94F8", "sender": "bot", "message_type": "document", "content": "2026052310135346.pdf", "created_at": "2026-05-23T09:14:38.428053", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9816/download", "media_mime_type": "application/pdf"}, {"id": 38908, "message_id": "3AAF91967CC498BCE5E6", "sender": "user", "message_type": "text", "content": "السلام عليكم", "created_at": "2026-06-04T14:09:37.043331", "media_url": null, "media_mime_type": null}, {"id": 38909, "message_id": "bot_3AAF91967CC498BCE5E6_4686", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Tanger Bay وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-06-04T14:09:51.144436", "media_url": null, "media_mime_type": null}, {"id": 38910, "message_id": "3AE121272EBD6CAB3985", "sender": "user", "message_type": "text", "content": "Yak 3andi rendez vous had sebt inchaallah", "created_at": "2026-06-04T14:10:07.337924", "media_url": null, "media_mime_type": null}, {"id": 38911, "message_id": "bot_3AE121272EBD6CAB3985_8939", "sender": "bot", "message_type": "text", "content": "نعم، عندكِ rendez-vous إن شاء الله نهار السبت 25 أبريل 2026 مع الدكتور ALAMI MUSTAPHA على الساعة 10:30 صباحاً chez Tanger Bay Dental Center.\n\nمرحبا بيكِ وأي سؤال أنا هنا! 😊", "created_at": "2026-06-04T14:10:18.874026", "media_url": null, "media_mime_type": null}, {"id": 38915, "message_id": "A56C4583BC6DAF87B2658BAB2E76F536", "sender": "bot", "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\"Salam alikoum, kidayra labas alik? Maandekch had s-sebt, s-sebt li mourah, ta ila majitich s-sebt lakhor, aandek s-sebt li maji machi s-sebt hada, aandek s-sebt li maji.\"", "created_at": "2026-06-04T14:22:12.070079", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10822/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39594, "message_id": "3A35053FDE1040FEB794", "sender": "user", "message_type": "text", "content": "Ook inchaallah", "created_at": "2026-06-05T20:29:47.428971", "media_url": null, "media_mime_type": null}, {"id": 39595, "message_id": "bot_3A35053FDE1040FEB794_9843", "sender": "bot", "message_type": "text", "content": "شكراً رِيم على التأكيد 😊 إذن الموعد ديالك ماشي هاد السبت، ولكن السبت اللي جاي من بعد (25 أبريل 2026) مع الدكتور ALAMI MUSTAPHA على الساعة 10:30 صباحاً.\n\nيلا احتجتي شي توضيح آخر أنا هنا!", "created_at": "2026-06-05T20:30:07.066091", "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 3207 in training_review_items