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": 13056, "message_id": "AC58CB2F488573A3E2B3B6EC36FCC1F5", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-04-09T11:34:55.864818", "media_url": null, "media_mime_type": null}, {"id": 13057, "message_id": "A55300A0ADC970626E1B9AA0500B039F", "sender": "bot", "message_type": "text", "content": "Bonjour et bienvenue au Cabinet dentaire Tanger Bay \nمرحبا بكم فـ عيادة طنجة باي لطب الأسنان.\n\n Merci de nous indiquer en quoi nous pouvons vous aider afin que notre équipe puisse vous orienter au mieux.\nمن فضلكم، أخبرونا كيف يمكننا مساعدتكم لكي يتمكن فريقنا من توجيهكم بشكل مناسب\n\n📍 Localisation : https://maps.app.goo.gl/ZCXz3sMZkhk9diph7\n🌐 Site web : www.tangerbay.ma\n📧 Email :\ntangerbay01@gmail.com\n\n✅ Notre équipe vous répondra dans les plus brefs délais.\nسيقوم فريقنا بالرد عليكم في أقرب وقت ممكن", "created_at": "2026-04-09T11:34:56.414350", "media_url": null, "media_mime_type": null}, {"id": 13058, "message_id": "bot_AC58CB2F488573A3E2B3B6EC36FCC1F5_6580", "sender": "bot", "message_type": "text", "content": "مرحبا الله اودي، شكرا على التواصل ديالكوم مع Centre Dentaire Tanger Bay. واش ممكن تقولولي شنو الحاجة اللي محتاجينها اليوم؟ 😊", "created_at": "2026-04-09T11:35:14.289321", "media_url": null, "media_mime_type": null}, {"id": 13060, "message_id": "3EB0E59C870C17C36DD9AD", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MACHAR Kaoutar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 13 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لديكم موعد مع ** يوم *الأثنين 13 أبريل 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-09T11:37:47.869001", "media_url": null, "media_mime_type": null}, {"id": 14035, "message_id": "3EB0630F2ECFDA40D0D5D9", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MACHAR Kaoutar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 13 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لديكم موعد مع ** يوم *الأثنين 13 أبريل 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-11T12:34:51.694306", "media_url": null, "media_mime_type": null}, {"id": 14225, "message_id": "3EB01E7C2089F1C605A029", "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\": \"This is a digitally created advertisement image for Tanger Bay Dental Center. The background is a blurred dental clinic setting, with a dental chair partially visible. In the foreground, there is a large, animated, anthropomorphic tooth character with a smiling face and thumbs up gesture. The character is holding a notepad with a large green checkmark. At the top of the image, there is the logo for Tanger Bay Dental Center featuring a stylized tooth graphic and the clinic name. Two blue banners contain French text confirming a dental appointment. The overall color palette is light blue and white.\",\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    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n\nUser message context: Salut *MACHAR Kaoutar*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *lundi 13 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-12T00:28:04.634587", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3673/download", "media_mime_type": "image/jpeg"}, {"id": 14732, "message_id": "3EB095AD0943408AFAF323", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MACHAR Kaoutar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 13 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لديكم موعد مع ** يوم *الأثنين 13 أبريل 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-13T10:18:42.638295", "media_url": null, "media_mime_type": null}, {"id": 14863, "message_id": "3EB00D058FD57F288717F8", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MACHAR Kaoutar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 13 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لديكم موعد مع ** يوم *الأثنين 13 أبريل 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-13T13:27:13.421216", "media_url": null, "media_mime_type": null}, {"id": 15105, "message_id": "3EB01AE5B8E4B239714D9F", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MACHAR Kaoutar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 16 avril 2026* à *10:15* .\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لديكم موعد مع ** يوم *الخميس 16 أبريل 2026* على الساعة *10:15*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-13T17:29:57.376700", "media_url": null, "media_mime_type": null}, {"id": 15106, "message_id": "AC65FFF47F459893AFC78C54B3E7D67B", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a digital transaction receipt with a black background and text in white and gray. The transaction amount is 500.00 DH. The receipt is for a dentist named 'Haytam Dentiste.' It includes reference details, the transaction type, sender and beneficiary information, sender account number, beneficiary RIB, amount, transaction status, initiation and execution dates, and the reason for the transfer. The status is marked as 'Executed.' Most fields use standard French banking transaction terms.\",\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    \"500,00 DH\",\n    \"Haytam Dentiste\",\n    \"Référence\",\n    \"354145082\",\n    \"Type du virement\",\n    \"Standard\",\n    \"Emetteur\",\n    \"MME MACHAR KAOUTAR\",\n    \"Compte émetteur\",\n\nUser message context: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image captures a digital screenshot or photo of a money transfer confirmation. The document is in French, with a dark background and white text, showing details of a bank transfer. It records a payment of 500,00 DH to 'Haytam Dentiste'. The document includes a transaction reference, type of transfer, sender and recipient details, account numbers, status, dates of initiation and execution (both on 13/04/2026), and the reason for the transfer, which is 'Avence Dentiste'.\",\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    \"500,00 DH\",\n    \"Haytam Dentiste\",\n    \"Référence\",\n    \"354145082\",\n    \"Type du virement\",\n    \"Standard\",\n    \"Emetteur\",\n    \"MME MACHAR KAOUTAR\",", "created_at": "2026-04-13T17:33:45.242892", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3881/download", "media_mime_type": "image/jpeg"}, {"id": 15107, "message_id": "3EB0887D4F183DF1614F87", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *500,00* dirhams (*Virement*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-3000,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-13T17:33:57.082523", "media_url": null, "media_mime_type": null}, {"id": 15108, "message_id": "bot_AC65FFF47F459893AFC78C54B3E7D67B_933", "sender": "bot", "message_type": "text", "content": "مرحبا بيكوم 😊 توصلنا بتأكيد الأداء ديالكوم، شكرا بارك الله فيكوم. إذا محتاجين شي توضيح إضافي ولا عندكوم سؤال، حنا رهن الإشارة.", "created_at": "2026-04-13T17:34:15.235378", "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 1086 in training_review_items