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": 7628, "message_id": "A5E8A7AE43515A0E6DBCB859A5007576", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"A panoramic dental X-ray showing a full view of the upper and lower jaws. The teeth are clearly visible with good bone contrast. Measurement indicators are present on the right side of the image.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_right\",\n        \"observation\": \"wisdom tooth appears to be impacted, rest of the teeth appear normal\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"upper_left\",\n        \"observation\": \"wisdom tooth appears to be impacted, rest of the teeth appear normal\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"lower_right\",\n        \"observation\": \"teeth appear normal without any visible decay\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"lower_left\",\n        \"observation\": \"teeth appear normal without any visible decay\",\n        \"severity_signal\": \"none\"\n      }\n    ],\n    \"gum_condition\": \"not visible\",\n    \"bone_level\": \"bone levels appear normal with no significant bone loss visible\",\n    \"root_canals\": \"not", "created_at": "2026-03-27T16:09:26.058925", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1603/download", "media_mime_type": "image/jpeg"}, {"id": 7647, "message_id": "A5C8830EBB225326A8F2EE54BE589A10", "sender": "user", "message_type": "text", "content": "Sardli l'occasion", "created_at": "2026-03-27T16:13:19.284330", "media_url": null, "media_mime_type": null}, {"id": 7648, "message_id": "bot_A5C8830EBB225326A8F2EE54BE589A10_4780", "sender": "bot", "message_type": "text", "content": "كنعتدر، غادي نبلغ الفريق باش يتواصلوا بيكوم بخصوص هاد الطلب إن شاء الله 🙏🏻 واخا تعطيني الإسم الكامل ديالك؟", "created_at": "2026-03-27T16:13:40.770686", "media_url": null, "media_mime_type": null}, {"id": 7649, "message_id": "A55F536A70912EC2D8B0BE55DA5309D5", "sender": "user", "message_type": "text", "content": "Bax n3amar cinss", "created_at": "2026-03-27T16:13:42.165757", "media_url": null, "media_mime_type": null}, {"id": 7650, "message_id": "bot_A55F536A70912EC2D8B0BE55DA5309D5_7753", "sender": "bot", "message_type": "text", "content": "كنعتدر، غادي نبلغ الفريق الطبي ديالنا باش يتواصلوا معكوم بخصوص هاد الطلب. واخا تعطيني الإسم الكامل ديالك؟", "created_at": "2026-03-27T16:13:50.844803", "media_url": null, "media_mime_type": null}, {"id": 7651, "message_id": "A52784FAB59C67A6B93FB6142449C921", "sender": "user", "message_type": "text", "content": "Hayat dahman", "created_at": "2026-03-27T16:14:04.129807", "media_url": null, "media_mime_type": null}, {"id": 7652, "message_id": "A551823B57571A58324D3C10C558678B", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-03-27T16:14:15.053756", "media_url": null, "media_mime_type": null}, {"id": 7659, "message_id": "bot_A551823B57571A58324D3C10C558678B_8146", "sender": "bot", "message_type": "text", "content": "شكرا Hayat Dahman، غادي نبلغ الفريق الطبي ديالنا وغادي يتواصلوا معكوم في أقرب وقت إن شاء الله 🙏🏻", "created_at": "2026-03-27T16:14:43.590130", "media_url": null, "media_mime_type": null}, {"id": 7660, "message_id": "A53DAC2A56C1EC07EB04D428E5B94085", "sender": "user", "message_type": "text", "content": "Inchallah yarbi", "created_at": "2026-03-27T16:15:45.274454", "media_url": null, "media_mime_type": null}, {"id": 7661, "message_id": "bot_A53DAC2A56C1EC07EB04D428E5B94085_2085", "sender": "bot", "message_type": "text", "content": "آمين، إن شاء الله كل شيء يكون مزيان 😊 إذا احتاجتي أي مساعدة أخرى، أنا هنا رهن الإشارة ديالكوم.", "created_at": "2026-03-27T16:15:57.703156", "media_url": null, "media_mime_type": null}, {"id": 7662, "message_id": "A521CA6CB6C2F83700A472E7EB3C2733", "sender": "user", "message_type": "text", "content": "Chokran 😍", "created_at": "2026-03-27T16:16:14.690950", "media_url": null, "media_mime_type": null}, {"id": 7663, "message_id": "bot_A521CA6CB6C2F83700A472E7EB3C2733_358", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 😊 إذا احتاجتي أي حاجة أخرى، أنا هنا للمساعدة!", "created_at": "2026-03-27T16:16:25.607348", "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 303 in training_review_items