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": 50203, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjY1NDkxNTM3FQIAEhggQTUxOTI1MUUyMzlDMzlDMjA4RDAzQjYxQTE2NDdDODQA", "sender": "user", "message_type": "document", "content": "", "created_at": "2026-07-01T19:57:33.979739", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/14042/download", "media_mime_type": "application/pdf"}, {"id": 50204, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjY1NDkxNTM3FQIAEhggQTUxMUI2MUQwNTQ2MEU5QUM3OTRGRDYzNzc1RkU4MzMA", "sender": "user", "message_type": "document", "content": "", "created_at": "2026-07-01T19:57:34.683387", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/14043/download", "media_mime_type": "application/pdf"}, {"id": 50205, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjY1NDkxNTM3FQIAEhggQTVCOEFBQTk0QkFGOTc3OTVDOThEREEwNDBFMzAzQUQA", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This image is a promotional flyer for 'Labo Fournitures et Matériel Dentaires' advertising dental supplies and materials under the 'PROMOTION EXPO 2026'. The design is clean and modern, featuring a white and blue background with product images and prices displayed for various dental products, including dental whitening systems, adhesives, bulk-fill composites, bite registration materials, matrix systems, and other consumables. The bottom contains the business address and contact information. Product names, prices, discounts, and descriptive packaging details are visible.\",\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    \"Labo\",\n    \"Fournitures et Matériel Dentaires\",\n    \"PROMOTION EXPO 2026\",\n    \"WHITENESS HP 35% 600Dh\",\n    \"WHITENESS HP MAXX\",\n    \"\n\nUser message context: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This image is a promotional flyer for dental supply products, titled 'PROMOTION EXPO 2026.' It is branded with a logo for 'Labo Fournitures et Matériel Dentaires.' The flyer displays various dental materials and tools, each with a product image, name, description, and promotional price. The background is composed of light blue and white geometric patterns. Contact details, address, and phone numbers for the company are visible at the bottom.\",\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    \"Labo Fournitures et Matériel Dentaires\",\n    \"PROMOTION EXPO 2026\",\n    \"WHITENESS HP 35% 600Dh\",\n    \"WHITENESS HP MAXX\",\n    \"WHITENESS HP AUTOMIX + ARCFLEX =", "created_at": "2026-07-01T19:57:35.338675", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/14044/download", "media_mime_type": "image/jpeg"}, {"id": 50206, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjY1NDkxNTM3FQIAEhggQTU4NjQwMEZEMUQwNUNCNDZCRjA0RjMzNjI1OUJEMTgA", "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\": \"This is a promotional flyer for dental supplies and materials. The document contains various product images, names, kit or product sizes, original and promotional prices, and descriptions. The background is a mix of blue and white geometric designs. A company logo 'Labo Fournitures et Matériel Dentaires' appears in the top left. 'PROMOTION EXPO 2026' is prominently displayed at the top right. Multiple dental products are showcased, including silicones, resin cements, temporary fillings, composites, and accessories, with their discounted prices. A physical address and two phone numbers are listed at the bottom in a blue banner.\",\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    \"Labo Fournitures et Matériel Dentaires\",\n    \"PROMOTION EXPO 2026\",\n    \"SILIC-ONE KIT SIL", "created_at": "2026-07-01T19:57:35.630057", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/14045/download", "media_mime_type": "image/jpeg"}, {"id": 50207, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjY1NDkxNTM3FQIAEhggQTVBNjY0MDNDODI3NDg4ODVERjAzMzRENTAxNEQzODEA", "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\": \"This image is a promotional flyer for a dental supply company named Labo, featuring various dental materials and products with discounted prices. The flyer contains images and names of multiple dental products, boxes, and tubes, along with their original and promotional prices in Moroccan Dirhams (DH). There are various brand names such as FGM, Allcem, Vitra, Opallis, Maxxion R, Primmart, OraTemp, Diamond, Condac, and Fusion Universal displayed. The flyer includes the company's address and phone numbers at the bottom.\",\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    \"Labo\",\n    \"Fournitures et Matériel Dentaires\",\n    \"PROMOTION EXPO 2026\",\n    \"KIT SILIC ONE PUTTY + LIGHT EXP\",\n    \"800", "created_at": "2026-07-01T19:57:35.638775", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/14046/download", "media_mime_type": "image/jpeg"}, {"id": 50208, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjY1NDkxNTM3FQIAEhggQTVGODg4RDY4NDFEOEYzRUYzMUU0NTdDMDFEODA1QTAA", "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\": \"This is a promotional flyer for dental supplies and equipment by 'Labo Fournitures et Matériel Dentaires'. The flyer is well designed with a blue and white color theme, showcasing a variety of dental materials with images, names, and prices. The flyer mentions 'PROMOTION EXPO 2026' and lists multiple discounted dental products such as Whiteness HP 35%, Whiteness HP Maxx, Whiteness HP Automixx + Arcflex, Opus Bulk Fill, Ortho Bite Blue, Ambar Universal APS Plus 3ml, Ambar Universal APS 5ml, Diaflex, Zical Automix, Unimatrix R, Unimatrix Recharge, Polyser Matrix Strip, Serrated Diamond Strip, Praxis Recharge, and EDTA Liquide. Each product has an image, price, and some have original and discounted prices. The flyer contains the business address and contact info at the bottom.\",\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    \"", "created_at": "2026-07-01T19:57:35.643886", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/14047/download", "media_mime_type": "image/jpeg"}, {"id": 50209, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNjY1NDkxNTM3FQIAEhggQTVGODg4RDY4NDFEOEYzRUYzMUU0NTdDMDFEODA1QTAA_6579", "sender": "bot", "message_type": "text", "content": "شكرا على إرسال الصورة!", "created_at": "2026-07-01T19:58:23.834674", "media_url": null, "media_mime_type": null}, {"id": 50210, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNjY1NDkxNTM3FQIAEhggQTVGODg4RDY4NDFEOEYzRUYzMUU0NTdDMDFEODA1QTAA_9385", "sender": "bot", "message_type": "text", "content": "هاد الوثيقة عبارة عن إعلان ترويجي لمواد وتجهيزات طب الأسنان من شركة \"Labo Fournitures et Matériel Dentaires\" بمناسبة \"PROMOTION EXPO 2026\".", "created_at": "2026-07-01T19:58:23.890527", "media_url": null, "media_mime_type": null}, {"id": 50211, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNjY1NDkxNTM3FQIAEhggQTVGODg4RDY4NDFEOEYzRUYzMUU0NTdDMDFEODA1QTAA_4642", "sender": "bot", "message_type": "text", "content": "فيها عروض وأسعار خاصة لمجموعة من المنتجات الخاصة بأطباء الأسنان (مثل مواد التبييض، الحشوات، الأدوات، إلخ).", "created_at": "2026-07-01T19:58:23.952182", "media_url": null, "media_mime_type": null}, {"id": 50212, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNjY1NDkxNTM3FQIAEhggQTVGODg4RDY4NDFEOEYzRUYzMUU0NTdDMDFEODA1QTAA_6663", "sender": "bot", "message_type": "text", "content": "إلا كنتي باغي شي معلومة إضافية أو عندك سؤال معين على شي منتج أو عرض، وضح لي أكثر باش نقدر نساعدك أو نبلغ الفريق المختص إذا كان ضروري.", "created_at": "2026-07-01T19:58:24.006045", "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 4161 in training_review_items