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": 18840, "message_id": "AC3428D348FC36C03729ABAD26D8C48E", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"partial_view\", \"paper_document_artifact\"]\n  },\n  \"description\": \"The image shows a printed panoramic dental X-ray placed on a paper with visible background edges. The X-ray depicts the full upper and lower jaws. Several dental implants are visible in both arches, mostly in the upper arch, with a fixed prosthesis or bridge attached to some implants. There are few or no natural teeth present. Some implant abutments are visible without crowns attached. The bone structure can be assessed in the panoramic view. There is printed text above and below the X-ray, rotated sideways, with a date, patient's name, dossier number, and technical parameters.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_jaw_general\",\n        \"observation\": \"Multiple dental implants are present, with a large fixed prosthesis/bridge replacing much of the natural dentition. No natural teeth are apparent in the upper arch. Some implants appear to be without prosthetic crowns.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"lower_jaw_general\",\n        \"observation\": \"Partial dentition with several implants visible. Few natural teeth appear present,\n\nUser message context: ```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"partial_view\", \"slight blur\", \"scan of printed film\"]\n  },\n  \"description\": \"The image is a panoramic dental X-ray, photographed as a printout. The X-ray shows both jaws. Multiple dental implants are visible in both the upper and lower jaws, some supporting fixed prostheses (bridges). There are several teeth visible, mostly in the lower anterior region. There are edentulous (missing teeth) spaces in the upper jaw, replaced by implants and bridgework. The lower jaw also shows evidence of prosthetic restoration supported by implants. Most natural teeth are missing, replaced by prosthetic structures. The X-ray sheet has printed text at the top and bottom, which appears to include a date, patient name, and dossier number. No other anatomical pathologies, such as gross radiolucencies or obvious bone pathology, are clearly visible at this resolution.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_left\",\n        \"observation\": \"Multiple implants present, supporting a fixed prosthesis. No natural teeth visible in this quadrant.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"upper_right\",\n        \"", "created_at": "2026-04-24T17:52:34.239534", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5237/download", "media_mime_type": "image/jpeg"}, {"id": 18841, "message_id": "bot_AC3428D348FC36C03729ABAD26D8C48E_2635", "sender": "bot", "message_type": "text", "content": "كنعتدر، ماعنديش صلاحية نعطي تفسير أو تفاصيل على الراديو ديال الأسنان أو الحالة الطبية من خلال الصور. غادي نبلغ الفريق الطبي ديالنا بالصورة والسؤال ديالك باش يتواصلوا معكوم ويعطيوك التوضيحات اللازمة إن شاء الله.\n\nواخا تعطيني الإسم الكامل ديالك؟", "created_at": "2026-04-24T17:52:57.942867", "media_url": null, "media_mime_type": null}, {"id": 18842, "message_id": "ACFE5923C1EA774F3B2BEC478D78EB73", "sender": "user", "message_type": "image", "content": "```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"low_resolution\", \"slight_blur\"]\n  },\n  \"description\": \"The image is a panoramic dental X-ray showing both arches with a focus on the upper jaw. Several dental implants are visible, particularly in the upper arch (maxilla), distributed from the left to the right posterior region. Some of these implants support prosthetic crowns or bridges, while others appear as stand-alone implants. There appear to be additional implants placed in the lower jaw (mandible), but without associated crowns or bridges. The bone contrast is moderate, but some details are lost due to general low resolution. No obvious natural tooth roots are visible; the dental arch is predominantly composed of radiopaque implant fixtures. Some posts or abutments may be visible associated with the implants. There is no clear evidence of large radiolucent periapical lesions, though the image quality limits fine-detail assessment. No patient name, date, or identifying text is visible in the scan area.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"Not visible on X-ray; only bone and prosthetic margins can be inferred.\",\n    \"bone_level\": \"Bone levels around implants appear generally maintained but detailed assessment is limited by", "created_at": "2026-04-24T17:53:36.765515", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5238/download", "media_mime_type": "image/jpeg"}, {"id": 18843, "message_id": "ACFEC4CCFFAA90FE937217BE98502F74", "sender": "user", "message_type": "text", "content": "excusez-moi excusez-moi vous m'envoyez un message en arabe et je ne sais pas parler l'arabe parle-moi en français si c'est possible merci d'avance cordialement", "created_at": "2026-04-24T17:53:39.142658", "media_url": null, "media_mime_type": null}, {"id": 18844, "message_id": "bot_ACFEC4CCFFAA90FE937217BE98502F74_368", "sender": "bot", "message_type": "text", "content": "Merci pour votre précision ! Je comprends parfaitement.\n\nJe ne peux malheureusement pas interpréter ou donner un avis médical sur votre radio panoramique. Je vais transmettre votre image et votre demande à notre équipe médicale, qui pourra vous répondre avec tous les détails nécessaires.\n\nPouvez-vous me donner votre nom complet, s’il vous plaît ?", "created_at": "2026-04-24T17:54:01.363059", "media_url": null, "media_mime_type": null}, {"id": 18845, "message_id": "AC32F4E2CF3A1D6DBBD95D52E348F1B1", "sender": "user", "message_type": "text", "content": "je vous remercie d'avance au revoir à bientôt je vous attends", "created_at": "2026-04-24T17:54:35.116580", "media_url": null, "media_mime_type": null}, {"id": 18846, "message_id": "bot_AC32F4E2CF3A1D6DBBD95D52E348F1B1_8218", "sender": "bot", "message_type": "text", "content": "Merci à vous pour votre confiance ! Nous restons à votre disposition et l’équipe médicale vous contactera très bientôt. Bonne journée et à bientôt 😊", "created_at": "2026-04-24T17:54:46.404020", "media_url": null, "media_mime_type": null}, {"id": 18847, "message_id": "ACE15F185B59EA4E8717DEDDFFB3D269", "sender": "user", "message_type": "text", "content": "merci ainsi qu'à vous", "created_at": "2026-04-24T17:55:09.601612", "media_url": null, "media_mime_type": null}, {"id": 18848, "message_id": "bot_ACE15F185B59EA4E8717DEDDFFB3D269_4243", "sender": "bot", "message_type": "text", "content": "Merci beaucoup, à très bientôt et prenez soin de vous ! 😊", "created_at": "2026-04-24T17:55:20.819006", "media_url": null, "media_mime_type": null}, {"id": 18849, "message_id": "AC94200FC796D2F8033D6354895D525A", "sender": "user", "message_type": "text", "content": "merci encore", "created_at": "2026-04-24T17:55:46.700091", "media_url": null, "media_mime_type": null}, {"id": 18850, "message_id": "bot_AC94200FC796D2F8033D6354895D525A_8265", "sender": "bot", "message_type": "text", "content": "Avec plaisir, à votre service ! 😊", "created_at": "2026-04-24T17:55:57.370935", "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 1421 in training_review_items