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": 37625, "message_id": "3A44768A3027E6A77DB0", "sender": "user", "message_type": "text", "content": "Fo9ach hatft7o !?", "created_at": "2026-06-01T14:52:07.140442", "media_url": null, "media_mime_type": null}, {"id": 37626, "message_id": "bot_3A44768A3027E6A77DB0_7299", "sender": "bot", "message_type": "text", "content": "كنخدمو من الاثنين حتى الجمعة من 09:00 حتى 19:00، والسبت من 09:00 حتى 14:00 😊 الأحد مغلقين.", "created_at": "2026-06-01T14:52:20.506443", "media_url": null, "media_mime_type": null}, {"id": 37627, "message_id": "A5E8FE99D54912E81124DA5DFC32D4B4", "sender": "bot", "message_type": "voice", "content": "[Voice message] السلام عليكم، لاباس بخير؟ حنايا فتحي، مرحبا بكم.", "created_at": "2026-06-01T14:52:21.252444", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10522/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37628, "message_id": "A5C4D4400C4EFF26D9090003D4D654E1", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in both Latin script (for clarity on the phonetics) and Arabic script:\n\n**Latin Script:**\n\"Bash nkhdmou b rendez-vous, goulli fo9ach tkon disponible bash nakhod dak rendez-vous.\"\n\n**Arabic Script:**\n\"باش نخدموا بـ rendez-vous، قولي فوقاش تكون disponible باش ناخد داك rendez-vous.\"\n\n**Translation (for context):**\n\"To work by appointment, tell me when you will be available so I can take that appointment.\"", "created_at": "2026-06-01T14:52:28.411997", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10523/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37630, "message_id": "3A3910C244E9F4C6385F", "sender": "user", "message_type": "voice", "content": "[Voice message] ألوغ، أنا ديجا كنت جيت، وقيلة هادي شي دو موا ولا ما عرفت شحال، و المهم كنت عملت الراديو، عملت كلشي، و عملت ديطارتراج. و كنت باغة نعمر واحد الضروص، و صافي و بقات فحال هيداك، دبا إن شاء الله خصني نعمل رانديفو باش نعمر الضروص لي عندي.", "created_at": "2026-06-01T14:53:17.353084", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10524/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37636, "message_id": "A5D663A59824EAF87B5ADA0611351546", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (mixed with French):\n\n**Arabic Script:**\n\"مرحبا بك أ فردوس، مرحبا، على الرأس والعين. وخا، عندي rendez-vous خاوي نهار الجمعة. نعطيك rendez-vous نهار الجمعة إن شاء الله مع التلاتة باش نبداو؟\"\n\n**Latin Script (Transcription):**\n\"Marhaba bik a Firdous, marhaba, ala rass o l'ayn. Wakha, andi rendez-vous khawi nhar el-joumouâa. Naatik rendez-vous nhar el-joumouâa incha'Allah m'aa tleta bach nebdaou?\"\n\n**English Translation (for context):**\n\"Welcome Firdous, you are most welcome. Okay, I have an available appointment on Friday. Shall I give you an appointment on Friday, God willing, at 3 o'clock so we can start?\"", "created_at": "2026-06-01T15:00:09.138839", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10527/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37643, "message_id": "3AC75C0032CD8614786A", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija:\n\n\"صافي واخا، نهار الجمعة، وبحق واش مكاينش ف الصباح؟ إلا مكانش ف الصباح صافي التلاتة مناسباني ماشي مشكل، ياك مع الدكتور هيثم؟\"\n\n**Transliteration (Latin Script):**\n\"Safi wakha, nhar ljoumou'a, o b-haq wash makayench f s-bah? Ila makanesh f s-bah safi t-tlata mnasbani mashi moshkil, yak ma'a doktour Haytam?\"", "created_at": "2026-06-01T15:03:28.444017", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10534/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 38961, "message_id": "3A85C1B3007E5CAB769F", "sender": "user", "message_type": "text", "content": "?", "created_at": "2026-06-04T16:14:06.175626", "media_url": null, "media_mime_type": null}, {"id": 38962, "message_id": "bot_3A85C1B3007E5CAB769F_4485", "sender": "bot", "message_type": "text", "content": "مرحبا فردوس 😊 بالنسبة للجمعة، الموعد المتوفر حاليا هو مع التلاتة بعد الزوال.", "created_at": "2026-06-04T16:14:46.333827", "media_url": null, "media_mime_type": null}, {"id": 38963, "message_id": "bot_3A85C1B3007E5CAB769F_2908", "sender": "bot", "message_type": "text", "content": "إذا توفر شي وقت فالصباح غادي يخبركوم به الفريق مباشرة.", "created_at": "2026-06-04T16:14:46.388618", "media_url": null, "media_mime_type": null}, {"id": 38964, "message_id": "bot_3A85C1B3007E5CAB769F_9101", "sender": "bot", "message_type": "text", "content": "والموعد غادي يكون مع الدكتور هيثم إن شاء الله.", "created_at": "2026-06-04T16:14:46.444142", "media_url": null, "media_mime_type": null}, {"id": 38965, "message_id": "bot_3A85C1B3007E5CAB769F_5906", "sender": "bot", "message_type": "text", "content": "دير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-06-04T16:14:46.504041", "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 3142 in training_review_items