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": 38892, "message_id": "3EB0574FE5AD7E1CC9090D", "sender": "bot", "message_type": "image", "content": " ", "created_at": "2026-06-04T13:32:27.103473", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10813/download", "media_mime_type": "image/jpeg"}, {"id": 38893, "message_id": "3EB0B6BDDE26869ED95D83", "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 an intraoral photo showing the upper dental arch and palate using cheek retractors. Multiple natural teeth are present across all visible quadrants, with some restored molars visible on both left and right sides. Dental fillings of amalgam (metallic) are clearly visible on at least two upper molars (left and right posterior). Tooth surfaces appear generally clean. The gingival tissue appears pale pink and even in color. The palatal mucosa is also visible and mostly healthy appearing.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_right_posterior\",\n        \"observation\": \"Presence of a large amalgam (silver) restoration on a molar; visible grooves and fissures on other teeth appear intact.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"upper_left_posterior\",\n        \"observation\": \"Presence of amalgam (silver) restoration on a molar; other molars appear intact and functional.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Anterior teeth visible and generally intact, with no", "created_at": "2026-06-04T13:32:54.179343", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10814/download", "media_mime_type": "image/jpeg"}, {"id": 38894, "message_id": "3EB0B582F8490C7A73F610", "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 an intraoral clinical photograph showing the mandibular (lower) arch of an adult patient. The image includes the lower anterior teeth as well as both left and right posterior segments. A lip and cheek retractor is being used for visibility. Multiple teeth exhibit extensive carious lesions with significant loss of tooth structure. There are multiple metallic and composite restorations noted on the left side. Some teeth appear fractured or broken down to the gumline, and there is an obviously unrestored area with likely gross decay or possible retained roots in the posterior right quadrant. Gums generally appear pink but there is mild localized redness adjacent to several affected teeth. Mild dental plaque is visible in some areas. Several teeth appear missing, particularly in the right posterior quadrant. The anterior teeth are present and generally appear intact.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"lower_left_posterior\",\n        \"observation\": \"Multiple teeth present with restorations, some with extensive dark carious lesions and old metallic/amalgam fillings. Two molars have gold or metal inlays or onlays.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\":", "created_at": "2026-06-04T13:33:24.775727", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10815/download", "media_mime_type": "image/jpeg"}, {"id": 38895, "message_id": "3EB05C9EC64B3F6EFAD0B0", "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 an intraoral clinical photograph showing the anterior and some posterior teeth of an adult patient. A cheek retractor is in place to provide clear visualization of the teeth and gums. The upper and lower front teeth are visible, as well as parts of the premolars and molars on the sides. The upper teeth appear generally lighter than the lower teeth, which show notable yellow-brown discoloration, particularly on the cervical and interproximal areas. There is visible plaque or calculus accumulation, especially on the lower anterior teeth. The gum tissue appears pink but there is mild erythema (redness) in some areas, more pronounced in the lower front region. Tooth alignment is irregular, especially in the lower anterior segment where there is crowding and mild rotation. Some posterior teeth in the right and left quadrants appear partially visible and may show signs of restoration or decay, but evaluation is limited by the angle. No overt signs of gross caries or fracture are visible in the anterior teeth.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Upper anterior teeth appear relatively intact, some mild yellow discoloration and transluc", "created_at": "2026-06-04T13:33:36.304316", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10816/download", "media_mime_type": "image/jpeg"}, {"id": 38896, "message_id": "3EB0C6FE09E6EFE02E6DC2", "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 an intraoral clinical photograph showing both the upper and lower anterior and premolar teeth with a cheek and lip retractor in place. The lips are parted, and the gingiva and teeth are clearly visible. There is visible staining and moderate calculus deposit, especially on the lower front teeth. The gum tissue appears pink, with some areas of mild redness near the lower incisors. Several molars on both sides appear restored with crowns (likely ceramic or metal-ceramic), and there is visible wear and chipping on some anterior teeth. The teeth display a yellowish coloration, particularly at the cervical margins. Mild irregular crowding is present in the lower front teeth. \"\n  ,\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Visible moderate calculus accumulation and staining on the lower incisors with overlapping/crowding of the teeth. Tooth surfaces appear worn.\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Teeth present with yellowish discoloration, some surfaces show translucency and mild wear. No obvious caries or major", "created_at": "2026-06-04T13:33:57.307964", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10817/download", "media_mime_type": "image/jpeg"}, {"id": 40493, "message_id": "AC3BDA7EC76BE61B089AFA593A054ED9", "sender": "user", "message_type": "text", "content": "https://www.facebook.com/share/v/1CfgxXJjVn/", "created_at": "2026-06-08T16:59:28.947509", "media_url": null, "media_mime_type": null}, {"id": 40494, "message_id": "ACEDC43CA47A24BC39DB37969A889B0C", "sender": "user", "message_type": "text", "content": "https://www.facebook.com/share/v/18tz8xh4p9/", "created_at": "2026-06-08T16:59:29.475961", "media_url": null, "media_mime_type": null}, {"id": 40495, "message_id": "AC7BAFBB12CE592303189BE6E99010DE", "sender": "user", "message_type": "text", "content": "https://www.facebook.com/share/r/18pvK8JKJv/", "created_at": "2026-06-08T16:59:29.547762", "media_url": null, "media_mime_type": null}, {"id": 40497, "message_id": "bot_AC7BAFBB12CE592303189BE6E99010DE_8229", "sender": "bot", "message_type": "text", "content": "شكرا بارك الله فيك على الصور والفيديوهات اللي رسلتي.", "created_at": "2026-06-08T17:00:10.174919", "media_url": null, "media_mime_type": null}, {"id": 40498, "message_id": "bot_AC7BAFBB12CE592303189BE6E99010DE_7405", "sender": "bot", "message_type": "text", "content": "بالنسبة للتشخيص الدقيق أو أي اقتراح للعلاج، خاص Dr Haitham Boutaib يشوف الحالة مباشرة أو على الأقل يشوف radio panoramique باش يعطيكوم رأي طبي مضبوط.", "created_at": "2026-06-08T17:00:10.234013", "media_url": null, "media_mime_type": null}, {"id": 40499, "message_id": "bot_AC7BAFBB12CE592303189BE6E99010DE_5269", "sender": "bot", "message_type": "text", "content": "إذا محتاجين consultation أو عندكوم شي سؤال محدد على العلاج أو الخدمة اللي باغيين، قولو لي شنو محتاجين بالضبط ومرحبا نعاونكوم.", "created_at": "2026-06-08T17:00:10.285249", "media_url": null, "media_mime_type": null}, {"id": 40500, "message_id": "bot_AC7BAFBB12CE592303189BE6E99010DE_8993", "sender": "bot", "message_type": "text", "content": "واخا تعطيني الإسم الكامل ديالكوم باش نسجل الطلب ديالكوم ونبلغ الفريق يتواصلوا معكوم؟", "created_at": "2026-06-08T17:00:10.342424", "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 3287 in training_review_items