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": 30283, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjgwNDI4NzU4FQIAEhgUNEFGMjMxMTc4NzNGOTA4OEU1MUIA", "sender": "user", "message_type": "image", "content": "```json\n{\n  \"visible_domain\": \"person\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a person in profile view, facing to the right, standing against a plain, light-colored wall. The individual is wearing a grey hooded top and a white headscarf with lace detailing covering the hair and neck. The face is visible from the side, and the person's expression appears neutral. There is no visible dental or medical context, no distinguishing background elements, and no visible text or labels. No teeth or oral structures are visible, and there are no obvious signs of swelling, asymmetry, or other notable facial features from this angle.\",\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  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"There are no visible signs of concern or notable issues in this", "created_at": "2026-05-15T17:34:44.991015", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/8826/download", "media_mime_type": "image/jpeg"}, {"id": 30284, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNjgwNDI4NzU4FQIAEhgUNEFGMjMxMTc4NzNGOTA4OEU1MUIA_9007", "sender": "bot", "message_type": "text", "content": "شكرا على إرسال الصورة، ولكن هاد الصورة باينة فيها فقط البروفيل ديال الشخص وما فيهاش تفاصيل واضحة على الأسنان أو الفم. إذا كان الهدف منها تقييم وضعية الأسنان أو شي حاجة طبية، من الأفضل تصور صورة واضحة للفم أو الأسنان مباشرة، أو تجيب معاكوم الصور والراديو عند الحضور للعيادة.\n\nإذا محتاجين شي تقييم أو استشارة، مرحبا نسجلو ليكوم موعد مع Dr Haitham Boutaib، أو إذا عندكوم سؤال آخر وضحوه ليا باش نعاونكوم أكثر.", "created_at": "2026-05-15T17:36:07.279975", "media_url": null, "media_mime_type": null}, {"id": 30285, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjgwNDI4NzU4FQIAERgWM0VCMEQ2QkE0M0ZEMTY3OTk2NzZCOQA=", "sender": "bot", "message_type": "text", "content": "شكرا على إرسال الصورة، ولكن هاد الصورة باينة فيها فقط البروفيل ديال الشخص وما فيهاش تفاصيل واضحة على الأسنان أو الفم.", "created_at": "2026-05-15T17:36:09.233299", "media_url": null, "media_mime_type": null}, {"id": 30286, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjgwNDI4NzU4FQIAERgWM0VCMEFGODEyNEZDNUU5NUNBODhGOAA=", "sender": "bot", "message_type": "text", "content": "إذا كان الهدف منها تقييم وضعية الأسنان أو شي حاجة طبية، من الأفضل تصور صورة واضحة للفم أو الأسنان مباشرة، أو تجيب معاكوم الصور والراديو عند الحضور للعيادة.", "created_at": "2026-05-15T17:36:10.616645", "media_url": null, "media_mime_type": null}, {"id": 30287, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjgwNDI4NzU4FQIAERgWM0VCMEI4RDg1NkJGRkFGRjlENDU4MwA=", "sender": "bot", "message_type": "text", "content": "إذا محتاجين شي تقييم أو استشارة، مرحبا نسجلو ليكوم موعد مع Dr Haitham Boutaib، أو إذا عندكوم سؤال آخر وضحوه ليا باش نعاونكوم أكثر.", "created_at": "2026-05-15T17:36:11.989757", "media_url": null, "media_mime_type": null}, {"id": 32804, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjgwNDI4NzU4FQIAEhgUM0E2OUFGRTIyRjgyRjE5QzdGMzMA", "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 gloved hand (wearing a black nitrile glove) holding a small white plastic bottle with a yellow label. The label reads: 'TopiGel Benzocaine Oral wounds 50 ml' in blue and black text. The bottle has a dispensing nozzle at the top, which appears clean. The background is a shiny, black or dark gray countertop with reflective speckles. There are some indistinct objects visible in the corners, including a translucent circular item partially visible at the lower left and a portion of a beige shoe at the lower right. Some packaging boxes are partially visible at the top edge of the image.\",\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\": [\"TopiGel\", \"Benzocaine\", \"Oral wounds\", \"50 ml\", \"21-400267.\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 gloved hand holding a small white bottle with a yellow label. The label reads: 'TopiGel® Benzocaine Oral wounds 50 ml'. The bottle appears to have a pump dispenser. The person is wearing a black glove, presumably nitrile or latex, which is commonly used in medical or dental settings. The background is a shiny, black speckled countertop, likely granite or similar material. There are some partially visible objects in the periphery, including a clear round object at the bottom left and a light-colored shoe at the bottom right. The setting appears to be a clinical or professional environment.\",\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    \"TopiGel®\",\n    \"Benzocaine\",\n    \"Oral wounds\",\n    \"50 ml\"\n  ],\n  \"possible_conc", "created_at": "2026-05-20T11:24:27.351196", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9431/download", "media_mime_type": "image/jpeg"}, {"id": 32805, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjgwNDI4NzU4FQIAEhgUM0EyRDVCOUU4MEMyODNFMUNGNzkA", "sender": "user", "message_type": "text", "content": "9ol n n hesen yejibo", "created_at": "2026-05-20T11:24:40.823837", "media_url": null, "media_mime_type": null}, {"id": 32806, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNjgwNDI4NzU4FQIAEhgUM0EyRDVCOUU4MEMyODNFMUNGNzkA_6757", "sender": "bot", "message_type": "text", "content": "فهمتك، غادي نبلغ الفريق الطبي ديالنا بالرسالة ديالك بخصوص TopiGel Benzocaine، وطلبتي يبلغو \"ن ن\" (أو الحسن) يجيبو. الفريق غادي يتواصل معكوم في أقرب وقت إن شاء الله 🙏🏻", "created_at": "2026-05-20T11:25:07.789578", "media_url": null, "media_mime_type": null}, {"id": 32807, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjgwNDI4NzU4FQIAERggQTU1NkQ3REU2MjFFRjM0QjE1NUVDOTQ2MEMwQkZFQjUA", "sender": "bot", "message_type": "text", "content": "Ok", "created_at": "2026-05-20T11:25:37.253043", "media_url": null, "media_mime_type": null}, {"id": 37678, "message_id": "4A0DA1A1FB33B631BF97", "sender": "user", "message_type": "text", "content": "Lime 15 lime c \nLingettes désinfectantes \nLentulo\nLes gants s\nCarven\nMiroir \nCompresse \nÉponge hémostatique Fuji plus Modeling Strip abrasif Gel anesthésie Matepaste Adhésif Icon Teflon Alcool", "created_at": "2026-06-01T15:19:54.408060", "media_url": null, "media_mime_type": null}, {"id": 37682, "message_id": "bot_4A0DA1A1FB33B631BF97_6850", "sender": "bot", "message_type": "text", "content": "توصلت باللائحة ديال المواد (Lime 15, lime c, lingettes désinfectantes, lentulo, gants, carven, miroir, compresse, éponge hémostatique, Fuji plus, modeling, strip abrasif, gel anesthésie, matepaste, adhésif, Icon, teflon,", "created_at": "2026-06-01T15:20:09.178260", "media_url": null, "media_mime_type": null}, {"id": 37683, "message_id": "bot_4A0DA1A1FB33B631BF97_5887", "sender": "bot", "message_type": "text", "content": "alcool). غادي نبلغ الفريق الطبي ديالنا بهاد الطلب وغادي يتواصلوا معكوم في أقرب وقت إن شاء الله 🙏🏻", "created_at": "2026-06-01T15:20:09.236679", "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 3005 in training_review_items