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": 10491, "message_id": "3EB06538941A8A78E45CF7", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is a colorful, cheerful graphic likely intended for social media or marketing purposes. It features a cartoon-like tooth with big eyes, a wide smiling mouth, rosy cheeks, and a party hat with stripes. The background includes a dental chair and equipment, suggesting a dental clinic environment. The top part of the image displays the text 'HAPPY BIRTHDAY' in vibrant, multi-colored letters. At the top right, there is a logo that looks like the outline of a tooth with text reading 'TANGER BAY DENTAL CENTER.' At the bottom, within two blue bands, the text reads: 'TANGER BAY DENTAL CENTER vous souhaite un bon anniversaire' which translates to 'Tanger Bay Dental Center wishes you a happy birthday.' The overall color palette includes various shades of blue and pastel colors. The setting appears clean and inviting.\",\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\nUser message context: Salut  ZERIOUH Rachida,\r\nNous voulions vous adresser nos vœux les plus chaleureux pour votre anniversaire ! 🥳\r\nNous sommes heureux de célébrer cette occasion spéciale avec vous en tant que patient fidèle.\r\n\r\nÀ cette occasion, nous avons le plaisir de vous offrir une réduction exceptionnelle de 20% sur le blanchiment dentaire + le nettoyage, valable tout au long de votre mois d’anniversaire. ✨🦷\r\n\r\nNous espérons que votre journée sera remplie de bonheur et de moments mémorables.\r\nSi vous avez besoin de quoi que ce soit ou si vous avez des questions, n'hésitez pas à nous contacter.\r\nAvec toute mon affection,\r\n[ Cabient Dr. Boutaib Haitham ]", "created_at": "2026-04-02T09:28:22.051998", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2532/download", "media_mime_type": "image/jpeg"}, {"id": 11058, "message_id": "ACB01F58A873E978DC98197A0F74A419", "sender": "user", "message_type": "text", "content": "السلام عليكم ورحمة الله وبركاته \nكيف حالكم عساكم بخير \nأريد أن تحجزي لي موعدا مع الطبيب يوم السبت  ضروريا لأن الأسنان تؤلمني ،مشكرورين ،", "created_at": "2026-04-02T18:49:00.018892", "media_url": null, "media_mime_type": null}, {"id": 11059, "message_id": "bot_ACB01F58A873E978DC98197A0F74A419_2100", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله وبركاته، شكرا على الرسالة الطيبة ديالكوم و عيد ميلاد سعيد مرة أخرى 🎉\n\nبالنسبة للألم اللي عندكوم فالأسنان، غادي نبلغ الفريق الطبي ديالنا وغادي يتواصلوا معكوم في أقرب وقت باش يأكدو معاكوم موعد يوم السبت إن شاء الله.\n\nنتمنى ليكوم الشفاء العاجل، ووقتما حتاجيتيو شي حاجة حنا رهن الإشارة ديالكوم.", "created_at": "2026-04-02T18:49:20.282875", "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 678 in training_review_items