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": 7950, "message_id": "3A132E7B180B72673749", "sender": "user", "message_type": "image", "content": "[Image analysis] [Image analysis failed]", "created_at": "2026-03-28T10:04:56.672614", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1681/download", "media_mime_type": "image/jpeg"}, {"id": 7951, "message_id": "3AD9327981F917C07C3E", "sender": "user", "message_type": "image", "content": "[Image analysis failed]", "created_at": "2026-03-28T10:04:57.359593", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1682/download", "media_mime_type": "image/jpeg"}, {"id": 7952, "message_id": "3AC34D1AB2B7467EC11E", "sender": "user", "message_type": "text", "content": "Saredom n hadik li hedarena m3aha dik nehar", "created_at": "2026-03-28T10:05:12.397300", "media_url": null, "media_mime_type": null}, {"id": 7964, "message_id": "A57CDEF9B5AE10582EAF97D813E352FB", "sender": "bot", "message_type": "text", "content": "Ok", "created_at": "2026-03-28T10:17:02.828531", "media_url": null, "media_mime_type": null}, {"id": 13802, "message_id": "A542C36F2CAB825602C2F7123037850F", "sender": "bot", "message_type": "text", "content": "Rib Ettijari wafabank : 007 825 0006554300401057 18", "created_at": "2026-04-10T18:36:06.829052", "media_url": null, "media_mime_type": null}, {"id": 14864, "message_id": "4A349931585F5CA71C97", "sender": "user", "message_type": "text", "content": "Type de traitement : Traitement orthodontique global par appareillage fixe multi-attaches bimaxillaire (approche sans extractions privilégiée).\r\n\r\nObjectifs et Étapes Thérapeutiques :\r\n\r\nAlignement et Nivellement : Pose de l'appareillage fixe bimaxillaire pour la correction des axes dentaires et la gestion de la proalvéolie.\r\n\r\nCorrection du Décalage Sagittal (Classe II) : Réduction du surplomb antérieur (Overjet) et recul du secteur incisif supérieur pour protéger le parodonte et prévenir les traumatismes incisifs. Coordination des arcades (nécessitant potentiellement le recours à des élastiques intermaxillaires ou une mécanique de recul).\r\n\r\nFinition et Occlusion : Établissement d'une occlusion fonctionnelle stable (objectif de Classe I canine) et optimisation de l'esthétique du sourire (réduction de l'exposition gingivo-incisive).\r\n\r\nContention : Dépose de l'appareillage actif et mise en place d'un système de contention (arcs collés et/ou gouttières thermoformées) au maxillaire et à la mandibule afin de garantir la pérennité du traitement et d'éviter les récidives.", "created_at": "2026-04-13T13:39:20.184787", "media_url": null, "media_mime_type": null}, {"id": 14878, "message_id": "4A11C6C140E18AF1BA16", "sender": "user", "message_type": "text", "content": "Objet : Note justificative concernant la dent pilier 22 (Dossier N° 134914528)\nÀ l'attention du Médecin Contrôleur,\nDans le cadre du dossier de remboursement pour la prothèse fixe (bridge de 11 à 22) de la patiente JEMOUD FATIMA EZZAHRA, je vous apporte les précisions cliniques suivantes concernant l'absence de traitement endodontique sur la dent 22 :\n• Préservation de la vitalité : La dent 22 est une dent saine et vitale. Compte tenu du jeune âge de la patiente et de son excellente hygiène bucco-dentaire, j’ai opté pour une approche conservatrice afin de préserver la vitalité pulpaire.\n\n• État clinique : La taille a été réalisée sous irrigation abondante avec une protection dentinaire immédiate, ne présentant aucune symptomatologie post-opératoire.\n\nJe reste à votre disposition pour tout complément d'information.", "created_at": "2026-04-13T13:58:03.211674", "media_url": null, "media_mime_type": null}, {"id": 16867, "message_id": "4AA28D49AF78ECF6A8C3", "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 printed or digital analysis sheet titled 'WebCeph Analysis.' The document summarizes cephalometric results in a tabular format, which includes parameters under three main headings: Skeletal, Dental, and Soft-tissue. Each row lists a parameter, its Mean, S.D. (standard deviation), Result, Severity, a polygonal chart visual summary, and a column titled 'Meaning' interpreted in color-coded text (red for abnormal findings and green for normal findings). The table is detailed, spanning about 30+ parameters. No patient-identifiable information or dates are visible. The readings are numeric, with graphical and interpretive elements.\",\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    \"WebCeph Analysis\",\n    \"SKELETAL\",\n    \"SNA\", \"SNB\", \"ANB\n\nUser message context: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a digital document labeled 'WebCeph Analysis' presenting orthodontic/cephalometric measurements and results. The document contains a table organized by categories: Skeletal, Dental, and Soft-tissue parameters. Columns show Mean, S.D. (standard deviation), Result, Severity, Polygonal chart (with a visual red line graph per parameter), and Meaning (interpretation). Data entries are color-coded: abnormal findings in red, normal values in green. The chart visualizes deviations from norms, highlighting certain values outside the normal range. No identifiable patient data is visible. The report appears to be a cephalometric analysis summary typically used for orthodontic case evaluation.\",\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    \"WebCeph Analysis\",\n    \"SKELETAL\",\n    \"SNA\",\n    \"SN", "created_at": "2026-04-16T15:49:37.011950", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4513/download", "media_mime_type": "image/jpeg"}, {"id": 16868, "message_id": "3A02206FC8D323AF90BD", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image presents a traced lateral cephalometric radiograph analysis generated with 'WebCeph Analysis.' The tracing shows both the skeletal and dental anatomical landmarks of a patient's lateral skull view with multiple angle and length measurements marked in red and green. The left side shows a list of cephalometric variables—skeletal, dental, and soft-tissue—with corresponding angles, planes, and indices; numbers and symbols on the tracing correspond to these measurements. There are no obvious artifacts or obstructions. No soft tissue, caries, or alveolar bone structures are visible as this is a ceph tracing, not a raw X-ray.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Incisor position indicated by cephalometric landmarks; no visible pathology\",\n        \"severity_signal\": \"unclear\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Lower incisor position indicated by cephalometric landmarks; no visible pathology\",\n        \"severity_signal\": \"unclear\"\n      }\n    ],\n    \"gum_condition\": \"Not visible in this cephalometric tracing image\",", "created_at": "2026-04-16T15:49:48.315189", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4514/download", "media_mime_type": "image/png"}, {"id": 16878, "message_id": "bot_3A02206FC8D323AF90BD_191", "sender": "bot", "message_type": "text", "content": "Je comprends, vous souhaitez faire suivre tous ces documents et analyses à la personne avec qui vous aviez échangé lors de votre dernier contact. Votre demande, ainsi que les justificatifs et images envoyés, ont bien été transmis à notre équipe. Ils vont vous recontacter très bientôt إن شاء الله 🙏🏻", "created_at": "2026-04-16T15:50:23.223261", "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 1269 in training_review_items