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": 41231, "message_id": "3EB06D43185577E2526E36", "sender": "bot", "message_type": "image", "content": " ", "created_at": "2026-06-10T08:51:17.015733", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11419/download", "media_mime_type": "image/jpeg"}, {"id": 41232, "message_id": "3EB02817B5B334CABE1EFB", "sender": "bot", "message_type": "image", "content": " ", "created_at": "2026-06-10T08:51:31.712752", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11420/download", "media_mime_type": "image/jpeg"}, {"id": 41233, "message_id": "3EB0C794C48CDB23F8718D", "sender": "bot", "message_type": "image", "content": " ", "created_at": "2026-06-10T08:51:46.438627", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11421/download", "media_mime_type": "image/jpeg"}, {"id": 41242, "message_id": "AC030EDB667691CBA9554F36FCEF6DBC", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-06-10T09:07:34.383510", "media_url": null, "media_mime_type": null}, {"id": 41244, "message_id": "3EB0A139F18CB2CBE81958", "sender": "bot", "message_type": "document", "content": "20260610_10074030.pdf", "created_at": "2026-06-10T09:08:28.244252", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11425/download", "media_mime_type": "application/pdf"}, {"id": 41245, "message_id": "A5EB40E02310C7FF678192D7067DFEAA", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-10T09:08:41.053313", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11426/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 41249, "message_id": "ACFEF37FF4F4113A0E149A200000021E", "sender": "user", "message_type": "text", "content": "Sbah khir  ok merci", "created_at": "2026-06-10T09:09:27.601502", "media_url": null, "media_mime_type": null}, {"id": 41250, "message_id": "A5647914BABFAD1F8F975AC00BF11E6E", "sender": "bot", "message_type": "text", "content": "Marhba", "created_at": "2026-06-10T09:09:53.591063", "media_url": null, "media_mime_type": null}, {"id": 41251, "message_id": "3EB01746A581D56C12B567", "sender": "bot", "message_type": "document", "content": "_radios_EL HMIDI Mohamed_20260610_10094115.pdf", "created_at": "2026-06-10T09:10:26.352321", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11427/download", "media_mime_type": "application/pdf"}, {"id": 41252, "message_id": "A54202A7EE56C42A911A2CDF2072A06C", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-10T09:10:33.745777", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11428/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 46472, "message_id": "ACC17974E5603B3BE99B4EAF3E64AB6B", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-06-22T09:05:50.773946", "media_url": null, "media_mime_type": null}, {"id": 46473, "message_id": "bot_ACC17974E5603B3BE99B4EAF3E64AB6B_9630", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Tanger Bay وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-06-22T09:06:02.290193", "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 3838 in training_review_items