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": 32380, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjk1NjM3MDcxFQIAEhgUM0FFNUMzOEM5QjRDRjMyMEMwNjAA", "sender": "user", "message_type": "text", "content": "Bgheit neaml rendv Shhar 2 f 6", "created_at": "2026-05-19T13:40:03.178430", "media_url": null, "media_mime_type": null}, {"id": 32381, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjk1NjM3MDcxFQIAEhgUM0E5NzU1NThCNUY5NjU2NUFENkUA", "sender": "user", "message_type": "text", "content": "Mea 3", "created_at": "2026-05-19T13:40:10.536109", "media_url": null, "media_mime_type": null}, {"id": 32382, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjk1NjM3MDcxFQIAERggQTU1Q0MyOUZDNDdGQkRGNEJCQzk3Qjk4OTIxMjhBMjgA", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-05-19T13:40:40.158235", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9319/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 32384, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjk1NjM3MDcxFQIAEhgUM0FFQzA4NzZCQUM1NDdFQzA1MDgA", "sender": "user", "message_type": "text", "content": "Chaymae aourfat", "created_at": "2026-05-19T13:41:08.651860", "media_url": null, "media_mime_type": null}, {"id": 37642, "message_id": "3EB02F6D77BCE8C944D377", "sender": "bot", "message_type": "image", "content": "Salut *CHAIMAE Aourfat*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mardi 02 juin 2026*\r\n🕘 Heure : *15:30*\r\n📍 Adresse : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)\r\n📞 Pour toute question : 06 60 02 22 63\r\n✅ Merci de nous confirmer votre présence en répondant « OUI » à ce message\r\n\r\n⚠️ IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement considéré comme annulé automatiquement. \r\nMerci de votre compréhension.\r\n", "created_at": "2026-06-01T15:03:24.760488", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10533/download", "media_mime_type": "image/jpeg"}, {"id": 37722, "message_id": "3EB0E550F0359EB6ED8E66", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*CHAIMAE Aourfat*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mardi 02 juin 2026* à *15:30* .\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*CHAIMAE*\r\nلديكم موعد مع ** يوم *الثلاثاء 2 يونيو 2026* على الساعة *15:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-01T16:04:14.021865", "media_url": null, "media_mime_type": null}, {"id": 37741, "message_id": "3ADDBDDEAD063A383393", "sender": "user", "message_type": "text", "content": "Safe annule rendez-vous", "created_at": "2026-06-01T16:30:07.990607", "media_url": null, "media_mime_type": null}, {"id": 40784, "message_id": "3A93BEDE4828792CE79F", "sender": "user", "message_type": "text", "content": "Slm cv Bghet neaml rendez-vous", "created_at": "2026-06-09T12:21:28.436171", "media_url": null, "media_mime_type": null}, {"id": 40785, "message_id": "3A4FEE657DD03F743B0F", "sender": "user", "message_type": "text", "content": "Nhar khmess", "created_at": "2026-06-09T12:21:35.271077", "media_url": null, "media_mime_type": null}, {"id": 40786, "message_id": "bot_3A4FEE657DD03F743B0F_597", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 باش نسجلو الطلب ديالكوم، محتاجين غير الإسم الكامل ديالكوم وشنو العلاج أو المشكل اللي عندكوم بالضبط، حيث ذكرتي عندك مشكل فـ la gencive.\n\nواخا تكتب ليا الإسم الكامل ديالكوم؟", "created_at": "2026-06-09T12:21:49.776066", "media_url": null, "media_mime_type": null}, {"id": 40789, "message_id": "3A1C92AEA0ADC75791BC", "sender": "user", "message_type": "text", "content": "Chaymae aourfat", "created_at": "2026-06-09T12:22:14.174255", "media_url": null, "media_mime_type": null}, {"id": 40794, "message_id": "bot_3A1C92AEA0ADC75791BC_5581", "sender": "bot", "message_type": "text", "content": "وصل الطلب ديالك Chaymae، والفريق غادي يتواصل معاك باش يأكدو الموعد ديالك نهار الخميس إن شاء الله.\n\nدير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-06-09T12:22:30.306257", "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 3319 in training_review_items