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": 8380, "message_id": "ACD9DFB31BC27C45D44AC490CEDB435B", "sender": "user", "message_type": "voice", "content": "[Voice message] إليك تفريغ المقطع الصوتي باللهجة المغربية (الشمالية) كما ورد:\n\n\"السلام عليكم، \nشفت لانونص (anuncio) ديالكم ف الأنترنت، وأنا كانسكن ف سبانيا هنايا، مايوركا، بالما دي مايوركا، وأنا من تطوان. \nخصني نعدل أربعة د لبلانتيس (implantes) لفوق وأربعة د لبلانتيس لتحت، وأنا غادي نصيفط ليكم الموديل. \nخصني اللي كايزولو يومياً كيدخلو بالبريسيون (pression)، بالـ\"تراك\"، \"تراك\" (track). \nأنا غادي نصيفط ليكم الموديل وشكراً، وصيفطوا ليا الثمن ديالهم الله يخليك.\"", "created_at": "2026-03-29T14:10:56.966917", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1827/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8381, "message_id": "bot_ACD9DFB31BC27C45D44AC490CEDB435B_9371", "sender": "bot", "message_type": "text", "content": "واخا نقدر نعطيكوم une estimation على الثمن 😊 ولكن خاصني نسولكوم واش كتقلبو على أرخص سعر ولا على أحسن نتيجة لحالتكوم؟", "created_at": "2026-03-29T14:11:30.698735", "media_url": null, "media_mime_type": null}, {"id": 8382, "message_id": "ACF4A33F03A046BF03595BC7802851E7", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"dental_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows two views of removable dental prostheses, likely implant-supported overdentures. The upper view (top) appears to be a maxillary overdenture, featuring pink acrylic material mimicking gums, artificial anterior teeth, and four visible implant attachment housings spaced across the denture base. A metallic framework is visible on the interior surface. The lower view (bottom) is a mandibular overdenture with two visible implant attachment housings, spaced in the anterior region, and areas showing signs of wear or underlying structure exposure. Both prostheses show no significant staining or damage on the external surfaces. In the center, there is a logo and text that partially obscure the image.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"Not directly visible as only the prostheses are shown, but the prosthetic gum portion appears intact and pink without significant discoloration.\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [\n      \"Four implant attachment housings in the maxillary prosthesis, two in the mandibular prosthesis\",\n      \"Artificial teeth present in the maxillary overdenture\"\n    ],\n    \"\n\nUser message context: ```json\n{\n  \"visible_domain\": \"dental_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image consists of two clinical photographs showing dental prosthetic devices, presumably upper and lower complete dentures with implant attachments. The upper image shows the internal (intaglio) surface of a maxillary denture with four visible metallic housing attachments, designed to fit onto dental implants. Two anterior prosthetic teeth are partially visible. There is a metallic reinforcement bar in the center. The lower image shows the internal surface of a mandibular denture with two visible implant housings and some metallic reinforcement in the structure. Both prostheses appear clean, made of pink acrylic resin to resemble gum tissue, with the attachments colored blue-green. A watermark with the text 'MIBO CENTRO ODONTOLÓGICO INTEGRAL AVANZADO' is present across the center, partially obstructing both images. The background is entirely black, focusing attention on the prostheses.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_anterior\",\n        \"observation\": \"Two anterior teeth are present in the upper denture and appear intact\",\n        \"severity_signal\": \"none\"\n      }\n    ],\n    \"gum_condition\": \"Not directly visible; the pink", "created_at": "2026-03-29T14:11:56.832030", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1828/download", "media_mime_type": "image/jpeg"}, {"id": 8383, "message_id": "AC099AE13B10611C17D2F66B0A783C0A", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"خصني شي حاجة مزيانة، حنا الناس تطوان، تطواني تطواني.\"\n\n**Latin Script:**\n\"Khasni chi haja mzyana, hna n-nas Tetouan, Tetouani Tetouani.\"\n\n**Translation (for context):**\n\"I need something good, we are the people of Tetouan, Tetouani, Tetouani.\"", "created_at": "2026-03-29T14:12:13.329450", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1829/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8384, "message_id": "bot_AC099AE13B10611C17D2F66B0A783C0A_5818", "sender": "bot", "message_type": "text", "content": "ممتاز 😊 باش تحصل على أحسن نتيجة، implant عندنا كيبدا من 8000DH، وكنخدمو بscanner intra-oral 3D وتحت إشراف Dr Haitham Boutaib. واش بغيتو شي consultation باش يشوف الدكتور الحالة ديالكوم بالضبط ويعطيكوم خطة علاج مفصلة؟", "created_at": "2026-03-29T14:12:41.006490", "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 378 in training_review_items