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": 43747, "message_id": "3EB0A6B2F4DEAC8F04A6A7", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABADA SERHOUNI MOUNIBA*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 22 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لديكم موعد مع ** يوم *الأثنين 22 يونيو 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-15T14:49:06.477207", "media_url": null, "media_mime_type": null}, {"id": 45059, "message_id": "3EB0575C767B070258C814", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABADA SERHOUNI MOUNIBA*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 19 juin 2026* à *11: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**\r\nلديكم موعد مع ** يوم *الجمعة 19 يونيو 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-18T09:02:09.419686", "media_url": null, "media_mime_type": null}, {"id": 45060, "message_id": "A5F0D357A2229FFDC990029267B5CA45", "sender": "bot", "message_type": "voice", "content": "[Voice message received but could not be transcribed. Ask the user to resend as text.]", "created_at": "2026-06-18T09:02:26.227632", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12440/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 45128, "message_id": "A5CFCA8B4D0A94D093D0C6FFCC67C36A", "sender": "user", "message_type": "text", "content": "D'accord inchallah", "created_at": "2026-06-18T11:01:27.793395", "media_url": null, "media_mime_type": null}, {"id": 45380, "message_id": "3EB0F925E2B3298CB9114E", "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 digital promotional graphic for Tanger Bay Dental Center. The background depicts a blurred dental office setting with light blue and white tones and a dental chair. In the foreground, there is an illustrated, anthropomorphic tooth character with facial features (eyes, eyebrows, smiling mouth) and an arm giving a thumbs up. The character is holding a small calendar or checklist with a green check mark. The upper part of the image contains the logo of Tanger Bay Dental Center, which consists of a stylized tooth and the text 'TANGER BAY DENTAL CENTER.' Prominently displayed are two blue banner texts reading 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' (with a green check mark) and 'CHEZ TANGER BAY DENTAL CENTER.'\",\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\n\nUser message context: Salut *ABADA SERHOUNI MOUNIBA*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 19 juin 2026*\r\n🕘 Heure : *11: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-06-18T15:03:56.036185", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12560/download", "media_mime_type": "image/jpeg"}, {"id": 46889, "message_id": "3EB0FB0C1386357EF7DDA4", "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 digital illustration showing a smiling anthropomorphic tooth character. The tooth has large cartoon eyes, raised brows, and is giving a thumbs up with one 'hand' while holding a small calendar or notepad with a green check mark with the other 'hand.' In the background, there is a blurred dental clinic setting with a dental chair and equipment visible. The upper part of the image features a dental clinic logo with a tooth design and text that reads 'TANGER BAY DENTAL CENTER.' Two prominent text banners state 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a checkmark icon and 'CHEZ TANGER BAY DENTAL CENTER.' The dominant colors are light blue, white, and beige. The scene is bright and professional, clearly themed for appointment confirmation at a dental office.\",\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\":\n\nUser message context: Salut *ABADA SERHOUNI MOUNIBA*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mardi 23 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.", "created_at": "2026-06-22T15:07:41.219343", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12990/download", "media_mime_type": "image/jpeg"}, {"id": 46920, "message_id": "A557C24B4345835FA760155D09A4E792", "sender": "user", "message_type": "text", "content": "D'accord inchallah", "created_at": "2026-06-22T15:24:42.829415", "media_url": null, "media_mime_type": null}, {"id": 48503, "message_id": "A59B9A50E3E2243D334E7575F4BB3C05", "sender": "user", "message_type": "text", "content": "Un excellent cabinet dentaire ! L'acceuil est très chaleureux, l'équipe est d'une grande gentillesse et le dentiste est super professionnel. Le cabinet est d'une propreté irréprochable.\nJe recommande vivement !", "created_at": "2026-06-25T14:19:28.258477", "media_url": null, "media_mime_type": null}, {"id": 48505, "message_id": "bot_A59B9A50E3E2243D334E7575F4BB3C05_2145", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre retour si positif et vos recommandations, ça nous fait vraiment plaisir !", "created_at": "2026-06-25T14:20:02.877384", "media_url": null, "media_mime_type": null}, {"id": 48506, "message_id": "bot_A59B9A50E3E2243D334E7575F4BB3C05_1270", "sender": "bot", "message_type": "text", "content": "Toute l’équipe vous remercie chaleureusement 😊 Au plaisir de vous accueillir prochainement chez nous.", "created_at": "2026-06-25T14:20:02.930011", "media_url": null, "media_mime_type": null}, {"id": 48508, "message_id": "A588BE74B32ECD5E0A902C6F7A60D7F0", "sender": "user", "message_type": "text", "content": "🙏🙏🙏", "created_at": "2026-06-25T14:21:32.894616", "media_url": null, "media_mime_type": null}, {"id": 48509, "message_id": "bot_A588BE74B32ECD5E0A902C6F7A60D7F0_4269", "sender": "bot", "message_type": "text", "content": "Avec plaisir 🙏🏻 Merci encore pour votre confiance !", "created_at": "2026-06-25T14:21:47.023865", "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 4011 in training_review_items