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": 9980, "message_id": "3A3810BE374CE9A2B040", "sender": "user", "message_type": "text", "content": "Safy wakha sebt li maji mzyana", "created_at": "2026-04-01T10:12:32.572455", "media_url": null, "media_mime_type": null}, {"id": 9981, "message_id": "A57BB90E1F47CC0739EAD01508FF6C08", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-01T10:13:50.677650", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2356/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 9982, "message_id": "3EB001E478E932CFF054CA", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HADDIOUI Rym *\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 11 avril 2026* à *11: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لديكم موعد مع ** يوم *السبت 11 أبريل 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-01T10:14:16.112606", "media_url": null, "media_mime_type": null}, {"id": 13203, "message_id": "3EB0A3AB6BD5F73FE7708D", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HADDIOUI Rym *\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 11 avril 2026* à *10: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لديكم موعد مع ** يوم *السبت 11 أبريل 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-09T15:50:32.046543", "media_url": null, "media_mime_type": null}, {"id": 13211, "message_id": "A50062E1DD77EEAA57E7B8220D341DD6", "sender": "bot", "message_type": "voice", "content": "[Voice message] أكيد، إليك تفريغ المقطع الصوتي باللهجة المغربية:\n\n\"صباح الخير كي صبحتي مزيانة؟ ريما عندك رونديفو نهار السبت إن شاء الله مع العشرة دالصباح. حيت الدكتور ما غيكونش فالعشية، عليها باش غنبداو بكري.\"", "created_at": "2026-04-09T15:51:52.089699", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3379/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13429, "message_id": "3AC29B143C308B99579C", "sender": "user", "message_type": "text", "content": "Ook inchaallah", "created_at": "2026-04-10T08:30:16.004187", "media_url": null, "media_mime_type": null}, {"id": 13633, "message_id": "3EB0338AD1E759D9A07A32", "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\": \"This image shows a digitally created cartoon tooth character with a smiling face, black eyes, and holding a calendar or notepad with a green check mark. The background resembles a dental clinic environment, featuring a blurred dental chair and cabinetry. At the top of the image are the words 'TANGER BAY DENTAL CENTER' alongside a logo depicting a stylized tooth. There are two bold blue banners with white text: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green check mark, and beneath it 'CHEZ TANGER BAY DENTAL CENTER'. The overall color palette is light blue and white, conveying a clean clinic aesthetic.\",\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    \"other_findings\": \"\"\n  },\n  \"text_visible\": [\n    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS\n\nUser message context: Salut *HADDIOUI Rym *👋\r\nNous vous confirmons votre rendez-vous avec *DR ALAMI MUSTAPHA*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 11 avril 2026*\r\n🕘 Heure : *10: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-04-10T15:03:39.882592", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3498/download", "media_mime_type": "image/jpeg"}, {"id": 13637, "message_id": "3A9C41DB63836D556B55", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-04-10T15:04:46.942864", "media_url": null, "media_mime_type": null}, {"id": 13950, "message_id": "3A51CCA237D8F1B0DD30", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم ça va بخير؟ s'il te plaît عافاك ماتنسانيش تسقسي docteur تأكد لي بلي - بلي l'ortho ديال 18000 درهم. حيت داك النهار كان قالي docteur هيثم بلي ديال 18000 درهم فيه les élastiques، واليوم كنت عاود زعما كنت كنتسناه يعملي les élastiques ولكن مِلّي (ديال) ماعملهمليشي بحال دخلني الشك واش هو - واش مِلّي ديال 18000 درهم أولا لا. واخا تأكد لي s'il te plaît. المهم أنا راه كنت صيفطت ليكم 30%، 5400 درهم هي 30% ديال 18000 درهم. غير pour confirmer وصافي، صافي؟ يالاه شكرا بزاف نهاركم مبروك.", "created_at": "2026-04-11T10:45:07.125462", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3612/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15425, "message_id": "3ABDE67D589367B52969", "sender": "user", "message_type": "text", "content": "Bonjour , j’espère que vous allez bien", "created_at": "2026-04-14T10:50:34.347259", "media_url": null, "media_mime_type": null}, {"id": 15426, "message_id": "3A2D65E9D9EFCDA541AE", "sender": "user", "message_type": "text", "content": "Fuqach aykun andi le prochain rendez vous inchaallah", "created_at": "2026-04-14T10:50:34.623482", "media_url": null, "media_mime_type": null}, {"id": 15427, "message_id": "bot_3A2D65E9D9EFCDA541AE_6133", "sender": "bot", "message_type": "text", "content": "Bonjour Rym 😊\n\nVotre dernier rendez-vous confirmé était le samedi 11 avril 2026 à 10:00 avec Dr Alami Mustapha. Pour connaître la date de votre prochain rendez-vous ou en fixer un nouveau, l’équipe va vérifier et vous recontactera rapidement إن شاء الله.\n\nالفريق غادي يتواصلوا معاكوم إن شاء الله باش يعطيوكوم التفاصيل.", "created_at": "2026-04-14T10:51:00.288877", "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 1123 in training_review_items