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": 15657, "message_id": "3EB08FA03435DACC544EF3", "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 is a promotional or confirmation graphic related to a dental clinic. It features a cartoon tooth character with a smiling face, holding a small calendar or clipboard showing a green checkmark. The background has a blurred dental office setting with a dental chair and medical equipment visible. The top part of the image contains a blue gradient with the logo of 'Tanger Bay Dental Center', which includes a stylized tooth outline. The main text in the center reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a checkmark, and 'CHEZ TANGER BAY DENTAL CENTER' just below it. The overall color scheme is blue and white, with a friendly and inviting tone.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": null,\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": null,\n    \"alignment\": null,\n    \"calculus_plaque\": null,\n    \"periapical_areas\": null,\n    \"other_findings\": null\n  },\n  \"text_visible\": [\n    \"TANGER BAY DENT\n\nUser message context: Salut *BOURAGBA Mohamed*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mercredi 15 avril 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-04-14T15:03:05.746661", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4073/download", "media_mime_type": "image/jpeg"}, {"id": 16127, "message_id": "3EB0A4087E1F1C29A88789", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BOURAGBA Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mercredi 15 avril 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لديكم موعد مع ** يوم *الأربعاء 15 أبريل 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-15T13:27:38.729918", "media_url": null, "media_mime_type": null}, {"id": 17876, "message_id": "3EB08136271797BA91B6E5", "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 stylized, cartoonish tooth with a smiling face, raised eyebrows, and a thumbs-up gesture. The tooth character is holding a small spiral notepad displaying a green check mark inside a box. In the background, a dental office with blurred furniture and a dental chair is visible. At the top of the image, the logo and name of 'Tanger Bay Dental Center' are displayed, alongside an abstract tooth icon. Two prominent blue text banners overlay the image: the first reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a checkmark, and the second reads 'CHEZ TANGER BAY DENTAL CENTER.' The color palette is predominantly blue and white, creating a clean dental clinic ambiance.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": null,\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": null,\n    \"alignment\": null,\n    \"calculus_plaque\": null,\n    \"periapical_areas\": null,\n    \"other_findings\": null\n  },\n  \"text_visible\n\nUser message context: Salut *BOURAGBA Mohamed*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 24 avril 2026*\r\n🕘 Heure : *11: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-04-23T15:01:14.745931", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4884/download", "media_mime_type": "image/jpeg"}, {"id": 17934, "message_id": "3EB05AED3EE1598361BE96", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BOURAGBA Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 24 avril 2026* à *11: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لديكم موعد مع ** يوم *الجمعة 24 أبريل 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-23T16:10:26.280213", "media_url": null, "media_mime_type": null}, {"id": 18204, "message_id": "3EB098D676C50C57C4D6CC", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BOURAGBA Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 24 avril 2026* à *11: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لديكم موعد مع ** يوم *الجمعة 24 أبريل 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-24T08:38:11.275644", "media_url": null, "media_mime_type": null}, {"id": 18260, "message_id": "3EB0B5DD3E4C08D604E0BD", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BOURAGBA Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 24 avril 2026* à *11: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لديكم موعد مع ** يوم *الجمعة 24 أبريل 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-24T09:16:18.110952", "media_url": null, "media_mime_type": null}, {"id": 18361, "message_id": "3EB0C4EFC786380B61A18F", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BOURAGBA Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mardi 28 avril 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لديكم موعد مع ** يوم *الثلاثاء 28 أبريل 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-24T10:52:53.193761", "media_url": null, "media_mime_type": null}, {"id": 21363, "message_id": "AC2F79A0FA231D5D6A0D904ADD36F5A3", "sender": "user", "message_type": "text", "content": "Slm cv", "created_at": "2026-04-30T15:38:12.040026", "media_url": null, "media_mime_type": null}, {"id": 21364, "message_id": "AC453851F6540D12AAD7F2B3B2C2D9DD", "sender": "user", "message_type": "text", "content": "Ma3reft fo9ach anji 3ndek", "created_at": "2026-04-30T15:38:24.041965", "media_url": null, "media_mime_type": null}, {"id": 21365, "message_id": "bot_AC453851F6540D12AAD7F2B3B2C2D9DD_41", "sender": "bot", "message_type": "text", "content": "مرحبا محمد 😊 عندك موعد مع الدكتور أسامة معلم نهار الثلاثاء 28 أبريل 2026 مع الخمسة ديال العشية. يلا بغيتي تبدل الوقت أو عندك شي استفسار آخر، غير قوليه ليا.", "created_at": "2026-04-30T15:38:44.003364", "media_url": null, "media_mime_type": null}, {"id": 21366, "message_id": "AC29DDEC780DF8D1C448284920901DD3", "sender": "user", "message_type": "text", "content": "راني عد هدرت معاك ابيل", "created_at": "2026-04-30T15:39:51.785586", "media_url": null, "media_mime_type": null}, {"id": 21367, "message_id": "bot_AC29DDEC780DF8D1C448284920901DD3_1971", "sender": "bot", "message_type": "text", "content": "شكرا محمد على التواصل ديالك 😊 الفريق غادي يتواصل معكوم بهاد الموضوع إن شاء الله 🙏🏻 يلا كان شي أمر مستعجل، تقدّر تتصل مباشرة على: +212 660-022-263", "created_at": "2026-04-30T15:40:04.724147", "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 1615 in training_review_items