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": 7536, "message_id": "3EB0CC820E159EFC941C9F", "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 shows a cartoon tooth character with a smiling face, holding a small notepad with a green checkmark. Above the character, there are blue banners with white text that read, 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and 'CHEZ TANGER BAY DENTAL CENTER.' The background appears to be an office or clinic setting, with blurred furniture, possibly a dental chair, suggesting a dental clinic environment. The logo 'TANGER BAY DENTAL CENTER' is visible at the top of the image with a stylized tooth design.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\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    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\",\n    \"TANGER BAY DENTAL CENTER\"\n  ],\n\nUser message context: Salut *BOULAICH Imad*👋\r\nNous vous confirmons votre rendez-vous avec *DR ALAMI MUSTAPHA*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 28 mars 2026*\r\n🕘 Heure : *13: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.", "created_at": "2026-03-27T15:05:58.761397", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1581/download", "media_mime_type": "image/jpeg"}, {"id": 7538, "message_id": "3EB0A0EA1216FFB36564FE", "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 features a cartoonish smiling tooth character, holding a calendar with a green check mark, symbolizing an appointment confirmation. In the background, the interior of a dental clinic is visible with blurred elements like a dental chair and equipment. The top of the image displays a logo with a stylized tooth and the text 'TANGER BAY DENTAL CENTER'. Below the logo, in the center, there's prominent text stating 'VOTRE RENDEZ-VOUS EST CONFIRMÉ', followed by 'CHEZ TANGER BAY DENTAL CENTER'. The background is a light blue gradient.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"not applicable\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"none\",\n    \"alignment\": \"none\",\n    \"calculus_plaque\": \"none\",\n    \"periapical_areas\": \"none\",\n    \"other_findings\": \"none\"\n  },\n  \"text_visible\": [\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY\n\nUser message context: Salut *BOULAICH Aicha*👋\r\nNous vous confirmons votre rendez-vous avec *DR ALAMI MUSTAPHA*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 28 mars 2026*\r\n🕘 Heure : *13:45*\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-03-27T15:06:11.165175", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1582/download", "media_mime_type": "image/jpeg"}, {"id": 7546, "message_id": "3A5B6E60D24E36EC04A2", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم احبيبة ديالي، كيف نتي لاباس، بخير، مزيانة؟ الحمد لله، وصافي بصراحة صعيبة تقولها لي دابا وتقول لي أجي غدا لأن أنا بعيدة. و\"أبار\" (Apart) بعيدة عندنا واحد الجنازة، والله العظيم عندنا واحد الجنازة، ما نقدرش نجي غدا. واش تقدر تبدل لي يعني السيمانة اللي ماجية، الاثنين، الثلاثاء، الأربعاء، الخميس، أي نهار بغيتي، حدّي الجمعة، الجمعة غانطلع ف حالي، صافي، حيت حنا عندنا العطلة غانبقى ف طنجة من الاثنين حتى للجمعة، إلى قدرتي تعطيني شي نهار من هاد النّهارات.", "created_at": "2026-03-27T15:12:03.427669", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1583/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7549, "message_id": "A5A7212BE291D5DDE7BFCF01056F12EB", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-27T15:12:44.934225", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1585/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7550, "message_id": "bot_3A5B6E60D24E36EC04A2_2450", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله 😊\n\nكنعتدر على الظروف اللي عندك. غادي نبلغ الفريق بالإلغاء ديال الموعد ديالك غدا، وغادي نحاول نلقاو ليك موعد جديد في الأسبوع الجاي. واش ممكن تعطيني الإسم ديالك باش نكمل الإجراءات؟ شكرا بارك الله فيك.", "created_at": "2026-03-27T15:12:56.666446", "media_url": null, "media_mime_type": null}, {"id": 7558, "message_id": "3A31C068A78440D20A35", "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 (Transliteration):**\nSafi hbiba dyali, insh'Allah ya rabi. Gher ana glt lik, andi men tnin l jomo'a. Safi, hado homa nhar li n9der nji fihom, tnin, tlat, l'arb'a, l'khmiss, awla l'jomo'a. Eh, l'ism Imad Boulaich w Aicha Boulaich.", "created_at": "2026-03-27T15:18:51.670733", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1586/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7563, "message_id": "bot_3A31C068A78440D20A35_258", "sender": "bot", "message_type": "text", "content": "بارك الله فيك على المعلومات. تم إلغاء الموعد السابق وغادي نحاول نلقاو ليكوم موعد جديد. عندنا مواعيد متاحة نهار الاثنين 30 مارس 2026 على الساعة:\n\n- 10:00\n- 14:30\n\nشنو الأنسب ليكوم؟ 😊", "created_at": "2026-03-27T15:19:16.021675", "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 270 in training_review_items