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": 15377, "message_id": "ACF313A938BE072550A28DA9022D0DD4", "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 a close-up view of a person's mouth, slightly open, revealing both upper and lower teeth. The upper front teeth display spacing (diastema) and some degree of crowding, particularly to the viewer's right side. The lower teeth also show mild crowding with overlapping of the anterior teeth. Gum tissue appears generally healthy, with a pink color and no obvious inflammation, but only partially visible. Some variation in tooth color is present, with the lower teeth appearing slightly more yellow than the uppers. No obvious large restorations, prostheses, or orthodontic appliances are seen. No text, labels, or extraneous objects are visible.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Visible spacing (diastema) between the two central incisors, with some crowding and irregular alignment of adjacent teeth.\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"upper_left\",\n        \"observation\": \"Mild crowding and rotation of lateral teeth visible.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"upper", "created_at": "2026-04-14T10:23:58.199861", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3982/download", "media_mime_type": "image/jpeg"}, {"id": 16322, "message_id": "A582EE24B41C1D043660B87617D1D571", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija and French:\n\n\"صباح الخير مدام، كيف نتي مزيانة؟ بخير؟ صحة لاباس؟ مدام أنا هضرت مع الدكتور بالنسبة للحالة ديالك، خاصك gouttière. هادوك les gouttières ديال contention، كتعملهم زعما بحالهم بحال السلك، غير هوما الدور ديالهم حسن من السلك، كيصرعو المدة ديال زعما السنان يقربو لبعضهم.\"\n\n**Transcription in Latin script (Darija/French mix):**\n\"Sbah lkhir madam, kif nti mziana? bikhir? saha labas? Madam ana hdert m3a docteur binnisba l l-hala dyalk, khask gouttière. Hadouk les gouttières dyal contention, kat3mlhom za3ma bhalhom bhal s-selk, ghir houma d-dawer dyalhom hsen men s-selk, kaysar3ou l-mouda dyal za3ma s-snan iqerbou l-ba3dhom.\"", "created_at": "2026-04-15T16:17:57.126843", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4321/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16330, "message_id": "ACF4B2AA9F25D6E91F828732969CC056", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a close-up view of an adult person's mouth open, displaying the upper and lower anterior teeth and adjacent gum tissue. The upper central incisors are spaced apart (midline diastema) and there is a missing upper right lateral incisor (tooth #12) and a missing upper left lateral incisor (tooth #22). Markings in the image (green lines and an arrow) highlight these points. Teeth are mostly present except for the upper lateral incisors. The lower anterior teeth are slightly crowded, and the teeth color appears to be natural with some mild discoloration. Gum tissue appears generally healthy without prominent redness or swelling. No visible caries, crowns, fillings, or dental prostheses are seen. No soft tissue lesions or acute injuries present. The lips and a portion of the surrounding skin are visible.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Missing both upper lateral incisors; central incisors present with a large gap between them (midline diastema)\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"front_lower\",\n\nUser message context: ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"A close-up clinical intraoral photo of an adult's mouth, showing the upper and lower anterior and premolar teeth. The mouth is open, allowing visualization of the incisal and labial surfaces of the teeth, as well as the gingival margins. The upper arch displays a significant midline diastema and missing maxillary anterior teeth. Three green lines mark specific tooth areas, and a green arrow points to the region beneath the nose, apparently highlighting the absence of maxillary central incisors. The lower teeth are generally present and closely aligned, though slightly yellowed compared to the upper teeth. Gum tissue appears visible but only partially in the photo. No soft tissue lesions or overt swelling is noted.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Missing central and lateral incisors, large midline gap (midline diastema), remaining canines visible.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"upper_right\",\n        \"observation\": \"Posterior teeth visible, appear intact with no obvious gross caries, minor staining possible.\",\n        \"severity_signal\":", "created_at": "2026-04-15T16:25:46.360608", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4324/download", "media_mime_type": "image/jpeg"}, {"id": 16331, "message_id": "bot_ACF4B2AA9F25D6E91F828732969CC056_7528", "sender": "bot", "message_type": "text", "content": "Merci pour l’envoi des photos et toutes ces précisions. L’équipe a bien reçu votre demande pour une consultation en vue de la pose de facettes, et prendra en compte vos attentes ainsi que la situation clinique visible sur les images.\n\nPour les questions de coût et de planification, seul le Dr Haitham Boutaib pourra vous donner une estimation personnalisée après analyse complète en cabinet, surtout avec les particularités visibles (espaces, dents manquantes, alignement). L’équipe vous contactera rapidement pour fixer un rendez-vous entre le 18 et le 22 mai et répondre à toutes vos questions.\n\nNote : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-04-15T16:26:43.228490", "media_url": null, "media_mime_type": null}, {"id": 16332, "message_id": "AC3A34D0212FF4087AFF6AF1D37CE190", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows the lower half of a person's face, focusing on the open mouth and teeth. Green markings are drawn on the skin above the upper lip and across an upper central incisor. The upper front teeth display diastema (a gap between the central incisors), and there is a noticeable space indicating a missing upper right lateral incisor. The upper right canine is present but the teeth alignment is irregular. The lower teeth appear intact, with minor crowding and mild discoloration. The gums appear light pink, though a detailed assessment of gum tissue is limited by the angle and lighting.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Diastema between the upper central incisors; upper right lateral incisor is missing; irregular tooth alignment; teeth appear clean with natural color\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"All lower front teeth appear present with minor crowding and mild discoloration, generally aligned\",\n        \"severity_signal\": \"mild\"\n      }\n    ],\n    \"gum_condition\": \"Gum\n\nUser message context: ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image depicts an open mouth with visible upper and lower anterior teeth. The upper anterior teeth show a midline diastema (space) between the two central incisors. There is also a missing tooth (upper left lateral incisor). The alignment of both upper and lower teeth appears irregular, with noticeable crowding and spacing. The gum tissue is healthy pink but with slight redness near the missing tooth area. No clear soft tissue lesions or swelling are visible. The teeth generally appear slightly yellowed. There are green markings added to the image: one above the upper lip, and another over the gap in the upper arch.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Midline diastema between upper central incisors, and missing upper left lateral incisor.\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Lower anterior teeth show mild crowding and appear intact with no obvious fractures or caries.\",\n        \"severity_signal\": \"mild\"\n      }\n    ],\n    \"gum_condition\": \"Gums appear mostly healthy pink", "created_at": "2026-04-15T16:27:14.691241", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4325/download", "media_mime_type": "image/jpeg"}, {"id": 16333, "message_id": "bot_AC3A34D0212FF4087AFF6AF1D37CE190_1001", "sender": "bot", "message_type": "text", "content": "Merci pour l’envoi de ces nouvelles photos et détails. Toutes vos images et informations seront bien prises en compte par l’équipe médicale pour préparer votre consultation avec le Dr Haitham Boutaib. Cela permettra d’analyser au mieux votre situation (espaces, dents manquantes, alignement…) avant le rendez-vous.\n\nL’équipe vous recontactera très bientôt pour fixer la date exacte et discuter du plan de traitement adapté à votre cas.\n\nNote : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-04-15T16:27:38.408826", "media_url": null, "media_mime_type": null}, {"id": 16334, "message_id": "AC25D5D5B64EB60C2BBA7B1C36509F36", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم وفوالا أختي شوف الصورة اللولانية كنظن بأن هاديك l’étape اللي بغيت نسول عليها أنه غيكون واحد modelage ديال السنان ديال السنة ديال هاديك على الشمال، ضرسة هاديك. تكون واحد modelage باش تشبه لهاديك la canine اللي كاينة في جهة أخرى باش يكون واحد النوع ديال symétrie، غتخلق واحد symétrie. يعني ممكن تكون بالcomposite ولا ربما première étape تكون composite باش نشوفوا واش ديك الجهة غتعطي شي حاجة. L’étape الثانية هو أن هادوك les dents القداميين اللي مفتوحين واحدة طويلة على أخرى هاديك ديال اليمين إلا كان ممكن حتى هي يوقع ليها modelage باش تكون في نفس الطول فحال أخرى اللي قدامها فحال هاديك اللي على الشمال. وفوالا et la troisième étape أنا غنصيفط تصويرة.", "created_at": "2026-04-15T16:28:21.560411", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4326/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16335, "message_id": "bot_AC25D5D5B64EB60C2BBA7B1C36509F36_983", "sender": "bot", "message_type": "text", "content": "شكراً بزاف على التوضيحات ديالك وعلى الشرح المفصل ديال الخطوات اللي باغية تناقشيهم مع الدكتور (modelage بالـ composite، symétrie، وتعديل الطول ديال السنان القداميين). غادي نوصل كل هاد التفاصيل للفريق الطبي مع الصور اللي سبق وصيفطتيهم.\n\nغادي يتواصلوا معكوم قريباً باش يناقشوا معاكوم جميع المراحل ويعطيوكوم رأي الدكتور وخطة العلاج المناسبة لحالتك إن شاء الله.\n\nإلى كان عندك أي سؤال إضافي أو بغيت تصيفطي تصويرة أخرى، مرحباً في أي وقت!", "created_at": "2026-04-15T16:28:43.910792", "media_url": null, "media_mime_type": null}, {"id": 16336, "message_id": "ACC88C1D1C84520A42261AD9CEC0A6FB", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```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 of an open mouth, focusing on the upper and lower anterior teeth. The upper central incisor region shows a missing tooth with a gap between the remaining upper teeth. There is a green digital mark outlining the region corresponding to the upper right lateral incisor. The upper teeth exhibit mild to moderate yellowing and possible minor translucency or wear, and most appear intact aside from the missing tooth. The lower anterior teeth appear slightly crowded and show some yellowing. The gum tissue is mostly pink, and the margins are visible in the anterior area.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"A central incisor is missing, leaving a noticeable gap. Remaining incisors show mild discoloration and wear.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"upper_left\",\n        \"observation\": \"Teeth adjacent to the missing incisor appear intact with mild yellowing and slight surface irregularities.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"upper_right\",\n        \"observation\": \"The region\n\nUser message context: ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a person's open mouth with lips retracted to display upper and lower teeth. The skin around the mouth, including part of the nose and chin, is visible. There is a green marking shaped like a 'U' drawn on the right maxillary (upper right) side, specifically around the area of a missing upper front tooth. The upper anterior teeth are visible, and there is a noticeable gap in the upper right central or lateral incisor region. The lower anterior teeth are present and appear generally intact. The gingival tissues are partially visible and appear to be of normal color, with no obvious signs of significant inflammation, swelling, or gum recession visible in this image. Teeth have some mild color variation but no large visible caries or fractures. Mild crowding or misalignment may be present, particularly in lower anterior teeth.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_right\",\n        \"observation\": \"Missing tooth in the upper right anterior segment corresponding to the region marked in green. Surrounding teeth appear of normal color and structure.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"upper_left", "created_at": "2026-04-15T16:29:15.832309", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4327/download", "media_mime_type": "image/jpeg"}, {"id": 16337, "message_id": "bot_ACC88C1D1C84520A42261AD9CEC0A6FB_8095", "sender": "bot", "message_type": "text", "content": "شكراً بزاف على التصويرة الجديدة والتوضيحات اللي سبق وشرحتيهم. كلشي وصل للفريق الطبي مع الشرح ديالك حول modelage والتعديلات اللي باغية تديريهم (باش يكونو السنان متشابهين فالشكل والطول).\n\nالفريق غادي يشوف جميع الصور والملاحظات ديالك، وغادي يتواصل معكوم قريباً باش يناقشوا معاكوم الخطة الأنسب ويعطيوكوم رأي الدكتور بالتفصيل إن شاء الله.\n\nإلى كان عندك أي سؤال آخر أو بغيت تصيفطي شي حاجة إضافية، مرحباً في أي وقت!", "created_at": "2026-04-15T16:29:45.297503", "media_url": null, "media_mime_type": null}, {"id": 16338, "message_id": "ACF948E1EBCA749BB0A715BE983B4924", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم، مع هاد ليطاب التالتة هو ديك السنة هاديك اللي دابا علمت عليها داخلة شويش عوجة، يعني واش ممكن فحال تعمار ولا يوقع حتى واحد المودلاج يمكن ربما بالزيادة باش تجي، تجي فالصف ديال هادو هاد لي زوطر دون لي كاينين قدامهم، فوالا.\n\nوكاين كنظن تا إمكانية أن هادوك السنان لقداميين جوج، أن هداك الوسط ديك الفتيحة الـ gap لي فالوسط، تنقص شويش مثلاً بدوك لي فاصيت، أن لي فاصيت يكونوا شويش، يكونوا بطريقة أن تنقص شويش ماشي كلشي، مابغيتش تنقص كلشي، غير تنقص، يكون واحد النوع ديال سيميتري اللي ممكن يتحقق.\n\nفهذا هو التصور ديالي ماعرفتش شنو الإمكانيات اللي موجودة، شكرا.", "created_at": "2026-04-15T16:30:22.640096", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4328/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16340, "message_id": "bot_ACF948E1EBCA749BB0A715BE983B4924_2158", "sender": "bot", "message_type": "text", "content": "شكراً بزاف أختي على الشرح المفصل والرؤية اللي عندك بخصوص التعديلات اللي باغية تديريهم (تعمار أو modelage للسنة اللي داخلة شوية، وتصغير الفتيحة بين السنان القداميين بطريقة متوازنة).\n\nغادي نوصل كل هاد التفاصيل للفريق الطبي مع الصور والملاحظات السابقة، باش الدكتور يقدر يطلع على كل النقاط اللي مهمة ليك ويعطيك الرأي المناسب والإمكانيات المتوفرة.\n\nالفريق غادي يتواصل معكوم قريباً إن شاء الله باش يناقشوا معاكوم كل الحلول الممكنة ويحددوا معاكوم الخطوات الجاية. إذا كان عندك أي سؤال آخر أو بغيت تزيدي شي توضيح، مرحباً في أي وقت!", "created_at": "2026-04-15T16:30:50.692719", "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 1216 in training_review_items