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": 33876, "message_id": "AC90AE6613C99CBF43D5BCED18FDAF71", "sender": "bot", "message_type": "text", "content": "Bonjour Mme malika j'ai essayé de vous appeler mais sans réponse", "created_at": "2026-05-22T10:46:33.458792", "media_url": null, "media_mime_type": null}, {"id": 33893, "message_id": "AC7177FDBAD0288FADC88E967963BBB8", "sender": "user", "message_type": "text", "content": "Bonjour je vous rappelle", "created_at": "2026-05-22T10:53:51.265723", "media_url": null, "media_mime_type": null}, {"id": 33894, "message_id": "ACD5D223E487B912633CEBE5D99E94C9", "sender": "user", "message_type": "text", "content": "🙏", "created_at": "2026-05-22T10:53:56.933386", "media_url": null, "media_mime_type": null}, {"id": 38980, "message_id": "3EB075F46D15BE02485696", "sender": "bot", "message_type": "image", "content": "Bonjour MARBOUH MALIKA\r\nVous avez Rendez Vous avec Dr DINANI Hicham le vendredi 05 juin 2026 à 17:30 .\r\nEn cas d'empêchement, veuillez contactre la réception pour prendre un autre Rendez Vous.\r\nMerci pour votre attention.\r\n \r\nمرحبًا\r\n  \r\nلديكم موعد مع الدكتور ديناني هشام يوم الجمعة 5 يونيو 2026 على الساعة 17:30. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-06-04T17:03:45.565321", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10845/download", "media_mime_type": "image/jpeg"}, {"id": 39091, "message_id": "ACA20C19C708429A7EBD8A7AB1941498", "sender": "user", "message_type": "text", "content": "C confirmé et je souhaite venir bien avant 17h30 ou cas où il y pas bcp de personne pour passer", "created_at": "2026-06-04T20:27:51.694228", "media_url": null, "media_mime_type": null}, {"id": 39092, "message_id": "AC51C21F864966F235E5D9545D545D49", "sender": "user", "message_type": "text", "content": "🙏", "created_at": "2026-06-04T20:27:56.621855", "media_url": null, "media_mime_type": null}, {"id": 39093, "message_id": "bot_AC51C21F864966F235E5D9545D545D49_1241", "sender": "bot", "message_type": "text", "content": "Merci pour votre message Malika.", "created_at": "2026-06-04T20:28:34.083666", "media_url": null, "media_mime_type": null}, {"id": 39094, "message_id": "bot_AC51C21F864966F235E5D9545D545D49_3673", "sender": "bot", "message_type": "text", "content": "Votre rendez-vous est bien noté pour vendredi 5 juin à 17h30.", "created_at": "2026-06-04T20:28:34.146275", "media_url": null, "media_mime_type": null}, {"id": 39095, "message_id": "bot_AC51C21F864966F235E5D9545D545D49_6519", "sender": "bot", "message_type": "text", "content": "Si vous arrivez plus tôt, nous ferons de notre mieux pour vous recevoir rapidement selon l’affluence, mais la priorité reste aux rendez-vous déjà programmés.", "created_at": "2026-06-04T20:28:34.200236", "media_url": null, "media_mime_type": null}, {"id": 39096, "message_id": "bot_AC51C21F864966F235E5D9545D545D49_1435", "sender": "bot", "message_type": "text", "content": "N’hésitez pas à venir, on vous accueillera avec plaisir !", "created_at": "2026-06-04T20:28:34.255807", "media_url": null, "media_mime_type": null}, {"id": 39097, "message_id": "ACAC963563F1EED88656810E6F34F66A", "sender": "user", "message_type": "text", "content": "OK merci", "created_at": "2026-06-04T20:29:17.404526", "media_url": null, "media_mime_type": null}, {"id": 39098, "message_id": "bot_ACAC963563F1EED88656810E6F34F66A_5856", "sender": "bot", "message_type": "text", "content": "Avec plaisir Malika ! À très bientôt au centre 😊", "created_at": "2026-06-04T20:29:33.984682", "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 3161 in training_review_items