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": 5291, "message_id": "A55CAF8822924934C492C9F7675456F2", "sender": "user", "message_type": "voice", "content": "[Voice message] أنا بغيت غير راديو عافاك باش نعمر هاد الميتيي ديال هذا.", "created_at": "2026-03-16T13:23:14.386683", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/945/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 5292, "message_id": "bot_A55CAF8822924934C492C9F7675456F2_3150", "sender": "bot", "message_type": "text", "content": "سمعتك 😊 باش نتأكد من التفاصيل بشكل صحيح، واخا تكتب ليا شنو بالضبط اللي محتاج من الراديو؟", "created_at": "2026-03-16T13:23:26.424899", "media_url": null, "media_mime_type": null}, {"id": 5295, "message_id": "A5C73A0B9031B99965B354215B8774DA", "sender": "bot", "message_type": "text", "content": "<reply_to>[Audio Message]</reply_to> Ok", "created_at": "2026-03-16T13:41:44.269579", "media_url": null, "media_mime_type": null}, {"id": 5296, "message_id": "3EB072D2B4ED8AFE67FE02", "sender": "bot", "message_type": "document", "content": "ASRAR_SOUMIA_1899_12_30_PAN256_5.bmp", "created_at": "2026-03-16T13:42:03.098858", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/946/download", "media_mime_type": "image/bmp"}, {"id": 5304, "message_id": "A562D5CC96799AB9B1C2CCD46D294FD5", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-03-16T13:46:46.660867", "media_url": null, "media_mime_type": null}, {"id": 5305, "message_id": "bot_A562D5CC96799AB9B1C2CCD46D294FD5_2188", "sender": "bot", "message_type": "text", "content": "De rien 😊 Si vous avez besoin d'autres informations ou d'aide, n'hésitez pas à me le faire savoir !", "created_at": "2026-03-16T13:46:58.417715", "media_url": null, "media_mime_type": null}, {"id": 5854, "message_id": "A564E98C26E96494360CEEA5D61C7701", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-03-17T14:33:44.842833", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1141/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 5855, "message_id": "A59DBB7ED0A22151EDAB9ED1CD593A1D", "sender": "bot", "message_type": "text", "content": "<reply_to>[Audio Message]</reply_to> Ok", "created_at": "2026-03-17T14:34:24.885251", "media_url": null, "media_mime_type": null}, {"id": 7569, "message_id": "A56E139D3B360D69440B6E05A32253D0", "sender": "bot", "message_type": "text", "content": ".", "created_at": "2026-03-27T15:24:44.903146", "media_url": null, "media_mime_type": null}, {"id": 7571, "message_id": "A5346B409726278F1B6FA86880E9CB4E", "sender": "user", "message_type": "text", "content": "?", "created_at": "2026-03-27T15:24:57.795441", "media_url": null, "media_mime_type": null}, {"id": 7573, "message_id": "3EB0D8B4E1A2349B01EE06", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-27T15:25:23.548597", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1589/download", "media_mime_type": "image/jpeg"}, {"id": 7574, "message_id": "bot_A5346B409726278F1B6FA86880E9CB4E_1017", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 واش نقدر نعاونك بخصوص موعد، خدمة، ولا العنوان؟", "created_at": "2026-03-27T15:25:29.784902", "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 274 in training_review_items