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": 8721, "message_id": "3AC243A6C049DF4D588F", "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 side profile of a young person with short brown hair, wearing a light grey hooded jacket. The individual is smiling gently. The ear, cheek, jawline, and profile of the nose and lips are clearly visible. The background consists of a wooden surface with a natural brown grain pattern. There are no additional objects or visible context elements (such as dental or medical instruments) suggesting a clinical environment.\",\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  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"There are no notable concerns observed in this extraoral profile photograph.\"\n  },\n  \"urgent_flags\": {\n    \"needs_urgent_human_review\": false,\n    \"signals\": []\n  },", "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": "```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows the profile (side view) of a young person facing to the right. The individual has light to medium skin, short brown hair that is slightly tousled, and is wearing a grey hooded jacket. The background consists of a wooden surface with a medium brown color and visible grain patterns. The individual’s ear, jawline, neck, and a portion of the face, including the nose and eye, are clearly visible. The lips are closed and the expression appears neutral. No dental or intraoral structures are visible, and no apparent facial swelling, trauma, or significant skin lesions are present. There are some small skin marks or freckles visible on the cheek and neck.\",\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\": \"not visible\",\n    \"alignment\": \"not visible\",\n    \"calculus_plaque\": \"not visible\",\n    \"periapical_areas\": \"not visible\",\n    \"other_findings\": \"none\"\n  },\n  \"text_visible\": [],\n  \"possible", "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": "```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a young person facing forward, smiling gently. The individual has short, wavy, brown hair and is wearing a gray jacket zipped up to the neck. The background consists of a wooden panel with a vertical grain. The person's teeth are visible in a natural smile. The skin tone appears even, and there are no obvious facial injuries or abnormalities. The photo is well-lit and in focus.\",\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  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"No notable concern observed in the context of this extraoral facial image. The person appears healthy, with a natural smile and no visible dental or facial pathology.\"\n  },\n  \"urgent_flags\": {\n    \"needs_", "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": "```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a side profile view of a young individual with short, dark, wavy hair. The person is looking to the left side of the image. They are wearing a grey jacket with a visible collar and hood, and a light blue shirt underneath. The background is a wooden surface with a clear, vertical grain pattern. Facial features, neck, and ear are visible. The lips are closed, and the head posture appears neutral, with no obvious asymmetry or swelling noted. No visible dental or intraoral elements are present.\",\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\": \"No notable concern observed in this extraoral profile photograph;", "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": "```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a young person standing in front of a wooden background. The individual has short to medium length, dark brown hair that is slightly tousled and is wearing a light grey zip-up hoodie with a visible black Jordan logo on the left side of the chest. The person is facing forward with a neutral expression. The photo is well-lit and in focus, with no visible signs of blur or obstruction. There are no visible dental or medical devices, and the context appears to be non-clinical.\",\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\": [\"Jordan logo\"],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"No notable concerns observed; image context is extraoral and non-dental", "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": "```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image depicts a young woman facing the camera with a visible smile. The background is a vertical wooden panel that covers the entire frame. She has her hair braided over her right shoulder, is wearing a black shirt, a light-colored cardigan, and a double-strand necklace with small beads. Her teeth are visible in her smile. The lighting appears even and there are no major obstructions or image quality issues.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Teeth appear generally healthy and present. Noticeable misalignment and crowding of the upper front teeth, slight overlap is visible. Color is consistent, without obvious signs of major staining or decay.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Lower front teeth are visible with some minor irregularity in alignment, but all teeth appear to be present.\",\n        \"severity_signal\": \"mild\"\n      }\n    ],\n    \"gum_condition\": \"Gum tissue is only partially visible, but appears pink and without obvious swelling or redness in the visible regions.\",\n    \"bone_level\":", "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": "```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a young person in a profile (side) view facing left. The individual has medium to dark brown skin, dark hair styled in a tightly braided ponytail, and is wearing small stud earrings. The person is dressed in a black top with a light gray textured garment draped over the shoulders. The background is a flat, smooth wooden panel with a natural grain pattern. The person's expression is neutral; no visible dental or oral structures are exposed. No dental or medical instruments or context are present.\",\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  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"No notable or concerning findings are visible in this profile photograph.\"\n  },\n  \"urgent_flags\": {\n    \"", "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": "```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a side profile view of a young adult female with a medium skin tone, standing in front of a wooden background, likely a door. Her hair is neatly tied back into a braid and she is wearing a grey textured cardigan over a dark top. She has a stud earring in her visible ear and is wearing two necklaces, one of which is beaded. The background is plain and there are no visible dental, oral, or medical instruments or settings.\",\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  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"No notable concerns are observed in the context of this extraoral person photo. There are no visible injuries, asymmetries, or medical devices.\"", "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": "```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a young female presenting in front of a wooden-panel background. She is facing forward and looking straight at the camera. She has medium skin tone, dark eyes, and thick eyebrows. Her hair is neatly parted in the center and styled in a side braid that falls over her right shoulder. She is wearing a black ribbed shirt, a light-colored cardigan, and a delicate layered necklace. The lighting is even, and her facial expression is neutral. There is a visible reddish area, likely a bump or lesion, on her mid-forehead. No dental context or clinical instruments are visible.\",\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\": \"Reddish, raised mark or swelling on the mid-forehead. Etiology unclear (e", "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}, {"id": 8733, "message_id": "3A9892D79F83D0E8EFE2", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio:\n\n**Arabic Script:**\n\"شوفي هاد الروب غايحمقك والله\"\n\n**Latin Script:**\n\"Shoufi had er-rob ghay7emqek wallah\"\n\n**Translation (for context):**\n\"Look at this dress, you're going to love it, I swear.\"", "created_at": "2026-03-30T10:47:47.348858", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1914/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8734, "message_id": "bot_3A9892D79F83D0E8EFE2_4978", "sender": "bot", "message_type": "text", "content": "كنعتدر، الرسالة الصوتية اللي رسلتو ما فيها حتى شي سؤال أو طلب متعلق بخدمات الأسنان أو المواعيد. واش كاين شي حاجة معينة بغيتي تعرفيها على Centre Dentaire Tanger Bay أو محتاجة شي مساعدة طبية؟ 😊", "created_at": "2026-03-30T10:48:10.619359", "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 451 in training_review_items