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": 41989, "message_id": "3EB0F0CD73FEEE86195171", "sender": "bot", "message_type": "document", "content": "2026061112292219.pdf", "created_at": "2026-06-11T11:30:33.028743", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11622/download", "media_mime_type": "application/pdf"}, {"id": 41991, "message_id": "3EB032C6EED9ED16D0C33E", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ISMAEL Fatima*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 18 juin 2026* à *12: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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-11T11:31:10.621045", "media_url": null, "media_mime_type": null}, {"id": 42952, "message_id": "3AFAA4012E998973D6BC", "sender": "user", "message_type": "text", "content": "Salam, I need to rebook my appointment to the 17th. Would you do that for me?😃", "created_at": "2026-06-13T18:26:19.944820", "media_url": null, "media_mime_type": null}, {"id": 42955, "message_id": "bot_3AFAA4012E998973D6BC_3741", "sender": "bot", "message_type": "text", "content": "Bonjour Fatima 😊 Pas de souci, j'ai transmis votre demande de déplacement au 17 juin à l'équipe.", "created_at": "2026-06-13T18:27:22.250772", "media_url": null, "media_mime_type": null}, {"id": 42956, "message_id": "bot_3AFAA4012E998973D6BC_7383", "sender": "bot", "message_type": "text", "content": "Ils vont vérifier la disponibilité et vous recontacter rapidement.", "created_at": "2026-06-13T18:27:22.316605", "media_url": null, "media_mime_type": null}, {"id": 42957, "message_id": "bot_3AFAA4012E998973D6BC_9163", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-13T18:27:22.386945", "media_url": null, "media_mime_type": null}, {"id": 42959, "message_id": "A57357936B63E7F2F9CF3D12D663DCF2", "sender": "bot", "message_type": "voice", "content": "[Voice message] أه حتى لـ 12 و نص نكون ساليت، نمشي لعند زينب بالخير، و حتى لداك الساعة نشوف الكابيني و نتأكد من الـ rendez-vous و نرد عليك، صافي؟", "created_at": "2026-06-13T18:28:23.113193", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11866/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 42960, "message_id": "3ADB773B4149FFEB1306", "sender": "user", "message_type": "text", "content": "Chokraan bzaaf😃", "created_at": "2026-06-13T18:33:23.498661", "media_url": null, "media_mime_type": null}, {"id": 43319, "message_id": "3AD8B51A161605B1951F", "sender": "user", "message_type": "text", "content": "Salam, at what time can I come on the 17th?", "created_at": "2026-06-14T19:38:24.524896", "media_url": null, "media_mime_type": null}, {"id": 43323, "message_id": "bot_3AD8B51A161605B1951F_6987", "sender": "bot", "message_type": "text", "content": "Merci pour votre message Fatima 😊 J'ai bien noté que vous souhaitez connaître les horaires disponibles pour le 17 juin.", "created_at": "2026-06-14T19:38:44.378344", "media_url": null, "media_mime_type": null}, {"id": 43324, "message_id": "bot_3AD8B51A161605B1951F_8620", "sender": "bot", "message_type": "text", "content": "L'équipe va vérifier les créneaux et vous recontactera très vite pour vous proposer une heure.", "created_at": "2026-06-14T19:38:44.440095", "media_url": null, "media_mime_type": null}, {"id": 43325, "message_id": "bot_3AD8B51A161605B1951F_2454", "sender": "bot", "message_type": "text", "content": "Si vous avez une préférence d'horaire, n'hésitez pas à la préciser !", "created_at": "2026-06-14T19:38:44.507226", "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 3572 in training_review_items