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": 39715, "message_id": "A5FEAC7FF62077B7900D427708096F20", "sender": "bot", "message_type": "text", "content": "Safi wakha", "created_at": "2026-06-06T09:27:50.905515", "media_url": null, "media_mime_type": null}, {"id": 39717, "message_id": "3EB06BE922F098E80BF046", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL KHAMLICHI Oufae*\r\nVous avez Rendez Vous avec *Dr. RIAD GUENNOUNI* le *mardi 09 juin 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*EL KHAMLICHI*\r\nلديكم موعد مع ** يوم *الثلاثاء 9 يونيو 2026* على الساعة *14:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-06T09:28:56.426106", "media_url": null, "media_mime_type": null}, {"id": 39743, "message_id": "3A22168BA9DA8FD9FAA2", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-06-06T09:49:01.751986", "media_url": null, "media_mime_type": null}, {"id": 39745, "message_id": "3EB05946C34DFFF8095BED", "sender": "bot", "message_type": "text", "content": "mrhba", "created_at": "2026-06-06T09:51:38.782816", "media_url": null, "media_mime_type": null}, {"id": 40422, "message_id": "3A5F4C2C2C63E233DD6D", "sender": "user", "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 (Phonetic):**\nSalam oulaykum khti, kif ntina? Mezyana? Bikher? Choufi ha homa 3tawni scanner, ha homa ghaysiftohom lek daba, incha'Allah ya rabbi, choufi lna scanner...\n\n**Translation (for context):**\n\"Peace be upon you my sister, how are you? Are you good? Fine? Look, they gave me the scans, they are going to send them to you now, God willing. Look at the scans for us...\"", "created_at": "2026-06-08T14:20:44.159357", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11216/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40426, "message_id": "bot_3A5F4C2C2C63E233DD6D_6075", "sender": "bot", "message_type": "text", "content": "فهمتكوم، ولكن أنا غير مجرد مساعد آلي وماعنديش دراية بلي واقع برا هاد المحادثة. بعثنا طلبكوم للفريق وغادي يتواصلوا بيكوم إن شاء الله 🙏🏻", "created_at": "2026-06-08T14:22:09.216531", "media_url": null, "media_mime_type": null}, {"id": 40444, "message_id": "3EB072A5EC2E40661120B4", "sender": "bot", "message_type": "image", "content": "Salut *EL KHAMLICHI Oufae*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. RIAD GUENNOUNI*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mardi 09 juin 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.\r\n", "created_at": "2026-06-08T15:04:04.138818", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11226/download", "media_mime_type": "image/jpeg"}, {"id": 40832, "message_id": "3A75833011F9429159D3", "sender": "user", "message_type": "text", "content": "Endi ghada rendezvous f 2 w akhor f 5", "created_at": "2026-06-09T14:01:18.620109", "media_url": null, "media_mime_type": null}, {"id": 40833, "message_id": "A55559292A066CD97A2C5935FF079198", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-09T14:04:20.489555", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11324/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40834, "message_id": "3AD08524F144F01E6049", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-09T14:04:41.086045", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11325/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43339, "message_id": "3A1941281F378D8B153B", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم حبيبة، كيف ستي مزيانة بخير؟ شوف ديك ساعة ديري لي رانديفو بسميتي، الخميس الجاي، نهار الثلاثاء في الصباح صافي؟", "created_at": "2026-06-14T22:05:56.810387", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11950/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43340, "message_id": "bot_3A1941281F378D8B153B_4372", "sender": "bot", "message_type": "text", "content": "مرحبا! 😊 باش نتأكد من طريقة كتابة الإسم، واخا تكتبوه ليا؟ وأيضا واش ممكن توضحي ليا شنو نوع العلاج أو السبب اللي محتاجة عليه الموعد؟", "created_at": "2026-06-14T22:06:21.672048", "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 3576 in training_review_items