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": 37451, "message_id": "3A0B013DACDCC2446F6F", "sender": "user", "message_type": "voice", "content": "[Voice message] وعليكم السلام، لاباس الحمد لله، الدنيا مزيانة كلشي بخير، بالحق ما غنكونش، غنكون مسافر هاد التنين، غنكون ف طنجة غير نهار الخميس غنجي على حساب واحد الشهادة وصافي.", "created_at": "2026-06-01T11:16:30.744511", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10474/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37457, "message_id": "A5962AC23AAA1624A34C5870D9E0C5A0", "sender": "bot", "message_type": "voice", "content": "[Voice message] أه، صافي واخا، كون هاني، صافي أنا نعوض لك رونديفو.", "created_at": "2026-06-01T11:18:11.147636", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10477/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37461, "message_id": "3A7B96B6649AE6823B9C", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"صافي الله يرحم الوالدين، طنجة أصلاً عايرة لهاد شي والله العظيم. نهار الخميس مع الخمسة د العشية إن شاء الله نكون تما. صافي، وأصلاً الجمعة مسافر أنا في الصباح عاود.\"\n\n**Latin Script (Phonetic):**\n\"Safi, Allah irham l-walidin. Tanger aslan 3ayra l-hadchi wallah l-3adim. Nhar l-khamis m3a l-khamsa d l-3shiya inshallah nkun tmma. Safi, w aslan l-jam3a msafar ana f s-bah 3awed.\"\n\n**Translation (for context):**\n\"Okay, may God have mercy on your parents. Tangier is already known for/crowded with this stuff, I swear. Thursday at 5 PM, God willing, I'll be there. Okay, and anyway, on Friday I'm traveling in the morning as well.\"", "created_at": "2026-06-01T11:20:33.781445", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10479/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37467, "message_id": "3EB06F480E76C6D47FB59B", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABDELAOUI MOHAMED*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 04 juin 2026* à *17: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لديكم موعد مع ** يوم *الخميس 4 يونيو 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-01T11:23:55.576576", "media_url": null, "media_mime_type": null}, {"id": 38461, "message_id": "3EB0A2B33E14BCDD6D96D9", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image depicts a dental cartoon theme with a large, smiling, anthropomorphic tooth character in the foreground. The tooth is holding a calendar or notepad that displays a large check mark, signaling approval or confirmation. The tooth character is also giving a thumbs-up gesture. In the background, there is a blurred dental clinic environment with a dental chair and equipment visible, indicating the setting is a dental office. At the top of the image, there is a logo of a stylized tooth and text identifying 'Tanger Bay Dental Center'. Across the center, prominent text in French says, 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green check mark, followed by 'CHEZ TANGER BAY DENTAL CENTER' on a blue background.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"\",\n    \"alignment\": \"\",\n    \"calculus_plaque\": \"\",\n    \"periapical_areas\": \"\",\n    \"other_findings\": \"\"\n  },\n  \"text_visible\": [\n\nUser message context: Salut *ABDELAOUI MOHAMED*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 04 juin 2026*\r\n🕘 Heure : *17:00*\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.", "created_at": "2026-06-03T15:05:48.396057", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10713/download", "media_mime_type": "image/jpeg"}, {"id": 38499, "message_id": "3EB0A066B33F6CC7D6D3A8", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABDELAOUI MOHAMED*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 04 juin 2026* à *17: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لديكم موعد مع ** يوم *الخميس 4 يونيو 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-03T16:36:04.920223", "media_url": null, "media_mime_type": null}, {"id": 38996, "message_id": "3EB0C884AECD1915F85C79", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *200,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+2000,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-04T17:09:25.061180", "media_url": null, "media_mime_type": null}, {"id": 38998, "message_id": "3EB034937F3C2C571C395B", "sender": "bot", "message_type": "document", "content": "2026060418084953.pdf", "created_at": "2026-06-04T17:09:51.114635", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10859/download", "media_mime_type": "application/pdf"}, {"id": 39028, "message_id": "3EB02EDAFAF836BBECF269", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABDELAOUI MOHAMED*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 18 juin 2026* à *15: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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-04T18:04:40.973829", "media_url": null, "media_mime_type": null}, {"id": 39890, "message_id": "3A190D38D79888FCAC0F", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم، كيف نتينا لاباس؟ كلشي بخير على خير؟ كنتِ عملتي لي رونديفو نهار الخميس قلت لك، ياك؟ تقدر تعمل لي الاثنين، ماشي غدا، الاثنين الآخر؟ عندي واحد الشغل تما، نجي لطنجة، ما كرهتشي نهار الاثنين في العشية مع ديك الربعة هايداك.", "created_at": "2026-06-06T22:00:11.806500", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11106/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39891, "message_id": "bot_3A190D38D79888FCAC0F_6951", "sender": "bot", "message_type": "text", "content": "مرحبا السي ABDELAOUI MOHAMED 😊 شكراً على التوضيح.", "created_at": "2026-06-06T22:01:01.609650", "media_url": null, "media_mime_type": null}, {"id": 39892, "message_id": "bot_3A190D38D79888FCAC0F_167", "sender": "bot", "message_type": "text", "content": "باش نكمل معاك الطلب، واخا تكتب ليا الإسم الكامل ديالك هنا باش نتأكد من طريقة كتابته، وزيد أكد ليا واش الموعد اللي بغيت تبدل هو ديال الخميس 18 يونيو مع 15:00؟\n\nوغادي نبلغ الفريق بطلبك إن شاء الله.", "created_at": "2026-06-06T22:01:01.693378", "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 3228 in training_review_items