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": 8719, "message_id": "3ACAA807C002EB2B1063", "sender": "user", "message_type": "image", "content": "```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a person in a right-facing profile view. The individual appears to be smiling, and only the right side of the face is visible. The hair is tied back and appears neat. The person has pierced ears with two earrings visible: one small stud and one larger pearl-like earring. The person is wearing a dark top with a light, textured fabric draped over the shoulders, and two necklaces, one featuring small colored beads. The background is a vertical wooden panel with natural wood grain. The lighting is even, and the image is clear. Teeth are partially visible due to the smile, showing the anterior part of the dental arch, but not in sufficient detail for clinical dental evaluation.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"not clearly visible\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"not assessable\",\n    \"alignment\": \"not assessable\",\n    \"calculus_plaque\": \"not visible\",\n    \"periapical_areas\": null,\n    \"other_findings\": \"No intraoral or detailed dental structures visible due", "created_at": "2026-03-30T10:40:55.870905", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1901/download", "media_mime_type": "image/jpeg"}, {"id": 8720, "message_id": "3A5725124B568DF7A362", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-03-30T10:40:56.228519", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1902/download", "media_mime_type": "image/jpeg"}, {"id": 8721, "message_id": "3AC243A6C049DF4D588F", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-03-30T10:40:56.356664", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1903/download", "media_mime_type": "image/jpeg"}, {"id": 8722, "message_id": "3ADB348C3E8C7D98A82E", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-03-30T10:40:56.582873", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1904/download", "media_mime_type": "image/jpeg"}, {"id": 8723, "message_id": "3AA7AFA5AD99F8062B68", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-03-30T10:40:56.863539", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1905/download", "media_mime_type": "image/jpeg"}, {"id": 8724, "message_id": "3A1F856D3DDCCFAF8930", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-03-30T10:40:57.676392", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1906/download", "media_mime_type": "image/jpeg"}, {"id": 8725, "message_id": "3AA5BAB2080C19AF03C2", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-03-30T10:40:57.899480", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1907/download", "media_mime_type": "image/jpeg"}, {"id": 8726, "message_id": "3AA33FDBC7D41CBE2A53", "sender": "user", "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 shows a young person, photographed from the front with a neutral wooden background. The person has dark hair tied in a braid over the right shoulder, is wearing a black shirt, a light beige sweater, a delicate necklace, and small earrings. The individual is smiling with teeth visible. The smile line is curved and reveals both upper and lower teeth, allowing observation of alignment and color. The gingival (gum) line is partially visible in the upper jaw. There is good lighting; facial features, teeth, and smile are all clearly visible.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Visible teeth appear to have yellowish discoloration. Slight irregularity in the alignment of upper front teeth; spacing or midline shift may be noted.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Lower front teeth are visible, with crowding apparent. No obvious large restorations visible.\",\n        \"severity_signal\": \"mild\"\n      }\n    ],\n    \"gum_condition\": \"Gums appear pink and healthy where visible, with", "created_at": "2026-03-30T10:40:58.121568", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1908/download", "media_mime_type": "image/jpeg"}, {"id": 8727, "message_id": "3AA6893EF0496E64AE92", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a person photographed from the left profile against a wood-paneled background. The individual has dark hair that is neatly parted and styled into a long braid which hangs over the shoulder. The person is wearing a black top with a light gray textured garment draped over the shoulders. The ear is adorned with two small, round earrings. The person appears to have a neutral or slightly serious expression. No dental or oral structures are visible as the mouth is closed and the photograph is not focused on dental features. The face, ear, and hair are the most prominent details. No visible text, labels, or documents are present 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\": {", "created_at": "2026-03-30T10:40:58.367078", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1909/download", "media_mime_type": "image/jpeg"}, {"id": 8728, "message_id": "3AD7BF82DDF39153D2D7", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a person photographed in profile view (right side), standing in front of a wooden wall. The individual has medium to dark skin, dark hair neatly pulled back, and braided with a section visible down their back. They are wearing a grey textured cardigan over a dark shirt, a beaded necklace with multicolored beads, and a stud earring in the visible ear. No visible dental or medical context is present in this image, and the individual's mouth is closed. The lighting is uniform, and the image is clear. A black door handle is visible in the lower left corner.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"not visible\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"unclear\",\n    \"alignment\": \"not visible\",\n    \"calculus_plaque\": \"not visible\",\n    \"periapical_areas\": \"not visible\",\n    \"other_findings\": \"none\"\n  },\n  \"text_visible\": [],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\":", "created_at": "2026-03-30T10:40:58.619290", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1910/download", "media_mime_type": "image/jpeg"}, {"id": 8729, "message_id": "3A997F27182445D45416", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a young woman standing in front of a plain wooden background. She is facing directly toward the camera with a neutral facial expression. Her dark hair is parted in the middle and styled into a braid that is draped over her right shoulder. She is wearing a black ribbed top, a light gray textured sweater or cardigan, and a delicate gold necklace with a drop pendant. She also has small stud earrings. There is a visible slightly reddish or shiny area on the center of her forehead, which might be due to a skin condition or minor irritation. No dental or oral features are visible. The lighting is even and the image is clear.\",\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\": [\n    {\n      \"concern\": \"There is a visible reddish or shiny area on the center", "created_at": "2026-03-30T10:40:58.878010", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1911/download", "media_mime_type": "image/jpeg"}, {"id": 8730, "message_id": "bot_3A997F27182445D45416_2632", "sender": "bot", "message_type": "text", "content": "شكرا على الصور اللي رسلتوهوم 🙏🏻\n\nمن خلال الصورة اللي فيها الإبتسامة، باين الأسنان الأمامية كاملة، كاين شوية إصفرار خفيف وعدم انتظام بسيط فالأسنان الفوقانيين، وزحمة خفيفة فالأسنان السفليين. اللثة باينة مزيانة وما كاين حتى مشكل واضح.\n\nهذا غير ملاحظة أولية من الصور، ماشي تشخيص نهائي — الدكتور خاصو يشوف الحالة مباشرة باش يعطيكم التشخيص والخطة المناسبة.\n\nواش بغيتو شي موعد consultation مع Dr Haitham Boutaib باش يشوف الحالة ديالكوم عن قرب ويقترح عليكم الحلول الممكنة؟ 😊", "created_at": "2026-03-30T10:42:49.631902", "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 450 in training_review_items