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": 10975, "message_id": "3EB08FEE7D91171B912279", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: (a) Type of image: Unrelated (not dental-related).\n\n(b) Not applicable.\n\n(c) Visible text: \n- \"CALENDAR\"\n- \"Appointment Booking\"\n\n(d) Flag: The image is unrelated to dental content.\n\nUser message context: Bonjour DAHDOUH KAWTAR\r\nVous avez Rendez Vous avec Dr DINANI Hicham le vendredi 03 avril 2026 à 10: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لديكم موعد مع الدكتور ديناني هشام يوم الجمعة 3 أبريل 2026 على الساعة 10:30. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-04-02T17:05:20.827550", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/2675/download", "media_mime_type": "image/jpeg"}, {"id": 11139, "message_id": "3AF6C3A72F560A9C935D", "sender": "user", "message_type": "text", "content": "D‘accord ila kan momkin nji hta 12:30", "created_at": "2026-04-02T22:15:47.647662", "media_url": null, "media_mime_type": null}, {"id": 11140, "message_id": "bot_3AF6C3A72F560A9C935D_8751", "sender": "bot", "message_type": "text", "content": "Bonjour DAHDOUH KAWTAR 😊\n\nMerci pour votre message. Je vais transmettre votre demande de changement d'horaire à l'équipe. Ils vous contacteront pour confirmer si c'est possible de déplacer votre rendez-vous à 12:30. \n\nSi vous avez d'autres questions, n'hésitez pas à me le faire savoir !", "created_at": "2026-04-02T22:16:04.017605", "media_url": null, "media_mime_type": null}, {"id": 11141, "message_id": "3A626D17E3ADE1C94EAC", "sender": "user", "message_type": "text", "content": "🙏", "created_at": "2026-04-02T22:17:03.840772", "media_url": null, "media_mime_type": null}, {"id": 11142, "message_id": "3A2548853EBFE22DFD83", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-04-02T22:17:08.698347", "media_url": null, "media_mime_type": null}, {"id": 11143, "message_id": "bot_3A2548853EBFE22DFD83_689", "sender": "bot", "message_type": "text", "content": "Avec plaisir 😊 Si vous avez besoin de quoi que ce soit d'autre, n'hésitez pas à me le dire. Passez une excellente journée !", "created_at": "2026-04-02T22:17:21.331219", "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 692 in training_review_items