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": 45307, "message_id": "3EB0723FB9647626254181", "sender": "user", "message_type": "document", "content": "260521001-lowerjaw.stl", "created_at": "2026-06-18T13:51:19.586004", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12517/download", "media_mime_type": "application/vnd.ms-pki.stl"}, {"id": 45309, "message_id": "3EB067089820C9DF231652", "sender": "user", "message_type": "document", "content": "Visualization_SurgicalGuide_46-47.stl", "created_at": "2026-06-18T13:51:58.390532", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12518/download", "media_mime_type": "application/vnd.ms-pki.stl"}, {"id": 45310, "message_id": "3EB0802B03E1C05B3D208F", "sender": "user", "message_type": "document", "content": "Visualization_SurgicalGuide_36.stl", "created_at": "2026-06-18T13:52:17.854296", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12519/download", "media_mime_type": "application/vnd.ms-pki.stl"}, {"id": 45311, "message_id": "3EB03B6E5A21F807E117E3", "sender": "user", "message_type": "document", "content": "Visualization_SurgicalGuide_24-25.stl", "created_at": "2026-06-18T13:52:17.859383", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12520/download", "media_mime_type": "application/vnd.ms-pki.stl"}, {"id": 46617, "message_id": "A5FC8C7FEA5B9B8B01EDE531F840F820", "sender": "bot", "message_type": "document", "content": "EL HMIDI_MOHAMED_1986_7_2.zip", "created_at": "2026-06-22T11:19:46.400782", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12931/download", "media_mime_type": "application/zip"}, {"id": 47368, "message_id": "3EB0D230B9641C7F3079AB", "sender": "user", "message_type": "text", "content": "FTAH MEAK COMPTE DYALK", "created_at": "2026-06-23T12:00:59.989080", "media_url": null, "media_mime_type": null}, {"id": 47372, "message_id": "bot_3EB0D230B9641C7F3079AB_9259", "sender": "bot", "message_type": "text", "content": "غادي نبلغ الفريق الطبي ديالنا وغادي يتواصلوا معكوم في أقرب وقت إن شاء الله 🙏🏻", "created_at": "2026-06-23T12:01:17.198034", "media_url": null, "media_mime_type": null}, {"id": 47373, "message_id": "A508875B82643197BA63E7C5305732B4", "sender": "bot", "message_type": "text", "content": "Ok", "created_at": "2026-06-23T12:01:40.845197", "media_url": null, "media_mime_type": null}, {"id": 50225, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjYyMTk0Nzc2FQIAEhgUMkE0N0Y4NjBCRjZENEY5RDdENTgA", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-07-01T20:45:34.655813", "media_url": null, "media_mime_type": null}, {"id": 50226, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNjYyMTk0Nzc2FQIAEhgUMkE0N0Y4NjBCRjZENEY5RDdENTgA_8907", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Tanger Bay وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-07-01T20:45:48.152488", "media_url": null, "media_mime_type": null}, {"id": 50227, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjYyMTk0Nzc2FQIAEhgUMkFDNjczRjE3NjcxMTMyQjdEQ0IA", "sender": "user", "message_type": "text", "content": "Bchal consultation", "created_at": "2026-07-01T20:45:58.173413", "media_url": null, "media_mime_type": null}, {"id": 50228, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNjYyMTk0Nzc2FQIAEhgUMkFDNjczRjE3NjcxMTMyQjdEQ0IA_5850", "sender": "bot", "message_type": "text", "content": "consultation عندنا بـ 200DH 😊 واش بغيتو شي موعد؟", "created_at": "2026-07-01T20:46:10.362387", "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 4163 in training_review_items