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": 16476, "message_id": "A5EB076F01BFA1477ED3CD41F5458172", "sender": "user", "message_type": "voice", "content": "[Voice message] أهلا لاباس عليك مزيانة بخير هانية أمور بخير؟\nقلت لي كنت.. كنا جينا لعندك باش نقلع الضرسة أختي من العملية.\nوبغيت نسولك، عندي واحد جوج سنات القدام يعني بغيت نزولهم وندير آخريت بلاصتهم، يعني شحال كتحسبوا لسنة وحدة؟ حيت عندي شوية مـ... دابا نصورهم ليك.", "created_at": "2026-04-15T19:45:52.652594", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4401/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16477, "message_id": "A5D6A364C82F3F7FBFFE6D2BBBEC06E9", "sender": "bot", "message_type": "text", "content": "Bonjour et bienvenue au Cabinet dentaire Tanger Bay \nمرحبا بكم فـ عيادة طنجة باي لطب الأسنان.\n\n Merci de nous indiquer en quoi nous pouvons vous aider afin que notre équipe puisse vous orienter au mieux.\nمن فضلكم، أخبرونا كيف يمكننا مساعدتكم لكي يتمكن فريقنا من توجيهكم بشكل مناسب\n\n📍 Localisation : https://maps.app.goo.gl/ZCXz3sMZkhk9diph7\n🌐 Site web : www.tangerbay.ma\n📧 Email :\ntangerbay01@gmail.com\n\n✅ Notre équipe vous répondra dans les plus brefs délais.\nسيقوم فريقنا بالرد عليكم في أقرب وقت ممكن", "created_at": "2026-04-15T19:45:54.687375", "media_url": null, "media_mime_type": null}, {"id": 16478, "message_id": "bot_A5EB076F01BFA1477ED3CD41F5458172_7255", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre message et bienvenue encore une fois 😊 Si vous avez besoin d’aide ou d’information, n’hésitez pas à préciser votre demande. Nous sommes à votre disposition !", "created_at": "2026-04-15T19:46:18.856271", "media_url": null, "media_mime_type": null}, {"id": 16479, "message_id": "A56DDDDBAD6F9D083115B30EB46CF6E3", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"blur\", \"low_resolution\"]\n  },\n  \"description\": \"The image shows the lower face and mouth of an individual with their lips parted to expose the upper and lower anterior teeth. The gum tissue and teeth are visible. There is a green oval drawn around the lower front teeth. The teeth appear discolored with yellow to brown staining on the lower anterior teeth and some irregular spacing. The gums appear to have some redness, particularly around the lower front teeth. Several teeth have visible buildup near the gum line.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Notable yellow-brown staining and visible calculus at the gum-line, irregular alignment, some crowding and spacing. One incisor appears severely stained or possibly decayed at the margin.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Upper front teeth visible with staining along the gumline, some irregular alignment, and mild yellow discoloration.\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"lower_right\",\n        \"observation\": \"Adjacent to front teeth, increased\n\nUser message context: ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"blur\", \"low_resolution\"]\n  },\n  \"description\": \"The image shows a close-up intraoral view of a person's mouth with the lips retracted to display the upper and lower front teeth. There is a green outline highlighting the central lower anterior region. Several teeth are visible, with significant yellow-brown staining, especially near the gum line. Plaque and calculus deposits are apparent on the lower front teeth. There are notable gaps between some of the upper and lower teeth, and alignment appears irregular. The gums appear pale pink in some areas but are partially obscured. There are no obvious soft tissue lesions or large swellings visible in this photo.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Notable yellow-brown staining and substantial calculus at the gum line, irregular teeth spacing, at least one apparent missing tooth in the lower anterior segment.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Discoloration present, especially around the incisal and cervical areas; irregular alignment and possible crowding.\",\n        \"severity_signal\": \"moderate\"\n      },", "created_at": "2026-04-15T19:46:31.988171", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4402/download", "media_mime_type": "image/jpeg"}, {"id": 16480, "message_id": "bot_A56DDDDBAD6F9D083115B30EB46CF6E3_6641", "sender": "bot", "message_type": "text", "content": "شكرا على إرسال الصورة. بالنسبة لتقييم الحالة أو إعطاء رأي طبي حول الأسنان أو اللثة، خاص ضروري يشوفها الطبيب مباشرة أو على الأقل يطلع عليها فريقنا المختص. غادي نبلغ الفريق الطبي ديالنا بالصورة والسؤال ديالك وغادي يتواصلوا معكوم في أقرب وقت إن شاء الله 🙏🏻", "created_at": "2026-04-15T19:46:56.568804", "media_url": null, "media_mime_type": null}, {"id": 16481, "message_id": "A50117CC342590E7E803F32BF6879E24", "sender": "user", "message_type": "text", "content": "اك", "created_at": "2026-04-15T19:47:31.060760", "media_url": null, "media_mime_type": null}, {"id": 16485, "message_id": "bot_A50117CC342590E7E803F32BF6879E24_1910", "sender": "bot", "message_type": "text", "content": "غادي نبلغ الفريق الطبي ديالنا بالصورة وغادي يتواصلوا معكوم في أقرب وقت إن شاء الله 🙏🏻", "created_at": "2026-04-15T19:47:45.506865", "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 1229 in training_review_items