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": 28463, "message_id": "meta_echo_495384013668010_wamid.HBgLMzQ2MzE4ODM5NTEVAgARGCBBNUVCNzY1QjFCQ0M5MkYwMjM4MTc3NzQwQzJFOTlEQgA=", "sender": "bot", "message_type": "text", "content": "Marhba", "created_at": "2026-05-13T09:56:16.174767", "media_url": null, "media_mime_type": null}, {"id": 29070, "message_id": "meta_echo_495384013668010_wamid.HBgLMzQ2MzE4ODM5NTEVAgARGBYzRUIwQUNCMzUwOTM3NDJEOEMwNkEyAA==", "sender": "bot", "message_type": "text", "content": "Bonjour,\r\nNous espérons que vous allez bien. Nous voulions simplement nous assurer que tout se passe bien suite à votre extraction et que vous ne ressentez pas de gêne particulière.\r\nSi vous avez la moindre question ou inquiétude, n’hésitez pas à nous contacter.\r\nBon rétablissement.", "created_at": "2026-05-14T09:13:15.356779", "media_url": null, "media_mime_type": null}, {"id": 29163, "message_id": "meta_495384013668010_wamid.HBgLMzQ2MzE4ODM5NTEVAgASGBQzQUQxNzkwMjkzNDg1RjlBQjU2RAA=", "sender": "user", "message_type": "text", "content": "Bonjour,\nMerci beaucoup pour votre message et votre attention. Aujourd’hui, au troisième jour après l’extraction, je me sens beaucoup mieux et je ne ressens plus de gêne.\nMerci encore pour votre professionnalisme et votre suivi.", "created_at": "2026-05-14T10:17:22.207175", "media_url": null, "media_mime_type": null}, {"id": 29164, "message_id": "meta_echo_495384013668010_wamid.HBgLMzQ2MzE4ODM5NTEVAgARGCBBNTZENkU0RjRFRUJEMDk4QTIxMzI1NTgyRTc4Qzk1MQA=", "sender": "bot", "message_type": "text", "content": "[Owner sent a message]", "created_at": "2026-05-14T10:17:39.821671", "media_url": null, "media_mime_type": null}, {"id": 32068, "message_id": "meta_echo_495384013668010_wamid.HBgLMzQ2MzE4ODM5NTEVAgARGCBBNTM5NkU0QTM4NkU5OTg2MzNGMDNGRUY5Mzg0OTYxNwA=", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**السلام عليكم مدام سليمة، صباح الخير، كي صبحتي مزيان؟ بيخير؟ الصحة لاباس؟ كلشي مزيان؟ مدام سليمة منين تفيقي وتسمعي هاد الأوديو، ديك الساعتاك عيطي ليا، صافي؟**\n\n**Transliteration (Latin script):**\n*السلام عليكم Madame Salima, sba7 l-khir, ki sba7ti mezian? Bikhir? Se77a labas? Kolchi mezian? Madame Salima mnin tfiqi w tsem'i had l'audio, dik sa'tak 'ayti lya, safi?*", "created_at": "2026-05-19T08:31:39.868737", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9250/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 32137, "message_id": "meta_echo_495384013668010_wamid.HBgLMzQ2MzE4ODM5NTEVAgARGBYzRUIwRDVDNUREN0UyRjk1MTBGNDBEAA==", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*SALIMA Lanjri*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mercredi 20 mai 2026* à *14:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الأربعاء 20 ماي 2026* على الساعة *14:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-19T09:56:32.021105", "media_url": null, "media_mime_type": null}, {"id": 32139, "message_id": "meta_495384013668010_wamid.HBgLMzQ2MzE4ODM5NTEVAgASGBQzQURGQ0QwOEFFMUE3Q0JDN0RCRQA=", "sender": "user", "message_type": "text", "content": "Merci beaucoup", "created_at": "2026-05-19T09:57:02.852543", "media_url": null, "media_mime_type": null}, {"id": 32415, "message_id": "meta_echo_495384013668010_wamid.HBgLMzQ2MzE4ODM5NTEVAgARGBYzRUIwQjg1MkFEMzRDRjQ0RTE2REZDAA==", "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 Tanger Bay Dental Center. It features a cartoon tooth character with a smiling face, holding a small notepad with a large green check mark. The background shows a well-lit dental clinic room with a dental chair and equipment, out of focus. The top of the image has the Tanger Bay Dental Center logo (a stylized tooth), and there are two blue banners with white text confirming an appointment.\",\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    \"Tanger Bay Dental Center\",\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n\nUser message context: Salut *SALIMA Lanjri*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mercredi 20 mai 2026*\r\n🕘 Heure : *14: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-05-19T15:02:49.209531", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9336/download", "media_mime_type": "image/jpeg"}, {"id": 32464, "message_id": "meta_495384013668010_wamid.HBgLMzQ2MzE4ODM5NTEVAgASGBQzQTkzNjExNjYxODM3M0UxNEY3NwA=", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-05-19T16:24:19.231426", "media_url": null, "media_mime_type": null}, {"id": 38611, "message_id": "3ACEF08805C0721487C5", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم شيماء، كيف نتينا؟ لاباس عليك؟ بخير؟ الصحة لاباس؟ كلشي بخير؟ سمح لي كنتواصل معاك فهاد الساعة، ما عرفتكشي واش غتسمع الأوديو ولا حتى لغدا. كلشي بخير أختي، الله يحفظك. بغيت غير نسولك نتينا قلتي الدونتيست... نتينا قلتي الدكتور غادي يكون كونجي مور العيد ياك؟ فوقاش غادي يدخل؟ ما كرهتشي نشوفو فأقرب زعما رونديفو باش ندخل. حتى لغدا ف الصباح وشوف ليا عافاك وسرد لي الأوديو عافاك أحبيبة. يالاه الله يحفظك.", "created_at": "2026-06-03T22:06:14.176620", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10754/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 38612, "message_id": "A578AB9DC05B3578FA95B2E74674CCB9", "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-06-03T22:06:18.603747", "media_url": null, "media_mime_type": null}, {"id": 38613, "message_id": "bot_3ACEF08805C0721487C5_8723", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre message 😊 واش كاين شي خدمة أو استشارة محتاجينها اليوم؟", "created_at": "2026-06-03T22:06:52.801086", "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 3118 in training_review_items