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": 8496, "message_id": "ACEE46FB8F8BCE6D1F41A84A65505025", "sender": "user", "message_type": "text", "content": "Chukran", "created_at": "2026-03-29T18:29:08.045737", "media_url": null, "media_mime_type": null}, {"id": 8497, "message_id": "bot_ACEE46FB8F8BCE6D1F41A84A65505025_1298", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم دائما 🙏🏻", "created_at": "2026-03-29T18:29:19.295108", "media_url": null, "media_mime_type": null}, {"id": 8498, "message_id": "ACFDDD23CA2D4752F611E5CD561D6565", "sender": "user", "message_type": "text", "content": "👍", "created_at": "2026-03-29T18:29:32.672175", "media_url": null, "media_mime_type": null}, {"id": 8499, "message_id": "bot_ACFDDD23CA2D4752F611E5CD561D6565_5339", "sender": "bot", "message_type": "text", "content": "مرحبا بيكوم 😊", "created_at": "2026-03-29T18:29:45.498736", "media_url": null, "media_mime_type": null}, {"id": 8505, "message_id": "ACC079450F476AD0A5D446B7F321C02F", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic Script:**\n\"السلام عليكم، اسمح لي، طوطال د... طوطال بلانط (plantes) ستة، أربعة من فوق وجوج من تحت.\"\n\n**Latin Script (Darija):**\n\"Salam alaykoum, smah li, total d... total plantes setta, reb’a men l-fouq w jouj men l-teht.\"\n\n**Translation (for context):**\n\"Peace be upon you, excuse me, total of... total implants is six, four on the top and two on the bottom.\"", "created_at": "2026-03-29T21:31:52.488988", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1851/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8506, "message_id": "bot_ACC079450F476AD0A5D446B7F321C02F_7126", "sender": "bot", "message_type": "text", "content": "شكرا على التوضيح 😊 إذن بغيتو تديرو 6 implants: 4 من الفوق و2 من التحت. إذا كاين شي تغيير أو سؤال آخر، قوليه ليا.\n\nواخا تأكد ليا الإسم ديالك مكتوب صحيح: Mohamed moniem el murabet؟ إذا فيه شي تعديل، كتبوه ليا هنا باش الفريق يتواصل معكوم بالمعلومات الصحيحة.", "created_at": "2026-03-29T21:32:13.946427", "media_url": null, "media_mime_type": null}, {"id": 8507, "message_id": "ACA7229071FE92E4183D9CCA03C5E1A5", "sender": "user", "message_type": "text", "content": "Total emplantes 6", "created_at": "2026-03-29T21:32:16.036746", "media_url": null, "media_mime_type": null}, {"id": 8508, "message_id": "bot_ACA7229071FE92E4183D9CCA03C5E1A5_7562", "sender": "bot", "message_type": "text", "content": "شكرا على التوضيح، يعني محتاجين 6 implants. غادي نبلغ الفريق الطبي ديالنا وغادي يتواصلوا معكوم في أقرب وقت باش يشرحوا ليكوم كلشي التفاصيل ويجاوبوكوم على جميع الأسئلة ديالكوم. إذا كان عندكوم أي سؤال آخر، أنا هنا!", "created_at": "2026-03-29T21:32:31.011025", "media_url": null, "media_mime_type": null}, {"id": 8509, "message_id": "ACBF584B2AEA52AE840F47C11746C2C1", "sender": "user", "message_type": "text", "content": "Chukran", "created_at": "2026-03-29T21:32:59.035844", "media_url": null, "media_mime_type": null}, {"id": 8510, "message_id": "bot_ACBF584B2AEA52AE840F47C11746C2C1_4709", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم دائما 😊", "created_at": "2026-03-29T21:33:11.716903", "media_url": null, "media_mime_type": null}, {"id": 8511, "message_id": "ACA803688F2F5E944B0322DC17D8BB83", "sender": "user", "message_type": "text", "content": "Buenas noches", "created_at": "2026-03-29T21:33:44.282423", "media_url": null, "media_mime_type": null}, {"id": 8512, "message_id": "bot_ACA803688F2F5E944B0322DC17D8BB83_4565", "sender": "bot", "message_type": "text", "content": "Buenas noches 😊 ¿En qué puedo ayudarte?", "created_at": "2026-03-29T21:33:56.092876", "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 404 in training_review_items