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": 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}, {"id": 44071, "message_id": "A5B046D1EC68350CC715641B8CFDF944", "sender": "user", "message_type": "text", "content": "Merci de me confirmer le maintien du rdv pour demain car c férié", "created_at": "2026-06-16T07:48:34.939381", "media_url": null, "media_mime_type": null}, {"id": 44072, "message_id": "bot_A5B046D1EC68350CC715641B8CFDF944_8739", "sender": "bot", "message_type": "text", "content": "Merci pour votre message !", "created_at": "2026-06-16T07:48:47.578857", "media_url": null, "media_mime_type": null}, {"id": 44073, "message_id": "bot_A5B046D1EC68350CC715641B8CFDF944_8758", "sender": "bot", "message_type": "text", "content": "Je ne peux pas confirmer directement le maintien du rendez-vous, mais je transmets votre demande à l’équipe qui va vous recontacter rapidement pour vous confirmer si le rendez-vous de demain est maintenu malgré le jour férié.", "created_at": "2026-06-16T07:48:47.654429", "media_url": null, "media_mime_type": null}, {"id": 44074, "message_id": "bot_A5B046D1EC68350CC715641B8CFDF944_3142", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-16T07:48:47.717960", "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 3661 in training_review_items