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": 18908, "message_id": "AC461E7263EBB58470744AA9EF0E6E80", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-04-24T20:17:20.047617", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5251/download", "media_mime_type": "image/jpeg"}, {"id": 18909, "message_id": "AC6CBC8B400DEE757294EFCFDB69E6DB", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-04-24T20:17:20.391252", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5252/download", "media_mime_type": "image/jpeg"}, {"id": 18910, "message_id": "ACD2D4691196F5535F38C8071F2B3C54", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-04-24T20:17:20.859072", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5253/download", "media_mime_type": "image/jpeg"}, {"id": 18911, "message_id": "ACEBF0AA8A8022AB9ADEEE31F7D2E9C3", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-04-24T20:17:21.173017", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5254/download", "media_mime_type": "image/jpeg"}, {"id": 18912, "message_id": "AC32485D57A40FF19D9F55CF4EC92E01", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-04-24T20:17:21.831576", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5255/download", "media_mime_type": "image/jpeg"}, {"id": 18913, "message_id": "AC891987300EA76175466676F84C4874", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-04-24T20:17:22.009276", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5256/download", "media_mime_type": "image/jpeg"}, {"id": 18914, "message_id": "AC5070760CAF82E47A931042BEADC5D8", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"dental_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a dental model made of a yellowish material, representing three posterior teeth in close proximity. The tooth in the center is restored with a shiny metallic crown, showing defined occlusal anatomy and no apparent defects or fractures. The adjacent teeth on both sides are unaltered and also appear to be part of the dental model. The background features a blue and green design, likely a work surface.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"center (likely a molar)\",\n        \"observation\": \"Presence of a full metallic crown covering the tooth. The crown has defined cusps and fissures, and appears well-adapted to the model with no visible defects.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"left adjacent\",\n        \"observation\": \"Tooth appears intact, without restoration, fracture, or visible pathology.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"right adjacent\",\n        \"observation\": \"Tooth appears intact, without restoration, fracture, or visible pathology.\",\n        \"severity_signal\": \"none\"\n      }\n    ],", "created_at": "2026-04-24T20:17:22.385811", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5257/download", "media_mime_type": "image/jpeg"}, {"id": 18915, "message_id": "AC3821CCDC0AEE2E5F984530FDD2D1F3", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"dental_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a close-up of a dental stone model representing a portion of the upper dental arch. The model includes several teeth. One anterior tooth (right lateral incisor or canine) is covered with a green-colored material, possibly wax, resin, or a mock-up for a dental restoration. The adjacent teeth are not covered. The surface texture of the model is matte, and the details of the tooth contours and interdental spaces are clear. The model appears to be segmentable, as one section (containing the green-covered tooth) is detachable. The background is blue, and the model is well-lit.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper_right (likely canine or lateral incisor)\",\n        \"observation\": \"Tooth is covered with green material, possibly a mock-up or wax-up for restorative planning.\",\n        \"severity_signal\": \"unclear\"\n      },\n      {\n        \"location\": \"adjacent front upper teeth\",\n        \"observation\": \"Teeth appear intact in the model. No visible anomalies or defects on stone surfaces.\",\n        \"severity_signal\": \"none\"\n      }\n    ],\n    \"gum_condition", "created_at": "2026-04-24T20:17:22.639212", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5258/download", "media_mime_type": "image/jpeg"}, {"id": 18916, "message_id": "ACCB4E183E1DC18A52EBD6B815DAC0C7", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"object\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a dental model made from a light brownish cast material. On this model, there are three adjacent green wax shapes placed on top of three of the casted teeth. The green wax structures are well-adapted and cover the occlusal surfaces. The cast model features roots and tooth anatomy but is not a real mouth; it's an impression model used in dental laboratories. The background is out of focus and appears bluish. No natural tissues, restorations, or gum tissues are visible. No text or numbers are visible in the image.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": null,\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": null,\n    \"alignment\": null,\n    \"calculus_plaque\": null,\n    \"periapical_areas\": null,\n    \"other_findings\": null\n  },\n  \"text_visible\": [],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"The image shows a dental", "created_at": "2026-04-24T20:17:22.919386", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5259/download", "media_mime_type": "image/jpeg"}, {"id": 18917, "message_id": "AC4786C8DAF0066BA0478589CEA5934A", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"object\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a close-up view of a dental model or dental prosthesis held between two fingers. The model consists of what appear to be artificial teeth made from a gray-colored material attached to a gum-colored (pinkish-beige) base that simulates the gums. The teeth are anatomically shaped and aligned in an arch form. The surface of the teeth shows some texture and minor irregularities, likely from the molding or finishing process. No text, numbers, or labels are visible on the object. The image is well-lit, and the focus is clear, allowing details of both the artificial teeth and the gum base to be seen. There are no indications of this being a live clinical photo, but rather a manmade dental model or prototype.\",\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  \"possible_concerns\":", "created_at": "2026-04-24T20:17:23.400379", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5260/download", "media_mime_type": "image/jpeg"}, {"id": 18918, "message_id": "ACF4650B5E1BC1A2BF4EAE3EACAE594E", "sender": "user", "message_type": "text", "content": "Je suis prothésiste dentaire et diplômée de troisième année du Groupe AGodent. J'ai de l'expérience en prothèses dentaires céramiques et je souhaite approfondir mes compétences dans ce domaine, notamment en numérique. Je souhaiterais savoir s'il serait possible d'effectuer un stage au sein de votre équipe afin d'acquérir de l'expérience et de perfectionner mes connaissances.\n\nMerci beaucoup pour votre temps", "created_at": "2026-04-24T20:17:30.919718", "media_url": null, "media_mime_type": null}, {"id": 18922, "message_id": "bot_ACF4650B5E1BC1A2BF4EAE3EACAE594E_6050", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre message et votre intérêt ! Je transmets immédiatement votre demande à notre équipe, ils reviendront vers vous très prochainement إن شاء الله 🙏🏻", "created_at": "2026-04-24T20:18:49.962769", "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 1432 in training_review_items