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": 12639, "message_id": "3AA47AB1A93813259835", "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 a partially opened white and blue box placed on a white surface, most likely a dental implant packaging. The visible part of the box displays the text 'Replace Select™ Tapered PMC WP 5.0 x 10 mm' along with a graphical representation of a dental implant on the right side. There is a logo consisting of a blue circle with a white center and an 'N' symbol below the main text. The lower part of the image includes a partial view of a person's leg and foot, wearing dark clothing and footwear, standing on a beige-tiled floor. There is also part of a white drawer or cabinet at the bottom of the image.\",\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\": [\n    \"Replace Select™ Tapered PMC WP 5.0 x 10 mm\"\n  ],\n\nUser message context: ```json\n{\n  \"visible_domain\": \"object\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a white rectangular box, partly opened, labeled with dental implant product information. The label reads 'Replace Select™ Tapered PMC WP 5.0 x 10 mm' and includes an image of a dental implant (screw-shaped component with a blue top). There are additional logos and symbols visible, including a blue circular design and an 'N™' symbol in gray. The surface the box rests on is white, and part of a metallic drawer handle is visible to the right. The lower portion of the image shows a tiled floor and part of a person's booted foot and the edge of a bag.\",\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    \"Replace Select™\",\n    \"Tapered PMC WP\",\n    \"5.0 x 10 mm\",", "created_at": "2026-04-08T15:47:39.330950", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3218/download", "media_mime_type": "image/jpeg"}, {"id": 12640, "message_id": "bot_3AA47AB1A93813259835_6493", "sender": "bot", "message_type": "text", "content": "شكرا على الصورة! واش ممكن توضح ليا شنو بالضبط السؤال أو الطلب ديالك بخصوص هاد العلبة ديال \"Replace Select™ Tapered PMC WP 5.0 x 10 mm\"؟ إذا عندك شي استفسار تقني أو خاص بالطبيب، قوليه ليا وغادي نبلغ الفريق مباشرة.", "created_at": "2026-04-08T15:48:07.502086", "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 855 in training_review_items