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": 11617, "message_id": "A54C161490F8CDF435015B521194239C", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nصباح الخير، كيدايرة؟ بيخير؟ لاباس؟ نوال...\n\n**Latin Script:**\nSbah lkhir, kidayra? Bikheir? Labas? Nawal...\n\n**English Translation (for context):**\nGood morning, how are you? Are you good? Is everything fine? Nawal...", "created_at": "2026-04-03T17:41:05.360392", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2879/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 11618, "message_id": "A55637FDEC65F2F430E0BA1E3E57C945", "sender": "bot", "message_type": "voice", "content": "[Voice message] صافي وخا، دابا نشوف معاك ونرد عليك.", "created_at": "2026-04-03T17:41:10.911424", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2880/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 11619, "message_id": "A5B5D0836CAE5C05C6486A32F8365D53", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"مزيان، بلاتي حتى يوصل الراديو، يوصلو الراديو اللي عملتي ويشوفو، عاد نقوليك فوقاش الرونديفو، ماشي غدا وماشي بعدو، حتى يوصلو ونرد عليك.\"\n\n**Latin Script (Transliteration):**\n\"Mzyan, blati hta ywsel l-radio, ywsel lih l-radio li derti w ychoufo, 3ad ngoulik foqach r-rendez-vous, machi ghda w machi be3dou, hta ywsel lih w nred 3lik.\"", "created_at": "2026-04-03T17:41:31.699202", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2881/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 11622, "message_id": "3AF0EE1978DB1F7B5D91", "sender": "user", "message_type": "text", "content": "Sf wakha", "created_at": "2026-04-03T17:41:51.793064", "media_url": null, "media_mime_type": null}, {"id": 11623, "message_id": "3A051B1CE842B7C06FDF", "sender": "user", "message_type": "text", "content": "Mohim dirili rendivo fasbh m3a 9 okk", "created_at": "2026-04-03T17:42:27.690371", "media_url": null, "media_mime_type": null}, {"id": 11625, "message_id": "A502BD65E8BBC323829D76A528A65387", "sender": "bot", "message_type": "voice", "content": "[Voice message] إليك تفريغ المقطع الصوتي باللهجة المغربية:\n\n\"حتى نرد عليك وصافي، مع التسعود غالبا ما كنبداوش مع التسعود، من الـ rendez-vous ما نعرف، بحق أنا قلت لك غدا وبعدو لا.\"", "created_at": "2026-04-03T17:44:05.520675", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2883/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 11632, "message_id": "3AA216FB95AEE4701C9D", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-04-03T17:51:55.344816", "media_url": null, "media_mime_type": null}, {"id": 11734, "message_id": "A5406395F5053749588E28ADF173A663", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**السلام عليكم، صباح الخير، كي صبحتي مزيانة؟ بخير؟ اليوم إن شاء الله عندك رنديفو مع الجوج ونص.**\n\n**Transliteration (Latin script):**\n\"Assalam o alaikum, sbah l'khir, ki sbahti mzyana? Bikhir? Lyom in sha Allah andek rendez-vous m'a l'jouj o nass.\"", "created_at": "2026-04-04T07:44:23.537543", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2912/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 11851, "message_id": "3A02C9A51E66DF5C449C", "sender": "user", "message_type": "text", "content": "Sbah khr sf wakha", "created_at": "2026-04-04T10:30:45.554466", "media_url": null, "media_mime_type": null}, {"id": 11857, "message_id": "bot_3A02C9A51E66DF5C449C_861", "sender": "bot", "message_type": "text", "content": "صباح النور Fatima 😊 الموعد ديالك اليوم مع الجوج ونص إن شاء الله. مرحبا بيكوم! إذا احتاجيتي شي توضيح ولا مساعدة أخرى، أنا هنا.", "created_at": "2026-04-04T10:31:37.674524", "media_url": null, "media_mime_type": null}, {"id": 11974, "message_id": "3AA0B12B009790DC951E", "sender": "user", "message_type": "text", "content": "Chwiya nkon m3ak sf tri9 3amra bzaff", "created_at": "2026-04-04T13:34:20.926612", "media_url": null, "media_mime_type": null}, {"id": 11975, "message_id": "bot_3AA0B12B009790DC951E_6685", "sender": "bot", "message_type": "text", "content": "ماشي مشكل Fatima، خدي راحتك، يلا تأخرتي شوية ما كاين باس، غير يلا وصلتي قولي لينا. مرحبا بيكوم 😊", "created_at": "2026-04-04T13:34:33.532950", "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 767 in training_review_items