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": 13810, "message_id": "A5F207F77B724EAB5BFA8BB5017A0AC3", "sender": "bot", "message_type": "voice", "content": "[Voice message] إليك تفريغ المقطع الصوتي باللهجة المغربية:\n\n\"السلام عليكم، لاباس؟ بخير، مزيانة؟ بالنسبة للتبييض ديالينا حنا عندنا تبييض زعما مزيان وفنفس الوقت ما كيضرش زعما السنان ماشي بحال لي صونطر العاديين لي كيعملو التبييض.\"", "created_at": "2026-04-10T19:50:12.040029", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3567/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13811, "message_id": "A5D2C6C9A56945E26EE682AE66FF86EB", "sender": "bot", "message_type": "voice", "content": "[Voice message] باش تبيعها ب ستة آلاف درهم.", "created_at": "2026-04-10T19:50:12.376528", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3568/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13813, "message_id": "A53D173594D1DD47B2BD0964340E2C7B", "sender": "user", "message_type": "text", "content": "واخا يكون درجة خفيفة 3000 درهم . حيت سناني عاديين ماشي صوفار", "created_at": "2026-04-10T19:50:55.276249", "media_url": null, "media_mime_type": null}, {"id": 13814, "message_id": "A5D876007E822C1305DF191460591132", "sender": "user", "message_type": "text", "content": "كيقى نفس الثمن ؟", "created_at": "2026-04-10T19:51:11.773935", "media_url": null, "media_mime_type": null}, {"id": 13815, "message_id": "A589CC16C0D08CA7C957B49C30EE4D51", "sender": "user", "message_type": "text", "content": "شحال تدويزة؟", "created_at": "2026-04-10T19:51:29.494414", "media_url": null, "media_mime_type": null}, {"id": 13817, "message_id": "A5679C4033F637B1AA5842DA14F30CCE", "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\"Machi mouchkil, nkhalliweh lik alfayn u khms-miya dirham, binisba l'tjwiza miytayn dirham.\"\n\n**Translation (for context):**\n\"No problem, we'll leave it for you for 2500 dirhams; as for the [passing fee/clearance], it's 200 dirhams.\"", "created_at": "2026-04-10T20:00:11.969182", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3570/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13818, "message_id": "A5BBC129FBC9ECB52E8944423253B587", "sender": "user", "message_type": "text", "content": "شحال كيبقى ؟", "created_at": "2026-04-10T20:00:12.240357", "media_url": null, "media_mime_type": null}, {"id": 15142, "message_id": "A51E43E7891F75508D28F65F0EEF0599", "sender": "user", "message_type": "text", "content": "سلام انا بغيت نجي غدا نعمر السنة", "created_at": "2026-04-13T19:08:47.182110", "media_url": null, "media_mime_type": null}, {"id": 15143, "message_id": "A59F8F88BE242030B4D638658E088FA0", "sender": "user", "message_type": "text", "content": "واش برونديفو؟", "created_at": "2026-04-13T19:08:52.938375", "media_url": null, "media_mime_type": null}, {"id": 15144, "message_id": "bot_A59F8F88BE242030B4D638658E088FA0_8444", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 واخا تعطيني الإسم الكامل ديالك؟", "created_at": "2026-04-13T19:09:26.483806", "media_url": null, "media_mime_type": null}, {"id": 15145, "message_id": "A5C7CC747283B14B37C9A12452B32916", "sender": "user", "message_type": "text", "content": "سناء الخقوني", "created_at": "2026-04-13T19:09:40.107265", "media_url": null, "media_mime_type": null}, {"id": 15146, "message_id": "bot_A5C7CC747283B14B37C9A12452B32916_5188", "sender": "bot", "message_type": "text", "content": "شكرا سناء الخقوني 😊 واش ممكن تقولي ليا واش كتفضلي شي وقت معين غدا؟ وصافي غادي نبلغ الفريق إن شاء الله. شنو الوقت اللي مناسبك؟", "created_at": "2026-04-13T19:09:53.459029", "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 1091 in training_review_items