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": 39267, "message_id": "3EB009794AB14D8370A7B5", "sender": "bot", "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 high-quality intraoral clinical photo showing the mandibular (lower) arch. The lower teeth are cleanly visible from first molar to first molar on both left and right sides. The tongue and gingival tissues are visible. Cheek retractors are in use, facilitating full view of the arch. There is good lighting, color accuracy, and minimal glare.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"lower_right_molars\",\n        \"observation\": \"Multiple teeth exhibit large amalgam restorations on occlusal surfaces; one molar shows evidence of substantial cavity preparation and darkened area under the restoration, indicative of restoration breakdown or recurrent decay.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"lower_left_molars\",\n        \"observation\": \"Two molars have moderate-sized amalgam fillings on the occlusal surface; the fillings appear intact.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"lower_premolars\",\n        \"observation\": \"Enamel appears intact with shallow fossae and grooves without obvious caries", "created_at": "2026-06-05T10:52:47.500450", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10929/download", "media_mime_type": "image/jpeg"}, {"id": 39268, "message_id": "3EB03CA3590184BB5D4F4B", "sender": "bot", "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 high-quality intraoral photo showing both the maxillary (upper) and mandibular (lower) arches with the mouth open. A cheek retractor is in use, providing a clear, unobstructed view. All visible teeth appear generally intact. The gum/mucosa tissue appears with a healthy pink coloration; no prominent redness, swelling or lesions are visible. The teeth are generally light in color, with minimal extrinsic staining. The lower left first molar and lower right first molar show some discoloration that could be due to staining or restoration. The front teeth exhibit slight alignment irregularities.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Teeth are intact, light cream shade, minor incisal wear, no obvious fractures or major discoloration.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Teeth are intact, slight incisal chipping, minor overlapping/incisor crowding, light shade.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"lower_left_first_m", "created_at": "2026-06-05T10:53:01.973946", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10930/download", "media_mime_type": "image/jpeg"}, {"id": 39269, "message_id": "3EB0C07C5BEF2768C0008F", "sender": "bot", "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 high-resolution intraoral photograph focusing on the anterior teeth and surrounding gum tissue. The mouth is open, showing both the upper and lower arches from canine to canine. All visible teeth appear clean, with no obvious caries, cracks, or significant stains. The gum tissue is pink, firm, and stippled, with no overt swelling, recession, or redness. There is a slight overlap of the lower right lateral incisor behind the upper anterior teeth, suggesting mild dental crowding. The bite appears to be a normal overjet and overbite, with the upper incisors overlapping the lower incisors. No restorations, prostheses, orthodontic appliances, or calculus deposits are visible.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Upper central and lateral incisors are present, with no visible decay or significant staining, and have a smooth surface.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Lower incisors are present, with slight overlap of the right lateral incisor, crowns appear intact, no visible caries or", "created_at": "2026-06-05T10:53:19.294929", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10931/download", "media_mime_type": "image/jpeg"}, {"id": 39273, "message_id": "3A744D188BC86032A6BB", "sender": "user", "message_type": "text", "content": "It’s the Xray I really need to show the crack 🙏", "created_at": "2026-06-05T11:04:21.972455", "media_url": null, "media_mime_type": null}, {"id": 39276, "message_id": "3EB0C6A3CB96C6FF9F1BF1", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a digital panoramic dental X-ray (orthopantomogram). The entire maxilla and mandible are visible along with the maxillary sinuses, mandibular condyles, and surrounding bone structures. All teeth are visible except for the upper and lower left and right third molars, which appear to be missing or impacted. Several metallic dental restorations are seen, including crowns and/or large fillings present in the upper right and lower left posterior regions. Bone structures appear to have preserved density, without obvious severe bone loss. There are two radiopaque circular objects positioned laterally outside the dental arches on both the left and right, possibly ear or head-positioning markers. Some mild to moderate variations in crown-root morphology are visible. No obvious periapical radiolucencies or large lesions are present. The image displays a ruler scale on the right margin.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_right_posterior\",\n        \"observation\": \"Presence of large metallic restoration (crown or large filling) on one or more molars. Adjacent teeth appear normal in shape and radiodensity.\",\n        \"severity_signal\": \"", "created_at": "2026-06-05T11:07:29.892775", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10932/download", "media_mime_type": "image/jpeg"}, {"id": 39277, "message_id": "3A118335BD3039AB7A44", "sender": "user", "message_type": "text", "content": "🙏", "created_at": "2026-06-05T11:07:48.853744", "media_url": null, "media_mime_type": null}, {"id": 42752, "message_id": "A5A0E3EAAA168780FF066F8D816CA25E", "sender": "bot", "message_type": "text", "content": "Good morning", "created_at": "2026-06-13T11:00:03.568749", "media_url": null, "media_mime_type": null}, {"id": 42756, "message_id": "A5E39CB849ED4439562115980727E6DD", "sender": "bot", "message_type": "text", "content": "How are we", "created_at": "2026-06-13T11:00:10.444178", "media_url": null, "media_mime_type": null}, {"id": 43951, "message_id": "3A58A25A0A2CAEE270CA", "sender": "user", "message_type": "text", "content": "Good afternoon. Everything is good! No pain, no sensitivity and good bite. 😊", "created_at": "2026-06-15T18:25:17.226334", "media_url": null, "media_mime_type": null}, {"id": 43952, "message_id": "bot_3A58A25A0A2CAEE270CA_188", "sender": "bot", "message_type": "text", "content": "That’s wonderful to hear! 😊 If you need anything or have any questions, feel free to let us know.", "created_at": "2026-06-15T18:25:52.665217", "media_url": null, "media_mime_type": null}, {"id": 43953, "message_id": "3ABC7BE90B3ABA201750", "sender": "user", "message_type": "text", "content": "🙏👍", "created_at": "2026-06-15T18:27:29.940049", "media_url": null, "media_mime_type": null}, {"id": 43954, "message_id": "bot_3ABC7BE90B3ABA201750_7412", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻", "created_at": "2026-06-15T18:27:43.078562", "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 3644 in training_review_items