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": 8636, "message_id": "3A25F6E49A2C9B508F5D", "sender": "user", "message_type": "text", "content": "Merci ☺️", "created_at": "2026-03-30T10:03:26.010736", "media_url": null, "media_mime_type": null}, {"id": 8639, "message_id": "bot_3A25F6E49A2C9B508F5D_9200", "sender": "bot", "message_type": "text", "content": "De rien ! 😊 Si vous avez besoin d'aide ou si vous avez des questions, n'hésitez pas à me le faire savoir. Je suis là pour vous aider !", "created_at": "2026-03-30T10:03:40.198969", "media_url": null, "media_mime_type": null}, {"id": 8664, "message_id": "ACD03A8FB2407F8664E83B4C5E28B66A", "sender": "bot", "message_type": "text", "content": "Jeudi à 18:15", "created_at": "2026-03-30T10:12:46.155505", "media_url": null, "media_mime_type": null}, {"id": 10279, "message_id": "3EB0E92C98451EE78DC798", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: (a) Type of image: Unrelated (illustration/graphic).\n\n(b) If dental: Not applicable.\n\n(c) Visible text (OCR): \n- CALENDAR\n- Appointment Booking\n\n(d) Flag: None.\n\nUser message context: Bonjour Kabran Larissa\r\nVous avez Rendez Vous avec Dr DINANI Hicham le jeudi 02 avril 2026 à 18:15 .\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لديكم موعد مع الدكتور ديناني هشام يوم الخميس 2 أبريل 2026 على الساعة 18:15. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-04-01T17:07:52.752919", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/2463/download", "media_mime_type": "image/jpeg"}, {"id": 10281, "message_id": "3A94BEA9D574442ABAE9", "sender": "user", "message_type": "text", "content": "D’accord", "created_at": "2026-04-01T17:08:28.894542", "media_url": null, "media_mime_type": null}, {"id": 10282, "message_id": "bot_3A94BEA9D574442ABAE9_9875", "sender": "bot", "message_type": "text", "content": "Parfait, Kabran Larissa ! Nous vous attendons le jeudi 2 avril 2026 à 18:15. Si vous avez besoin de quoi que ce soit d'autre, n'hésitez pas à me le faire savoir. À bientôt ! 😊", "created_at": "2026-04-01T17:08:44.130316", "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 560 in training_review_items