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}, {"id": 14253, "message_id": "ACE308D907564C25CB51B55D5CC4048C", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"partial_view\", \"medium_resolution\", \"photo_of_xray_printout\", \"background_distractions\"]\n  },\n  \"description\": \"Panoramic dental X-ray image printed on paper, captured as a photo. The X-ray shows full upper and lower jaws. There are significant dental prosthetics/implants visible: multiple implants placed in both the upper and lower arches, supporting extensive fixed restorations or bridges. Natural teeth do not appear to be present. No obvious native root anatomy visible, with what appears to be complete edentulism replaced by implant-supported fixed prostheses. The image background includes a blue fabric, cardboard, and several jars/containers, indicating a non-clinical setting. There is a visible printed date at the bottom: 'Date d'acquisition 23/02/2026 18:09'.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"Not visible on X-ray.\",\n    \"bone_level\": \"Alveolar bone ridges are visible. No obvious signs of severe bone loss adjacent to implants, but fine details are limited due to the print/photo quality.\",\n    \"root_canals\": \"Not applicable; no native teeth present.\",\n\nUser message context: ```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"partial_view\", \"moderate contrast\", \"background objects visible\"]\n  },\n  \"description\": \"This is a printed panoramic dental X-ray image photographed on top of a cluttered surface (with towel and household jars visible in the background). The X-ray displays the entire upper and lower jaws. Multiple dental implants are visible: in the upper jaw, at least six implant fixtures are present supporting a full-arch prosthesis; in the lower jaw, at least four implant fixtures are visible, also with a fixed prosthesis. Most, if not all, natural teeth appear to be missing and are replaced by prosthetic components. There are high-density metallic restorations and some areas of less clear bone definition around the implants due to the radiopacity of the materials. At the right border of the image there is a radiopaque round object, resembling a radiographic marker or artifact. The date \"23/02/2026 18:09\" is visible at the bottom.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"Not directly visible due to the nature of panoramic X-ray and extensive metallic prostheses.\",\n    \"bone_level\": \"Bone levels difficult to assess precisely due to extensive prost", "created_at": "2026-04-12T09:55:54.630602", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3676/download", "media_mime_type": "image/jpeg"}, {"id": 14254, "message_id": "ACD9117D49A124B097FEED632EE4C9AC", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a document titled 'Implant Swiss Implant Guarantee Certificate'. The document is unfolded on a purple quilted surface. On the left side of the document is a logo with 'NOVODENT' and contact information. There is a photo of a smiling woman giving two thumbs up. In the middle section, there are several labels for 'implantswiss' with QR codes, lot numbers, and references, as well as reserved spaces for additional stickers. The right side lists the product and certificate title with images of dental implants. The colors used are mostly white and red. The document appears clean and undamaged, and other papers are partially visible on the left and upper edges.\",\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    \"NOVODENT\",\n    \"", "created_at": "2026-04-12T09:55:54.968237", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3677/download", "media_mime_type": "image/jpeg"}, {"id": 14255, "message_id": "bot_ACD9117D49A124B097FEED632EE4C9AC_1294", "sender": "bot", "message_type": "text", "content": "شكرا على إرسال الصور والوثائق. واش ممكن توضح ليا شنو بالضبط السؤال أو الطلب ديالك بخصوص البروتيز، الراديو أو شهادة الضمان اللي صيفطتي؟ إذا عندك استفسار معين أو محتاج توجيه من الطبيب، غادي نبلغ الفريق مباشرة.", "created_at": "2026-04-12T09:56:23.565474", "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 1003 in training_review_items