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": 13392, "message_id": "AC29794284376980FCBBCA6525E8DCB7", "sender": "user", "message_type": "text", "content": "salam si salid", "created_at": "2026-04-09T19:41:10.562709", "media_url": null, "media_mime_type": null}, {"id": 13393, "message_id": "bot_AC29794284376980FCBBCA6525E8DCB7_4420", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Halim وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-04-09T19:41:24.934724", "media_url": null, "media_mime_type": null}, {"id": 13394, "message_id": "AC63F0FAA7C4649EF3706790D9CA0E1F", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"details\": {\n    \"orientation\": \"upward angle, inside an open mouth\",\n    \"facial_hair\": \"beard visible surrounding the mouth area\",\n    \"teeth\": {\n      \"visibility\": \"top front and side teeth are visible\",\n      \"condition\": \"some teeth appear discolored\",\n      \"alignment\": \"teeth seem unevenly spaced\"\n    },\n    \"gums\": {\n      \"visibility\": \"gums partially visible above the teeth\",\n      \"coloration\": \"appears as expected for soft tissue\"\n    },\n    \"lighting\": \"light source from the left side, creating shadows\",\n    \"background\": \"ceiling visible with a light fixture\"\n  }\n}\n```\n\nUser message context: ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"main_subject\": \"open mouth\",\n  \"details\": {\n    \"teeth\": {\n      \"visibility\": \"partial\",\n      \"condition\": {\n        \"varies\": \"some discoloration or damage visible\",\n        \"upper_teeth\": \"visible\",\n        \"lower_teeth\": \"partially visible\"\n      }\n    },\n    \"gums\": {\n      \"visibility\": \"partial\",\n      \"condition\": \"unclear\"\n    },\n    \"tongue\": {\n      \"visibility\": \"partial\",\n      \"condition\": \"not clearly visible\"\n    },\n    \"surrounding_area\": {\n      \"beard\": \"present\",\n      \"skin_condition\": \"appears normal\"\n    }\n  },\n  \"environment\": {\n    \"lighting\": \"artificial light, appears to be indoors\",\n    \"background\": \"ceiling with moldings visible\"\n  }\n}\n```", "created_at": "2026-04-09T19:41:49.400650", "media_url": "/api/v1/chatbots/47/knowledge-bases/media/files/3433/download", "media_mime_type": "image/jpeg"}, {"id": 13395, "message_id": "bot_AC63F0FAA7C4649EF3706790D9CA0E1F_220", "sender": "bot", "message_type": "text", "content": "كنعتدر، ما يمكنش ليا نحلل الصور أو نعطي تشخيص طبي بناءً على الصور. إذا كنتي مهتم بشي حاجة معينة بخصوص الأسنان ديالك، من الأفضل تزور Dr Halim Walid في العيادة باش يعطيك التقييم المناسب. واش بغيت نساعدك في حجز موعد؟ 😊", "created_at": "2026-04-09T19:42:08.966065", "media_url": null, "media_mime_type": null}, {"id": 13396, "message_id": "AC066635227FF75F66D07D7B020E42A7", "sender": "user", "message_type": "text", "content": "aahh robot", "created_at": "2026-04-09T19:42:41.634770", "media_url": null, "media_mime_type": null}, {"id": 13397, "message_id": "bot_AC066635227FF75F66D07D7B020E42A7_2386", "sender": "bot", "message_type": "text", "content": "أنا هنا باش نعاونكوم 😊 واش كاين شي حاجة أخرى نقدر نساعدكوم بها؟", "created_at": "2026-04-09T19:42:54.124888", "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 912 in training_review_items