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": 40232, "message_id": "3A88BAA6551744AF8EBB", "sender": "user", "message_type": "text", "content": "ممكن موعد", "created_at": "2026-06-08T07:59:47.929320", "media_url": null, "media_mime_type": null}, {"id": 40233, "message_id": "bot_3A88BAA6551744AF8EBB_3326", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 باش نحجزو ليكوم موعد، واخا تقولو الإسم الكامل ديالكوم، شنو العلاج اللي محتاجين، وفاش الوقت اللي مناسبكوم إن شاء الله؟", "created_at": "2026-06-08T08:00:02.302371", "media_url": null, "media_mime_type": null}, {"id": 40234, "message_id": "3AE7BF3223A8AD7BC6CF", "sender": "user", "message_type": "text", "content": "فوزية انويشف تسوس الأسنان", "created_at": "2026-06-08T08:00:37.325358", "media_url": null, "media_mime_type": null}, {"id": 40235, "message_id": "3AE1765A71B9E6C63639", "sender": "user", "message_type": "text", "content": "الثلاثاء", "created_at": "2026-06-08T08:00:43.365446", "media_url": null, "media_mime_type": null}, {"id": 40236, "message_id": "3A4DE02BAC7DBD843132", "sender": "user", "message_type": "text", "content": "14", "created_at": "2026-06-08T08:00:47.120178", "media_url": null, "media_mime_type": null}, {"id": 40240, "message_id": "bot_3A4DE02BAC7DBD843132_1967", "sender": "bot", "message_type": "text", "content": "مرحبا فوزية انويشف 😊 وصل الطلب ديالك، والفريق غادي يتواصل معاك باش يأكد الموعد ديالك لعلاج تسوس الأسنان يوم الثلاثاء مع 14h إن شاء الله.", "created_at": "2026-06-08T08:01:03.575976", "media_url": null, "media_mime_type": null}, {"id": 40241, "message_id": "bot_3A4DE02BAC7DBD843132_3002", "sender": "bot", "message_type": "text", "content": "دير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-06-08T08:01:03.635570", "media_url": null, "media_mime_type": null}, {"id": 40242, "message_id": "3AD0D2D60CD688556C8F", "sender": "user", "message_type": "text", "content": "اه حسنا", "created_at": "2026-06-08T08:01:29.567744", "media_url": null, "media_mime_type": null}, {"id": 40243, "message_id": "A54B5B4C8375A3CF1F52EE89BF3A4551", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-08T08:03:40.492420", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11169/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40244, "message_id": "3AE3DDA3ECEE4FD53269", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-06-08T08:12:41.941412", "media_url": null, "media_mime_type": null}, {"id": 42404, "message_id": "3A618593D7B89F861935", "sender": "user", "message_type": "text", "content": "Salm", "created_at": "2026-06-12T07:38:46.995036", "media_url": null, "media_mime_type": null}, {"id": 42405, "message_id": "bot_3A618593D7B89F861935_4220", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Tanger Bay وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-06-12T07:38:59.674753", "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 3458 in training_review_items