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": 32944, "message_id": "meta_495384013668010_wamid.HBgLMzQ2MjA2NjI2MTkVAgASGCBBQ0JGNzBGRDdCOTI3QzlBMjkwOTY4MzM3QzM4QkUxMwA=", "sender": "user", "message_type": "text", "content": "Slam", "created_at": "2026-05-20T13:26:07.098760", "media_url": null, "media_mime_type": null}, {"id": 32945, "message_id": "bot_meta_495384013668010_wamid.HBgLMzQ2MjA2NjI2MTkVAgASGCBBQ0JGNzBGRDdCOTI3QzlBMjkwOTY4MzM3QzM4QkUxMwA=_1449", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Tanger Bay وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-05-20T13:26:18.845915", "media_url": null, "media_mime_type": null}, {"id": 32946, "message_id": "meta_495384013668010_wamid.HBgLMzQ2MjA2NjI2MTkVAgASGCBBQzg0RTMyMUIyOTA5QkMyRjJDNTcxREU3QkQ5NjNFRQA=", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a panoramic dental X-ray showing the entire upper and lower jaws, maxillary sinuses, and temporomandibular joints. The upper jaw shows the presence of five dental implants in the anterior to premolar areas, supporting what appears to be a full-arch fixed prosthesis. The prosthesis is visible as a radioopaque structure extending from the upper right to the upper left side. In the lower jaw, multiple natural teeth are present in the anterior and premolar areas with evident root structure. There appear to be several dental crowns in the lower anterior and premolar regions. Posterior areas in both jaws seem missing multiple teeth. No obvious large radiolucent lesions or gross bone pathology is immediately visible. The bone structure appears fairly well defined around the implants and natural teeth, with notable crestal bone loss in some regions. No significant periapical dark zones are apparent around the remaining lower teeth. The maxillary sinuses and surrounding bone appear within normal radiographic limits. The right and left condyles are visible. An 'L' marker is present in the lower right corner of the film.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"\n\nUser message context: ```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a panoramic dental X-ray showing both the maxilla and mandible. In the maxillary (upper jaw) region, there are multiple dental implants present, with four clear implant fixtures visible in the anterior and premolar areas. These implants appear to support a fixed prosthesis or bridge; the superstructure is visible connecting the implants. The natural maxillary teeth are absent, indicating full edentulism in the upper jaw. In the mandible (lower jaw), multiple teeth are present, notably the anterior and premolar regions, and these appear restored with crowns or possibly a fixed bridge. Some teeth show radiopaque coverage consistent with crowns. There is one prominent circular radiopaque object visible in one of the lower anterior teeth, suggestive of a post or restoration. The bone height around the mandibular teeth and implants seems generally preserved, with no gross evidence of severe vertical bone loss. No obvious periapical radiolucency or major pathology is visible at first glance. The sinus and surrounding facial structures appear unremarkable. No patient-identifying text or date is visible on the X-ray.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\":", "created_at": "2026-05-20T13:27:04.340329", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9462/download", "media_mime_type": "image/jpeg"}, {"id": 32947, "message_id": "bot_meta_495384013668010_wamid.HBgLMzQ2MjA2NjI2MTkVAgASGCBBQzg0RTMyMUIyOTA5QkMyRjJDNTcxREU3QkQ5NjNFRQA=_3849", "sender": "bot", "message_type": "text", "content": "توصلت بالصورة ديال الراديو panoramique ديال الأسنان ديالك.", "created_at": "2026-05-20T13:27:29.832766", "media_url": null, "media_mime_type": null}, {"id": 32948, "message_id": "bot_meta_495384013668010_wamid.HBgLMzQ2MjA2NjI2MTkVAgASGCBBQzg0RTMyMUIyOTA5QkMyRjJDNTcxREU3QkQ5NjNFRQA=_8487", "sender": "bot", "message_type": "text", "content": "واش ممكن توضح ليا شنو بالضبط السؤال أو الخدمة اللي محتاجها بخصوص هاد الراديو؟ إذا عندك شي استفسار معين أو محتاج توصل الصورة للفريق الطبي، قولّي فقط 😊", "created_at": "2026-05-20T13:27:29.895335", "media_url": null, "media_mime_type": null}, {"id": 32949, "message_id": "meta_495384013668010_wamid.HBgLMzQ2MjA2NjI2MTkVAgASGCBBQzEyRUM3NjcxRThDMjAzQjE2QkU4OTY0ODcyMTQ2OQA=", "sender": "user", "message_type": "voice", "content": "[Voice message] بالتأكيد، إليك تفريغ المقطع الصوتي بالدارجة المغربية:\n\n\"السلام عليكم، ها هو ابنتي صفت لك راديوغرافي، عندي ربعة د البياسات لفوق، وعندي لتحت هادوك سناني دياولي ومرصقة عليهم. دبا أنا بغيت نحيد هادوك لتحتانيين كاملين وندير الفيسات، والفوق عاود شوفي إلا كان خاص، إلا قدرتو تزيدو ليا، حيت يمكن عندي العظم قليل ما نعرف. المهم تتردي عليا، ونهضرو غير بالأوديو بركة، مكنعرفش نقرا العربية.\"", "created_at": "2026-05-20T13:27:41.185410", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9463/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 32953, "message_id": "bot_meta_495384013668010_wamid.HBgLMzQ2MjA2NjI2MTkVAgASGCBBQzEyRUM3NjcxRThDMjAzQjE2QkU4OTY0ODcyMTQ2OQA=_9977", "sender": "bot", "message_type": "text", "content": "غادي نبلغ الفريق الطبي ديالنا بالسؤال ديالك والراديو اللي صيفطتي، وغادي يتواصلوا معاكوم في أقرب وقت إن شاء الله باش يجاوبوك ويوجهوك حسب الحالة ديالك.", "created_at": "2026-05-20T13:28:03.474325", "media_url": null, "media_mime_type": null}, {"id": 32954, "message_id": "bot_meta_495384013668010_wamid.HBgLMzQ2MjA2NjI2MTkVAgASGCBBQzEyRUM3NjcxRThDMjAzQjE2QkU4OTY0ODcyMTQ2OQA=_6825", "sender": "bot", "message_type": "text", "content": "إلى كان شي مستجد أو سؤال آخر، أنا هنا رهن الإشارة ديالك!", "created_at": "2026-05-20T13:28:03.538258", "media_url": null, "media_mime_type": null}, {"id": 33696, "message_id": "AC9E4D4E88289030CF85BC86E2DE8901", "sender": "user", "message_type": "voice", "content": "[Voice message] شكراً ابنتي شكراً واخا.", "created_at": "2026-05-21T19:08:47.792533", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9669/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 33697, "message_id": "bot_AC9E4D4E88289030CF85BC86E2DE8901_9185", "sender": "bot", "message_type": "text", "content": "العفو، هذا واجبنا! إذا احتجتي أي مساعدة أخرى أو عندك أي سؤال، راسلينا في أي وقت، الفريق غادي يتواصل معاكوم قريباً إن شاء الله 😊", "created_at": "2026-05-21T19:09:04.661708", "media_url": null, "media_mime_type": null}, {"id": 36308, "message_id": "ACD0A296D0A50C1909AEE57C83279FE5", "sender": "user", "message_type": "voice", "content": "[Voice message] أوهو", "created_at": "2026-05-29T10:20:11.929227", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10128/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 36309, "message_id": "bot_ACD0A296D0A50C1909AEE57C83279FE5_4433", "sender": "bot", "message_type": "text", "content": "إذا كان عندك شي سؤال أو محتاجة توضيح إضافي، قولي لي فقط وأنا هنا معاك! 😊", "created_at": "2026-05-29T10:20:28.231493", "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 2876 in training_review_items