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": 40392, "message_id": "3EB084815741B1A6A1890A", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABDELGHANI Elfarissi*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 12 juin 2026* à *17: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لديكم موعد مع ** يوم *الجمعة 12 يونيو 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-08T13:05:38.826427", "media_url": null, "media_mime_type": null}, {"id": 41293, "message_id": "A5DC6A584334441D4D1307E26BAB8656", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-10T10:55:42.334388", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11441/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 41294, "message_id": "3EB0CBC55C960C837F4E62", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABDELGHANI Elfarissi*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 15 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**\r\nلديكم موعد مع ** يوم *الأثنين 15 يونيو 2026* على الساعة *14:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-10T10:56:04.151564", "media_url": null, "media_mime_type": null}, {"id": 41295, "message_id": "A5E8C6FB7D7C740E9C60F9C52E86EC47", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-10T10:56:11.321884", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11442/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 41299, "message_id": "2AE80FD12E9ED9E6A5DF", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-10T10:58:08.834850", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11445/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 41305, "message_id": "A56920D388F066A521196CBBA7B3BC44", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-10T11:08:36.103387", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11449/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 41306, "message_id": "3EB0DABF8B85A1BDB63F23", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABDELGHANI Elfarissi*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 15 juin 2026* à *11: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لديكم موعد مع ** يوم *الأثنين 15 يونيو 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-10T11:08:43.069726", "media_url": null, "media_mime_type": null}, {"id": 41343, "message_id": "2ABC26A5362AD5EB4369", "sender": "user", "message_type": "text", "content": "مرحبا", "created_at": "2026-06-10T12:39:34.923002", "media_url": null, "media_mime_type": null}, {"id": 43350, "message_id": "2AB312404F70DEC6E38B", "sender": "user", "message_type": "text", "content": "سلام و عليكم عفاك غدا ان شاء الله مع 11:30 منقدرش نجي الى ممكن تغير لي في العشية", "created_at": "2026-06-14T23:18:48.128280", "media_url": null, "media_mime_type": null}, {"id": 43351, "message_id": "bot_2AB312404F70DEC6E38B_7998", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله 😊 ماشي مشكل، غادي نبلغ الفريق بطلب تغيير الموعد ديالك من 11:30 للصباح لشي وقت في العشية إن شاء الله.\n\nواخا بلغنا الفريق وغادي يتواصلوا بيكوم إن شاء الله 🙏🏻", "created_at": "2026-06-14T23:19:00.048677", "media_url": null, "media_mime_type": null}, {"id": 43352, "message_id": "2AF36617429999ED9D69", "sender": "user", "message_type": "text", "content": "شكرا", "created_at": "2026-06-14T23:19:21.934891", "media_url": null, "media_mime_type": null}, {"id": 43353, "message_id": "bot_2AF36617429999ED9D69_5001", "sender": "bot", "message_type": "text", "content": "العفو، مرحبا بك ديما! 😊 إذا احتجتي أي مساعدة أخرى أنا هنا.", "created_at": "2026-06-14T23:19:33.337262", "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 3579 in training_review_items