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": 27811, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjY3MDcxODE5FQIAEhggQUNDRjZCQjIyRDVBOENCRTNGMzk0N0FFNjM2OEY4QzAA", "sender": "user", "message_type": "text", "content": "؟؟؟", "created_at": "2026-05-12T14:56:53.673098", "media_url": null, "media_mime_type": null}, {"id": 27813, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNjY3MDcxODE5FQIAEhggQUNDRjZCQjIyRDVBOENCRTNGMzk0N0FFNjM2OEY4QzAA_1811", "sender": "bot", "message_type": "text", "content": "مريم، راه توصلنا بالصورة ديالك وبلغنا الفريق الطبي باش يشوفو الحالة ديالك. غير صبري شوية، غادي يتواصلوا معاكوم هنا في أقرب وقت إن شاء الله.\n\nيلا كان الأمر مستعجل بزاف أو عندك ألم كبير، تقدري تتصلي مباشرة على: +212 660-022-263", "created_at": "2026-05-12T14:57:07.776954", "media_url": null, "media_mime_type": null}, {"id": 27869, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjY3MDcxODE5FQIAERggQTU4MUE5QkZCQTVBMTU0Qzk4QUVCREJENzNGMzBCQTAA", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-05-12T15:03:08.983834", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/8077/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 27877, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjY3MDcxODE5FQIAEhggQUNBNDBBRkY0ODE4OENBOUMxQkE2OEIwMDVDMDJGOUUA", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-05-12T15:07:57.548089", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/8080/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 27905, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjY3MDcxODE5FQIAERgWM0VCMDU4NkIyRjk0ODlDMTA2RDQ4MgA=", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*CHATT MARIAM*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mardi 19 mai 2026* à *15: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لديكم موعد مع ** يوم *الثلاثاء 19 ماي 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-12T15:29:02.403226", "media_url": null, "media_mime_type": null}, {"id": 31646, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjY3MDcxODE5FQIAERgWM0VCMDNFQkRGOENGRDRERTg4NDQ0NAA=", "sender": "bot", "message_type": "image", "content": "Salut *CHATT MARIAM*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mardi 19 mai 2026*\r\n🕘 Heure : *15: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-05-18T15:08:40.263413", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9130/download", "media_mime_type": "image/jpeg"}, {"id": 31658, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjY3MDcxODE5FQIAEhggQUNDRkQxNTgwMDA5Q0QwOEQ5MEJFQkQ1NUM4MzEzQUUA", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-05-18T15:15:03.802951", "media_url": null, "media_mime_type": null}, {"id": 31659, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjY3MDcxODE5FQIAEhggQUMxMTYxRjUyQUFFNzhFQTIwQUI4ODVDNjI0RDgwMDQA", "sender": "user", "message_type": "text", "content": "ان شاء الله نجي غذا", "created_at": "2026-05-18T15:16:32.022051", "media_url": null, "media_mime_type": null}, {"id": 37921, "message_id": "AC4A27076D460C12499C1837300FE855", "sender": "user", "message_type": "text", "content": "شكرا جزيلا", "created_at": "2026-06-02T09:33:25.000428", "media_url": null, "media_mime_type": null}, {"id": 37923, "message_id": "bot_AC4A27076D460C12499C1837300FE855_7813", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم مريم 😊 إذا احتاجيتي شي حاجة أخرى أنا هنا رهن الإشارة.", "created_at": "2026-06-02T09:33:38.814506", "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 3035 in training_review_items