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": 14228, "message_id": "ACC2647B37518D3570E4E6F0838E07DC", "sender": "user", "message_type": "text", "content": "Bonjour je voudrais installer imlans dentaire et couronnes mâchoire inférieure je voudrais le prix proposé pour chaque implant et couronne de bonne matière", "created_at": "2026-04-12T06:31:07.537772", "media_url": null, "media_mime_type": null}, {"id": 14229, "message_id": "A52E5505FB6B4D560CB706B59F03E75D", "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-12T06:31:08.959892", "media_url": null, "media_mime_type": null}, {"id": 14230, "message_id": "bot_ACC2647B37518D3570E4E6F0838E07DC_5910", "sender": "bot", "message_type": "text", "content": "مرحبا الله اودي، شكرا على التواصل ديالكوم مع Centre Dentaire Tanger Bay. واش ممكن تقولولي شنو الحاجة اللي محتاجينها اليوم؟ 😊", "created_at": "2026-04-12T06:31:22.850340", "media_url": null, "media_mime_type": null}, {"id": 14251, "message_id": "AC2A52E64B02B5D23C51B79590438E31", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"object\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows an orange-colored plastic case, open and resting on a table with a decorative white lace tablecloth. Inside the case, there is a dental prosthesis that appears to be a metal and acrylic dental implant-supported bridge, likely for the upper jaw. Several abutment holes are visible, and a pink acrylic portion simulates gum tissue. There are also a few small metallic parts or screws loose within the case, likely prosthetic or implant screws. To the left, a small transparent packet with a gold seal is partially visible. The lower right edge of the image shows a partial view of a metallic object, likely a laptop or another device.\",\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    \"Part of a round gold seal in a transparent packet. Text is not fully legible.\"\n\nUser message context: ```json\n{\n  \"visible_domain\": \"object\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows an orange plastic dental prosthesis storage case, open and placed on a lace-patterned white tablecloth. Inside the case is a dental prosthesis, specifically an upper jaw section with several artificial teeth and pink gum material attached to a visible metal framework containing several screw holes. There are also two small metal components (possibly implant screws or abutments) lying loose inside the case. To the left, a small clear plastic bag with some gold and black markings is partially visible. The lower right corner of the image contains a metallic and plastic object of unclear function, possibly the edge of another case or device.\",\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\": [\"DGOI\" ],\n  \"possible_concerns\": [\n    {\n      \"concern\": \"Dental prosthesis and associated metal screws or abutments are", "created_at": "2026-04-12T09:53:15.001690", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3675/download", "media_mime_type": "image/jpeg"}, {"id": 14252, "message_id": "bot_AC2A52E64B02B5D23C51B79590438E31_1957", "sender": "bot", "message_type": "text", "content": "شكرا على إرسال الصورة! واش ممكن توضح ليا شنو بالضبط السؤال أو المشكل اللي عندك بخصوص هاد البروتيز أو القطع اللي فالصورة؟ إذا عندك شي استفسار تقني أو محتاج توجيه من الطبيب، غادي نبلغ الفريق مباشرة.", "created_at": "2026-04-12T09:53:39.962341", "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 1002 in training_review_items