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": 13808, "message_id": "A5B2228A22A3C45C8165AFF0F4222B33", "sender": "bot", "message_type": "text", "content": "Bonjour et bienvenue au Cabinet dentaire Tanger Bay \nمرحبا بكم فـ عيادة طنجة باي لطب الأسنان.\n\n Merci de nous indiquer en quoi nous pouvons vous aider afin que notre équipe puisse vous orienter au mieux.\nمن فضلكم، أخبرونا كيف يمكننا مساعدتكم لكي يتمكن فريقنا من توجيهكم بشكل مناسب\n\n📍 Localisation : https://maps.app.goo.gl/ZCXz3sMZkhk9diph7\n🌐 Site web : www.tangerbay.ma\n📧 Email :\ntangerbay01@gmail.com\n\n✅ Notre équipe vous répondra dans les plus brefs délais.\nسيقوم فريقنا بالرد عليكم في أقرب وقت ممكن", "created_at": "2026-04-10T19:49:45.739617", "media_url": null, "media_mime_type": null}, {"id": 13809, "message_id": "bot_A5C36BF1E8C2EE3D53DA3F733DB714B9_5435", "sender": "bot", "message_type": "text", "content": "مرحبا الله اودي وشكرا على التواصل ديالكوم مع Centre Dentaire Tanger Bay. واش ممكن تقولولي شنو الحاجة اللي محتاجينها اليوم؟", "created_at": "2026-04-10T19:49:58.605015", "media_url": null, "media_mime_type": null}, {"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}]

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 1090 in training_review_items