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": 7023, "message_id": "3EB0DDEB919D45F610B89B", "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 an illustrated character resembling a smiling tooth holding a checklist with a green checkmark. The background resembles a dental clinic setting with blurred elements suggesting a dental chair and equipment. At the top, there is a logo with the words 'TANGER BAY DENTAL CENTER' and a stylized tooth design. Texts 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and 'CHEZ TANGER BAY DENTAL CENTER' are prominently displayed.\",\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    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n\nUser message context: Salut *AHMIMED BAISAR RASHID*👋\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 : *10: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-03-26T15:06:19.197077", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1417/download", "media_mime_type": "image/jpeg"}, {"id": 7039, "message_id": "AC278E9BDD3277D7BFD606EE2863BA3E", "sender": "user", "message_type": "text", "content": "<reply_to>Salut *AHMIMED BAISAR RASHID*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *ven...</reply_to> Oui", "created_at": "2026-03-26T15:12:42.038789", "media_url": null, "media_mime_type": null}, {"id": 7322, "message_id": "3EB09D7C72564F5250D68B", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*AHMIMED BAISAR RASHID*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mercredi 01 avril 2026* à *16: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لديكم موعد مع ** يوم *الأربعاء 1 أبريل 2026* على الساعة *16:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-27T08:42:28.583400", "media_url": null, "media_mime_type": null}, {"id": 7391, "message_id": "A5EFCA05EA50379CA279A26ED92AC11D", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nالسلام، بيخير، مزيان رشيدة؟ سمحي ليا والله هاد النهار عندي عامر. ستيتش د خذا رونديفو د الحداش كونفيرمي، كلشي عندي عامر. داك الوقت اللي كان عندي خاوي أيخليها مع نهيلة وصافي.\n\n**Latin Script (Darija Transcription):**\n\"Salam, bikhir, mizyan Rachida? Smhi liya wallah had nhar 3andi 3amer. Stitch d khda randivou d l’hdach confirmer, kolchi 3andi 3amer. Dak l’weqt li kan 3andi khawi aykheliha m3a Nohaila o safi.\"\n\n**Language breakdown:**\n*   **Darija:** The majority of the speech.\n*   **French:** \"Confirmer\" (Confirmed), \"Randivou\" (Rendez-vous/Appointment).\n*   **English/Name:** \"Stitch\" (likely a nickname or name).", "created_at": "2026-03-27T10:19:46.452032", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1524/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7392, "message_id": "ACF30EBA31B9D4271C717D23116222EE", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-03-27T10:23:39.247165", "media_url": null, "media_mime_type": null}, {"id": 7393, "message_id": "AC5283E5C69C53A704D954DB7C49E469", "sender": "user", "message_type": "text", "content": "15:30 alyouma walo?", "created_at": "2026-03-27T10:24:18.051767", "media_url": null, "media_mime_type": null}, {"id": 7397, "message_id": "A5D9673B4C42030D1552DF02AD80DCC7", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic and Latin scripts:\n\n**Arabic script:**\nأويلي والله العظيم إلا عندي كلشي عامر، إي والله.\n\n**Latin script (Darija):**\nWili wallah l-3adim illa 3andi kulshi 3amr, ay wallah.\n\n**Translation (for context):**\n\"Oh my God, I swear to God everything [I have] is full/busy, yeah I swear.\"", "created_at": "2026-03-27T10:40:20.023991", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1527/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7418, "message_id": "ACDDA4EEEDD1DD6D1E2E9AF1ED65F860", "sender": "user", "message_type": "text", "content": "Ok no problem \n\nShukran bzef", "created_at": "2026-03-27T11:27:54.330754", "media_url": null, "media_mime_type": null}, {"id": 7419, "message_id": "ACDF2822A7F1B98DFA1F195D66D5B5EC", "sender": "user", "message_type": "text", "content": "Ou ghada sebt ?", "created_at": "2026-03-27T11:28:04.090465", "media_url": null, "media_mime_type": null}, {"id": 7528, "message_id": "3EB0CBC7C268FB60269605", "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 cartoonish smiling tooth character giving a thumbs-up and holding a notepad with a large green checkmark. Text is overlaid on the image reading 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and 'CHEZ TANGER BAY DENTAL CENTER.' The background is an out-of-focus dental office setting with a dental chair and other typical elements visible.\",\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  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"The image is an advertisement or confirmation\n\nUser message context: Salut *AHMIMED BAISAR RASHID*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 28 mars 2026*\r\n🕘 Heure : *12: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-03-27T15:05:05.256916", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1577/download", "media_mime_type": "image/jpeg"}, {"id": 7548, "message_id": "ACA87B056F9000C6EDB1877D5DCD95B3", "sender": "user", "message_type": "text", "content": "<reply_to>Salut *AHMIMED BAISAR RASHID*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *sam...</reply_to> Oui", "created_at": "2026-03-27T15:12:14.478003", "media_url": null, "media_mime_type": null}, {"id": 7552, "message_id": "bot_ACA87B056F9000C6EDB1877D5DCD95B3_4177", "sender": "bot", "message_type": "text", "content": "Merci pour votre confirmation, AHMIMED BAISAR RASHID 😊 Votre rendez-vous avec Dr. Haitham Boutaib est bien confirmé pour le samedi 28 mars 2026 à 12:30. À bientôt chez Tanger Bay Dental Center إن شاء الله 🙏🏻", "created_at": "2026-03-27T15:13:15.279571", "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 267 in training_review_items