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": 38926, "message_id": "3EB0A702F49EF0B4554191", "sender": "bot", "message_type": "image", "content": "Salut *MERROUN EL OUAHABI Rime*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 05 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-04T15:03:01.840619", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10826/download", "media_mime_type": "image/jpeg"}, {"id": 38936, "message_id": "A507D96AD8BC54D38272ED0972B16FB6", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-06-04T15:08:19.793957", "media_url": null, "media_mime_type": null}, {"id": 38943, "message_id": "3EB0DCFD0192E89086A390", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MERROUN EL OUAHABI Rime*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 05 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لديكم موعد مع ** يوم *الجمعة 5 يونيو 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-04T15:39:21.303008", "media_url": null, "media_mime_type": null}, {"id": 39255, "message_id": "3EB052C129177C9A5B2422", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MERROUN  OUAHABI Rim*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 12 juin 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لديكم موعد مع ** يوم *الجمعة 12 يونيو 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-05T10:35:47.202574", "media_url": null, "media_mime_type": null}, {"id": 41296, "message_id": "3EB0339C2374CDABA75D58", "sender": "bot", "message_type": "text", "content": "Bonjour MERROUN  OUAHABI Rim", "created_at": "2026-06-10T10:56:36.073159", "media_url": null, "media_mime_type": null}, {"id": 41297, "message_id": "A55C0FF6C6D3862A67D33EDA24982F91", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-10T10:56:54.037548", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11443/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 41298, "message_id": "A55147721D0F80AF158B2B1E712FAB1C", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-10T10:57:59.277047", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11444/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 41307, "message_id": "A58A3CFB2A83EC630D2472D1E586DEEC", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-10T11:09:11.666864", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11450/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 41308, "message_id": "3EB0F470EAF1B2B2129B25", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MERROUN  OUAHABI Rim*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mercredi 17 juin 2026* à *16: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* على الساعة *16:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-10T11:09:16.334741", "media_url": null, "media_mime_type": null}, {"id": 41312, "message_id": "A5DBF141DF0F2742CDFD58C81DA70BD5", "sender": "user", "message_type": "text", "content": "C bon merci", "created_at": "2026-06-10T11:24:38.414912", "media_url": null, "media_mime_type": null}, {"id": 44069, "message_id": "A5FB10498DA2DE2F2D75EDAF791F1FB5", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-06-16T07:47:52.856600", "media_url": null, "media_mime_type": null}, {"id": 44070, "message_id": "bot_A5FB10498DA2DE2F2D75EDAF791F1FB5_3544", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Bienvenue au Centre Dentaire Tanger Bay, cabinet du Dr Haitham Boutaib. Comment puis-je vous aider ?", "created_at": "2026-06-16T07:48:05.229715", "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 3660 in training_review_items