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": 44892, "message_id": "3EB052658E9044F78B7D61", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BEKRAOUI ABDESLAM*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 18 juin 2026* à *15:30* .\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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *15:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-17T14:59:38.709024", "media_url": null, "media_mime_type": null}, {"id": 44893, "message_id": "3EB00005B13D8DFC6E71D5", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BEKRAOUI ABDESLAM*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 18 juin 2026* à *15:30* .\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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *15:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-17T14:59:49.086844", "media_url": null, "media_mime_type": null}, {"id": 44913, "message_id": "3EB0FDF6F38B7ECD06975C", "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 bright, welcoming dental clinic scene with a cartoonish anthropomorphic tooth character in the foreground. The tooth is smiling, has expressive eyes and eyebrows, and is holding a small calendar or notepad with a large green checkmark. The background includes dental office elements such as a dental chair, blurry cabinets, and soft lighting. At the top, the logo 'Tanger Bay Dental Center' is visible, incorporating a tooth symbol. Across the image, bold blue bars contain white text confirming an appointment at the dental center. The overall color palette is blue, white, and cream.\",\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\n\nUser message context: Salut *BEKRAOUI ABDESLAM*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 18 juin 2026*\r\n🕘 Heure : *15:30*\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-06-17T15:04:53.418619", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12388/download", "media_mime_type": "image/jpeg"}, {"id": 44921, "message_id": "AC2CE0A40B837C47F14C48D0ACB2939A", "sender": "user", "message_type": "text", "content": "<reply_to>Salut *BEKRAOUI ABDESLAM*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 1...</reply_to> OUI", "created_at": "2026-06-17T15:18:08.412916", "media_url": null, "media_mime_type": null}, {"id": 44922, "message_id": "AC9A2C2501193E4D8C637B88E269C045", "sender": "user", "message_type": "text", "content": "Safi ghada m3a 15:30 inchalah o Wax 3anji 7ta jom3a?", "created_at": "2026-06-17T15:20:16.955081", "media_url": null, "media_mime_type": null}, {"id": 44932, "message_id": "A50B3D34619B67457F2DA5723A3C4F85", "sender": "bot", "message_type": "voice", "content": "[Voice message] إليك النسخة المكتوبة من التسجيل الصوتي (بالدارجة المغربية):\n\n**\"السلام أختي كيديرين مزيان بخير؟ لا دابا حالياً عندي رونديفو غير الخميس وديك ساعة نشوف مع الدكتورة إلا كنتي غاتجي الجمعة.\"**", "created_at": "2026-06-17T16:44:43.856879", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12397/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44933, "message_id": "AC71F9B70E6D4C7CDA68C04481469A66", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-06-17T16:45:06.657618", "media_url": null, "media_mime_type": null}, {"id": 46405, "message_id": "AC17F285B9770E9CE715AB0F38C11533", "sender": "user", "message_type": "text", "content": "Salam kif sba7to", "created_at": "2026-06-22T07:10:59.424996", "media_url": null, "media_mime_type": null}, {"id": 46406, "message_id": "ACA89BC9EC4DAA6539804AE2D52C304B", "sender": "user", "message_type": "text", "content": "Bghit n9olek 3la 7sab rendez vous dyal lyoma ma3adi n9darxi nji", "created_at": "2026-06-22T07:11:22.095657", "media_url": null, "media_mime_type": null}, {"id": 46407, "message_id": "AC006AE7E3444F6A3AA13CD913D271E7", "sender": "user", "message_type": "text", "content": "Wax n9edro nkhaliwah xi nhar akhor had simana", "created_at": "2026-06-22T07:11:34.675812", "media_url": null, "media_mime_type": null}, {"id": 46408, "message_id": "bot_AC006AE7E3444F6A3AA13CD913D271E7_6759", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 شكراً بزاف على الإخبار.", "created_at": "2026-06-22T07:11:58.657147", "media_url": null, "media_mime_type": null}, {"id": 46409, "message_id": "bot_AC006AE7E3444F6A3AA13CD913D271E7_523", "sender": "bot", "message_type": "text", "content": "غادي نبلغ الفريق بطلب تغيير الموعد ديالكوم اليوم، واش ممكن تقولي ليا الإسم الكامل ديالك باش نسجلو الطلب بشكل صحيح؟ وفاش الوقت اللي مناسبكوم هاد السيمانة؟\n\nواخا بلغنا الفريق وغادي يتواصلوا بيكوم إن شاء الله 🙏🏻", "created_at": "2026-06-22T07:11:58.714852", "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 3834 in training_review_items