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": 7033, "message_id": "3EB023B3F545529597CF8B", "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 promotional or informational graphic for a dental clinic. The main visual element is a large, cartoon-style anthropomorphized tooth with a smiling face, holding a notepad or calendar with a checkmark drawn in green, indicating confirmation. The tooth character gives a thumbs up gesture. In the blurred background, a dental clinic setting is visible, featuring a dental chair and clinical equipment with light blue and white tones. At the top of the image is the logo of Tanger Bay Dental Center, which depicts a stylized tooth outline above the words 'TANGER BAY DENTAL CENTER'. Overlaid blue banners contain white text in French stating, 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green checkmark, and 'CHEZ TANGER BAY DENTAL CENTER'. The scene is bright, clean, and meant to convey positivity and reassurance.\",\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\n\nUser message context: Salut *El mehdaoui Saad*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 27 mars 2026*\r\n🕘 Heure : *18:00*\r\n📍 Adresse : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)\r\n📞 Pour toute question : 06 60 02 22 63\r\n✅ Merci de nous confirmer votre présence en répondant « OUI » à ce message\r\n\r\n⚠️ IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement considéré comme annulé automatiquement. \r\nMerci de votre compréhension.", "created_at": "2026-03-26T15:08:31.303713", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1426/download", "media_mime_type": "image/jpeg"}, {"id": 15229, "message_id": "2ACD96B18D36C05F9D30", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم، كي داير بيخير؟ الله يرحم ليك الوالدين بغيت نعرف غير داك واحد الدونتيفريس كان عطاه ليا هيثم ومشة ليا، ودبا راني بغيت نصيفط ليه وقلت نصيفط ليك نتا تعطيني السمية ديالو كان عطاه ليا، غتلقاه عندك فالأوردونونص تما موسى السي المداوي إذا كان ممكن.", "created_at": "2026-04-13T22:37:24.509321", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3923/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15230, "message_id": "A5571ABA6517B8452A855761206BFC40", "sender": "bot", "message_type": "text", "content": "Bonjour et bienvenue au Cabinet dentaire Tanger Bay \nمرحبا بكم فـ عيادة طنجة باي لطب الأسنان.\n\n Merci de nous indiquer en quoi nous pouvons vous aider afin que notre équipe puisse vous orienter au mieux.\nمن فضلكم، أخبرونا كيف يمكننا مساعدتكم لكي يتمكن فريقنا من توجيهكم بشكل مناسب\n\n📍 Localisation : https://maps.app.goo.gl/ZCXz3sMZkhk9diph7\n🌐 Site web : www.tangerbay.ma\n📧 Email :\ntangerbay01@gmail.com\n\n✅ Notre équipe vous répondra dans les plus brefs délais.\nسيقوم فريقنا بالرد عليكم في أقرب وقت ممكن", "created_at": "2026-04-13T22:37:28.993909", "media_url": null, "media_mime_type": null}, {"id": 15509, "message_id": "3EB02ED03B6B0543087A49", "sender": "bot", "message_type": "document", "content": "ordonnance_n257708_4780922.pdf", "created_at": "2026-04-14T12:03:10.343401", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4026/download", "media_mime_type": "application/pdf"}, {"id": 15511, "message_id": "A5CFA71FE5016C703495B97FB1AB1B76", "sender": "bot", "message_type": "voice", "content": "[Voice message] إليك كتابة ما ورد في التسجيل الصوتي بالدارجة المغربية:\n\n\"السلام عليكم سي سعد، لاباس عليك؟ مزيان؟ سعد، ها هوما ليزوردونونس (les ordonnances) لي كان عطاك الطبيب، وفيها كولشي.\"", "created_at": "2026-04-14T12:03:17.685374", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4027/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15525, "message_id": "2A8FB094C08E390C8C22", "sender": "user", "message_type": "text", "content": "🙏", "created_at": "2026-04-14T12:23:02.181524", "media_url": null, "media_mime_type": null}, {"id": 15526, "message_id": "bot_2A8FB094C08E390C8C22_3096", "sender": "bot", "message_type": "text", "content": "مرحبا سي سعد 😊 إذا محتاج شي مساعدة إضافية بخصوص les ordonnances أو شي حاجة أخرى، قول ليا شنو محتاج بالضبط ونعاونكوم إن شاء الله.", "created_at": "2026-04-14T12:23:27.413340", "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 1133 in training_review_items