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": 15563, "message_id": "3AF50EE1EC1F4F99371F", "sender": "user", "message_type": "text", "content": "Slm", "created_at": "2026-04-14T14:03:11.663698", "media_url": null, "media_mime_type": null}, {"id": 15564, "message_id": "A5C16FE63732C9BB3280AE2E07E8DC40", "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-14T14:03:15.498750", "media_url": null, "media_mime_type": null}, {"id": 15565, "message_id": "3AE9E7A131B384D26F4A", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a close-up intraoral photo showing the right side teeth and gums of a person. A cheek retractor is used to provide a clear view. The image shows upper and lower teeth from canine to molar areas. Several teeth show discoloration, yellow staining, and brown plaque/calculus deposits primarily on lower premolars and molars. The alignment appears irregular, with noticeable malocclusion and crowding. The gum tissue on the upper arch, particularly over the canine and premolar region, appears visibly red and swollen, with a glossy texture that may indicate localized inflammation. The lower gingiva appears less inflamed but there is some plaque accumulation visible. No obvious crowns, fillings, bridges, or prosthetic restorations are identified. No text is visible in the image.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_right canine and premolar\",\n        \"observation\": \"Teeth present, yellow discoloration, visible plaque near the gumline and on biting surfaces.\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"lower_right canine and premolars\",\n        \"observation\": \"Teeth", "created_at": "2026-04-14T14:03:19.513652", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4047/download", "media_mime_type": "image/jpeg"}, {"id": 15566, "message_id": "3AD4CFCFDAB5FA967D96", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows an intraoral view of the lower dental arch of an adult patient. A cheek retractor is in place, giving a clear view of the mandibular teeth from canine to molars on both left and right sides. The gingival tissues and some adjacent soft tissue structures are visible. The patient appears to be undergoing examination or treatment, as indicated by the presence of a gloved hand holding the retractor.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"lower_right_molars\",\n        \"observation\": \"Multiple occlusal surfaces have visible dark areas suggestive of restorations or carious lesions. At least one tooth has a silver-colored restoration (likely amalgam).\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"lower_left_molars\",\n        \"observation\": \"Multiple occlusal surfaces display darkened areas and likely have amalgam restorations. Some occlusal wear and discoloration is observed.\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"lower_front\",\n        \"observation\": \"Anterior teeth appear intact, with no obvious", "created_at": "2026-04-14T14:03:19.813450", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4048/download", "media_mime_type": "image/jpeg"}, {"id": 15567, "message_id": "3AC02BEBEC2B7F67D8A7", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is an intraoral clinical photograph showing the anterior and posterior teeth with the mouth held open by a cheek retractor. The image is well-focused, and the teeth and gums are clearly visible from canine to canine and partially to premolars and first molars. The lips, facial skin, and part of the mustache are visible at the top of the image.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Central incisor at the upper left appears brighter and more opaque than adjacent teeth, possibly indicating a restoration or hypomineralization. Adjacent incisor has a slight difference in shade and opacity.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Mild wear visible on incisal edges of central incisors. Slight incisal chipping at upper right lateral incisor.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"lower_left\",\n        \"observation\": \"Mild yellowish discoloration noted near the gum line of premolars and canines.\",\n        \"", "created_at": "2026-04-14T14:03:20.077289", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4049/download", "media_mime_type": "image/jpeg"}, {"id": 15568, "message_id": "3A8D41DE8AABDC54B667", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is an intraoral photograph of the right side of an adult's mouth, showing both upper and lower teeth in occlusion. Teeth have varying shades of color, with some yellowish and brownish discoloration, mostly on the lower teeth. Minimal crowding is seen in the lower anterior region. The gum tissue appears generally pink but with some localized redness and a slightly shiny appearance. The last visible lower molar shows a large dark brown to black area, potentially indicative of caries or staining. Minimal plaque or calculus is visible on the cervical margins, more so on the lower teeth. There is some drool and bubbles in the vestibular fold. The lips and facial hair are visible, and a cheek retractor is in place. No obvious swelling, ulceration, or large soft tissue lesions seen.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_right\",\n        \"observation\": \"Anterior and premolars appear intact with normal color, minimal stain. No large cavities visible.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"lower_right\",\n        \"observation\": \"Posterior molar (likely", "created_at": "2026-04-14T14:03:20.485606", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4050/download", "media_mime_type": "image/jpeg"}, {"id": 15569, "message_id": "3AE5F0C82038C53A0181", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a high-quality intraoral photo showing the lower dental arch and occlusal surfaces of the posterior teeth. The tongue is retracted and cheek retractors are in use, providing a clear view of the lower molars, premolars, and some anterior teeth. Multiple teeth show dark areas, possibly indicating carious lesions, particularly on the occlusal surfaces of several molars and premolars. The gum tissue is partially visible and appears to be moist, with no obvious swelling or severe redness. Plaque and calculus buildup are not overtly visible, but there are some areas of discoloration.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"lower_left\",\n        \"observation\": \"Molars and premolars exhibit multiple dark spots or fissures, suggestive of possible caries or staining. No apparent fractures or large restorations.\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"lower_right\",\n        \"observation\": \"Similar appearance with visible dark spots on occlusal surfaces; possible caries or deep staining.\",\n        \"severity_signal\": \"moderate\"\n      },\n      {", "created_at": "2026-04-14T14:03:20.660022", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4051/download", "media_mime_type": "image/jpeg"}, {"id": 15570, "message_id": "3A172650E12306E6B0F6", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is an intraoral clinical photo showing the upper and lower anterior and premolar teeth with lips retracted. The teeth are generally intact and well aligned, with visible natural coloration. The upper central incisors are more opaque, with the right central incisor showing a lighter shade compared to adjacent teeth. Slight incisal translucency and some white spots are visible on the lower anterior teeth. No visible large cavities or fractures. Gums appear pale pink and healthy, with no overt inflammation or swelling. Mild plaque accumulation or staining may be present near the gum line of lower teeth. The surrounding oral tissues, including the mucosa and labial frenum attachment, are partially visible and appear unremarkable.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"The upper central incisors are present, with the right central incisor exhibiting a lighter and more opaque appearance compared to the left. Both central incisors have visible reflective surfaces. Lateral incisors and canines present without obvious lesions.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"", "created_at": "2026-04-14T14:03:20.896367", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4052/download", "media_mime_type": "image/jpeg"}, {"id": 15572, "message_id": "3A37D80CBDA5DA473A73", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (mixed with French and English):\n\n**Latin Script:**\n\"Mouhim hadou houma snanou, houwa déjà bgha inettoyer dak ssoussa li aandou f wahad ddrssa, ila kounti chouftiha, ou ydir nettoyage l snanou kamline. So, ila kan moumkin tgouli lya aafak le prix, ou l’opération chnou ghadi yddar lih, aafak ktbi lya message bach naatih ychouf, ou yvérifier tradiction... aala hssab lougha dyalou, ok?\"\n\n**Arabic Script:**\n\"المهم هادو هوما سنانو، هو ديجا بغا ينطوايي (nettoyer) ديك السوسة لي عندو فواحد الضرسة، إلا كنتي شفتيها، ويدير نيطواياج (nettoyage) لسنانو كاملين. سو (So)، إلا كان ممكن تقولي ليا عافاك le prix، والأوبيراسيون (l’opération) شنو غادي يدار ليه، عافاك كتبي ليا ميساج باش نعطيه يشوف، ويفيريفي (vérifier) traduction... على حساب اللغة ديالو، أوكي؟\"", "created_at": "2026-04-14T14:03:51.872058", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4053/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15573, "message_id": "bot_3A37D80CBDA5DA473A73_6125", "sender": "bot", "message_type": "text", "content": "شكرا بارك الله فيك على التوضيح والصور اللي بعثتيهم. بالنسبة للملاحظة ديالي: كاين فعلا بعض البقع السوداء فبعض الأضراس اللي ممكن تكون سوسة (carie)، وكاين شوية ديال التصبغات والبقع فبعض الأسنان، لكن باش نعطيو تشخيص نهائي أو نحددو العلاج المناسب خاص Dr Haitham Boutaib يشوف الحالة مباشرة ويعمل radio panoramique.\n\nبالنسبة للي طلبتي:\n- تنظيف (nettoyage) الأسنان كاملين كاين عندنا فالعيادة.\n- علاج السوسة (carie) كيتحدد على حساب العمق والمكان، والدكتور هو اللي يقرر واش غادي يحتاج حشو (plombage) بسيط ولا علاج أعمق.\n\nبالنسبة للثمن:\n- nettoyage الأسنان كاملين عندنا بـ 400DH.\n- علاج السوسة (carie) الثمن كيتحدد على حساب الحالة، ولكن خاص الدكتور يشوفها ويحدد واش بسيطة ولا متقدمة.\n\nإذا بغيتو نبلغ الفريق الطبي باش يتواصلوا معكوم ويأكدو موعد، قولي لي غير الإسم الكامل ديال الشخص اللي محتاج العلاج، وشنو الوقت اللي مناسبكوم إن شاء الله.\n\nأي سؤال آخر مرحبا بيكوم!", "created_at": "2026-04-14T14:04:34.417288", "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 1138 in training_review_items