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": 15334, "message_id": "ACBA363CEB4CFA746DAF694F12DE5FB4", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-04-14T09:36:55.250702", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3957/download", "media_mime_type": "image/jpeg"}, {"id": 15339, "message_id": "ACFB64ADAB85ED37EE078A2A6443585D", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-04-14T09:43:06.597616", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3959/download", "media_mime_type": "image/jpeg"}, {"id": 15340, "message_id": "AC08BEA887D760CB24896D2C0EB66447", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-04-14T09:43:07.152780", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3960/download", "media_mime_type": "image/jpeg"}, {"id": 15341, "message_id": "AC062DEA5A293ED378F713C0DDF4B672", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-04-14T09:43:07.498777", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3961/download", "media_mime_type": "image/jpeg"}, {"id": 15342, "message_id": "AC52A43F1D530BFFD228C2AD242A9B9D", "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 a close-up of the lower half of a person's face, focusing on the mouth area with the subject smiling to show both the upper and lower front teeth. The lips are retracted naturally to expose the teeth. The person is wearing a lavender or purple colored scarf. The photo is taken indoors, with part of the room visible in the background, including a wood beam, part of a wall, and an air conditioning unit. In the lower left corner, the text 'Galaxy S22' is visible.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Teeth appear relatively well-maintained. There is a visible midline diastema (gap) between the upper central incisors. Some slight irregularity in incisor alignment and minor edge translucency. No obvious decay or major discolorations visible.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Lower incisors are visible, appear crowded with noticeable overlapping. No obvious large caries or fractures seen.\",\n        \"severity_signal\": \"mild\"\n      }", "created_at": "2026-04-14T09:43:07.810196", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3962/download", "media_mime_type": "image/jpeg"}, {"id": 15343, "message_id": "AC93EDA5EF4CDFB7FB8350D9033CF2EF", "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 photograph of the lower half of a person's face, showing a side view of their smile. The individual's head is covered with a purple scarf. The teeth are visible from the left side, showing both upper and lower arches with lips slightly parted. The gums are partially visible, and the teeth appear generally clean. The background reveals an indoor environment with a wooden beam, an air conditioning unit, and white ceiling and wall panels. The text 'Galaxy S22' is visible at the bottom left of the image.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_left\",\n        \"observation\": \"Teeth are aligned with slight variation in color. Some teeth exhibit mild yellowish discoloration. No obvious signs of decay or fracture visible. Slight crowding or overlap is present.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"lower_left\",\n        \"observation\": \"Lower anterior teeth are visible and show mild crowding. Color appears consistent with upper teeth. No obvious fractures or gross discolorations seen.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"", "created_at": "2026-04-14T09:43:08.288970", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3963/download", "media_mime_type": "image/jpeg"}, {"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}]

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 1213 in training_review_items