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": 4751, "message_id": "bot_3AA38C066003CEDB0D92_4361", "sender": "bot", "message_type": "text", "content": "واخا، إذا كان عندك أي استفسار أو محتاج شي حاجة أخرى، حنا هنا للمساعدة ديالك. نهارك مبروك! 😊", "created_at": "2026-03-14T18:31:18.063446", "media_url": null, "media_mime_type": null}, {"id": 5891, "message_id": "3A9709A97463D419FA69", "sender": "user", "message_type": "text", "content": "Salamo ealikomm", "created_at": "2026-03-17T15:20:13.891673", "media_url": null, "media_mime_type": null}, {"id": 6041, "message_id": "A5867F6CD52278494B5E72B2D48C94D8", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-17T19:53:18.313860", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1201/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 6043, "message_id": "3A3AFF08D814FA061626", "sender": "user", "message_type": "text", "content": "Sfe enshalaaah", "created_at": "2026-03-17T20:07:15.831815", "media_url": null, "media_mime_type": null}, {"id": 7186, "message_id": "A58C635A9D52184BF9B05DA6885D69E6", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure, here is the transcription of the audio:\n\n**Arabic Script:**\nالسلام قمر، كيف نتينا؟ مزيانة؟ بخير؟ قمر قولي فوقاش تكوني disponible نهار السبت باش ناخدلك rdv؟\n\n**Latin Script:**\n\"Salam Qamar, kif ntina? Maziana? Bikher? Qamar goli foqash tkoni disponible nhar s-sebt bash nakhud lek rdv?\"\n\n**Key words used:**\n*   **Disponible:** French for \"available.\"\n*   **rdv (rendez-vous):** French for \"appointment.\"\n*   **Kif ntina:** Northern Moroccan Darija for \"How are you?\"", "created_at": "2026-03-26T18:19:38.577168", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1459/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7246, "message_id": "3AFA46BB261850497E36", "sender": "user", "message_type": "text", "content": "Mhm mashi bekri bezfaf", "created_at": "2026-03-26T20:15:39.722284", "media_url": null, "media_mime_type": null}, {"id": 7260, "message_id": "A545DA4F8C454B04570ED77582B3ACD7", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using both Arabic and Latin scripts):\n\n### **Arabic Script**\n\"صافي واخا، حيت أنا كنخدم من التسعود للزوج. أنا غدا نشوف ليك شي رانديفو زعما يكون مناسب ليك، هايدا الـ 11، 12 مزيانة؟ ولا مع الـ وحدة ونص، فوقاش بغيتي؟\"\n\n### **Latin Script (Transcription)**\n\"Safi wakha, hit ana kan-khdem men t-tes'oud l-zouj. Ana ghedda n-shouf lik chi rendez-vous za'ma ikoun mounassib lik, hayda l-hda'sh, tnash mzyana? wella m'a l-wehda w ness. Fouqach bghiti?\"\n\n### **English Translation (for context)**\n\"Okay, fine, because I work from 9:00 to 2:00. Tomorrow I'll look for an appointment for you that would be suitable for you, like 11:00 or 12:00, is that good? Or at 1:30? When do you want it?\"", "created_at": "2026-03-26T20:50:42.263209", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1486/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7264, "message_id": "3AC081C930511F0522BB", "sender": "user", "message_type": "text", "content": "Sfe uakha shukrnn", "created_at": "2026-03-26T20:58:15.817525", "media_url": null, "media_mime_type": null}, {"id": 7306, "message_id": "3EB0402FC4AAB15184F9D0", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*DOUASS Kamar*\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 28 mars 2026* à *12:15* .\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لديكم موعد مع ** يوم *السبت 28 مارس 2026* على الساعة *12:15*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-27T08:23:38.105651", "media_url": null, "media_mime_type": null}, {"id": 7525, "message_id": "3EB074458E583529269C0C", "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 features a cartoon tooth character with a smiling face holding a calendar or notebook displaying a green check mark. The scene appears to be set in a dental clinic with a blurred dental chair in the background. Above the tooth character, there's text in French which translates to 'YOUR APPOINTMENT IS CONFIRMED' followed by 'AT TANGER BAY DENTAL CENTER'. The logo of Tanger Bay Dental Center is visible at the top, depicting a stylized tooth.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\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    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\",\n    \"TANGER BAY DENTAL CENTER\"\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"\n\nUser message context: Salut *DOUASS Kamar*👋\r\nNous vous confirmons votre rendez-vous avec *DR ALAMI MUSTAPHA*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 28 mars 2026*\r\n🕘 Heure : *12:15*\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-27T15:04:38.503915", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1575/download", "media_mime_type": "image/jpeg"}, {"id": 7584, "message_id": "3A31D4E47FC4CB8DF81B", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-03-27T15:30:57.109048", "media_url": null, "media_mime_type": null}, {"id": 7587, "message_id": "bot_3A31D4E47FC4CB8DF81B_6134", "sender": "bot", "message_type": "text", "content": "Parfait 😊 Votre présence est confirmée pour le rendez-vous avec *DR ALAMI MUSTAPHA* le *samedi 28 mars 2026* à *12:15* chez Tanger Bay Dental Center. À bientôt إن شاء الله 🙏🏻", "created_at": "2026-03-27T15:31:28.552160", "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 276 in training_review_items