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": 40894, "message_id": "3EB0DB88C84DF8463C36FA", "sender": "bot", "message_type": "image", "content": "Salut *BILAL MA XIAOHU*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mercredi 10 juin 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.\r\n", "created_at": "2026-06-09T15:03:48.651428", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11332/download", "media_mime_type": "image/jpeg"}, {"id": 40917, "message_id": "3A69C861C3FA43474655", "sender": "user", "message_type": "text", "content": "ok", "created_at": "2026-06-09T15:18:00.450956", "media_url": null, "media_mime_type": null}, {"id": 41275, "message_id": "3EB0886A29CBD98A734F27", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BILAL MA XIAOHU*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mercredi 17 juin 2026* à *09: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لديكم موعد مع ** يوم *الأربعاء 17 يونيو 2026* على الساعة *09:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-10T10:08:11.100625", "media_url": null, "media_mime_type": null}, {"id": 41319, "message_id": "3A41C2A84DF3F72D6818", "sender": "user", "message_type": "text", "content": "ما رأيك؟", "created_at": "2026-06-10T12:06:17.527059", "media_url": null, "media_mime_type": null}, {"id": 41323, "message_id": "3EB04A8529833411E54603", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BILAL MA XIAOHU*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mercredi 17 juin 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لديكم موعد مع ** يوم *الأربعاء 17 يونيو 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-10T12:11:54.090834", "media_url": null, "media_mime_type": null}, {"id": 41325, "message_id": "3ADAA5D46282198F1704", "sender": "user", "message_type": "text", "content": "كم من الوقت يستغرق إجراء عملية زراعة الأسنان بعد خلعها؟", "created_at": "2026-06-10T12:12:40.735318", "media_url": null, "media_mime_type": null}, {"id": 41326, "message_id": "A572349A9FB2E479F620355B987B82CA", "sender": "bot", "message_type": "text", "content": "<reply_to>كم من الوقت يستغرق إجراء عملية زراعة الأسنان بعد خلعها؟</reply_to> ساعتين", "created_at": "2026-06-10T12:13:10.648595", "media_url": null, "media_mime_type": null}, {"id": 41327, "message_id": "3A2E2A6F55E7E3A40EE2", "sender": "user", "message_type": "text", "content": "أنا أشير إلى دورة العلاج بأكملها.", "created_at": "2026-06-10T12:13:37.999771", "media_url": null, "media_mime_type": null}, {"id": 41401, "message_id": "3ADCABFD748D9DDD9D27", "sender": "user", "message_type": "text", "content": "？", "created_at": "2026-06-10T13:35:13.530436", "media_url": null, "media_mime_type": null}, {"id": 41409, "message_id": "A516358B690BA57E5E2220921DAAB677", "sender": "bot", "message_type": "text", "content": "سوف اسأل الدكتور", "created_at": "2026-06-10T13:39:08.085375", "media_url": null, "media_mime_type": null}, {"id": 42152, "message_id": "3ABB59A9698BA1E81D19", "sender": "user", "message_type": "text", "content": "？", "created_at": "2026-06-11T16:43:08.386310", "media_url": null, "media_mime_type": null}, {"id": 42154, "message_id": "bot_3ABB59A9698BA1E81D19_3962", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 أنا assistant ديال Centre Dentaire Tanger Bay. واش نقدر نعاونك بخصوص موعد، خدمة، ولا العنوان؟", "created_at": "2026-06-11T16:43:20.776827", "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 3427 in training_review_items