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": 42242, "message_id": "A5820234C7D6B581B2E06971D83D301A", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-11T18:07:52.482698", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11717/download", "media_mime_type": "video/mp4"}, {"id": 42243, "message_id": "3EB02856C2F8D96F41BB4C", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *2000,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+2000,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-11T18:08:46.243386", "media_url": null, "media_mime_type": null}, {"id": 42244, "message_id": "3EB066DC12CA39A809B220", "sender": "bot", "message_type": "document", "content": "2026061119080003.pdf", "created_at": "2026-06-11T18:08:57.584387", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11718/download", "media_mime_type": "application/pdf"}, {"id": 47286, "message_id": "A569C815A67ACC5063F8D501E52F1321", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic and Latin scripts:\n\n**Arabic Script:**\nألو، السلام عليكم ختي لاباس بخير؟ عيطتي لي لبارح، كنت أوكيبي (occupée)، سمحي لي.\n\n**Latin Script:**\nAllo, Salamo Alaykom khti labas bikhir? Ayatli lbareh, kount occupée, smaheli.", "created_at": "2026-06-23T10:10:39.633793", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13079/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47287, "message_id": "bot_A569C815A67ACC5063F8D501E52F1321_6752", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، مرحبا الله أودي، ماكاين حتى مشكل 😊 واش نقدر نعاونكوم بشي حاجة اليوم؟", "created_at": "2026-06-23T10:10:57.756016", "media_url": null, "media_mime_type": null}, {"id": 47291, "message_id": "A532F6E8F6A091CA6F6AA4C6C1BD8345", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using Arabic script):\n\n**السلام عليكم، كي دايرة مزيان بخير صحة لاباس؟ آه عيطت لك البارح على حساب باش تكمل مع دكتور رياض، قولي فوقاش تكون ديسبونيبل باش ناخد لك رونديفو معاه.**\n\n***\n\n**Latin Script Transcription:**\n\n*Salam alaykoum, kidayra mezian bikhir seha labas? Ah ayet lik lbareh ela hsab bash tkemel mea docteur Riyadh, goli foqash tkon disponible bash nakhod lek rendez-vous meah.*", "created_at": "2026-06-23T10:16:19.108796", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13080/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47292, "message_id": "A56611D5D816185BA084E1D592E9BF04", "sender": "user", "message_type": "text", "content": "La rdv baqi, ana n3ytkoum", "created_at": "2026-06-23T10:16:50.694988", "media_url": null, "media_mime_type": null}, {"id": 47293, "message_id": "A5063B625881DB707C97592582D95EDD", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio, which contains a mix of Moroccan Darija and French:\n\n\"Oui, wa alaykoum assalam khti labas? Chouf baqi naqass le papier dial l'assurance, wa ela hsab rendez-vous ana n-3ayet likoum waqtach khassni rendez-vous. Wa voilà, ghir 3afak le papier dial l'assurance ma3reft wach wajed, ana nsit nji njibo.\"\n\n**Translation for context (if needed):**\n*\"Yes, peace be upon you sister, how are you? Look, the insurance paper is still missing, and regarding the appointment, I will call you when I need the appointment. And voilà, please about the insurance paper, I don't know if it's ready, I forgot to come and get it.\"*", "created_at": "2026-06-23T10:18:21.199209", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13081/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47313, "message_id": "A5E24C6CA20CA918E209FEF84C03D447", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic script (as commonly used for Darija) and Latin script:\n\n### **Arabic Script:**\nصافي واخا، مهم ديك ساعة جيب لي... جيب لي AXA، عندك AXA ياك؟ ولا CNSS؟ لا كانت عندك CNSS، عندي AXA، جيبها لي تينا.\n\n### **Latin Script (Darija/French):**\nSafi wakha, mohim dik sa3a jib li... jib li l'AXA, 3andek AXA yak? Walla CNSS? La kant 3andek CNSS, 3andi AXA, jibha li tina.\n\n---\n**Note:** The speaker is using Moroccan Darija (specifically the Northern dialect, indicated by the word \"tina\" for \"you\") mixed with French acronyms for insurance and social security (AXA and CNSS).", "created_at": "2026-06-23T10:28:19.719823", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13089/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47993, "message_id": "A5448E728FDD398D46AE578430B421CF", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija and French:\n\n**Arabic Script:**\nالسلام عليكم، لا أنا عندي غير الـ CNSS، واسمح ليا تعطّلت فـ la réponse، المهم غدا نكون disponible فالعشية باش ندوز نهز ديك الـ papier.\n\n**Latin Script (Transliteration):**\nSalam o'alaykom, la ana 'andi ghir CNSS, w sma7 liya t'atalt f la réponse, mohim ghadda nkun disponible f l'achiya bash ngouz nhouz dik l-papier.\n\n**English Translation (for context):**\n\"Peace be upon you. No, I only have CNSS (social security). Forgive me for being late to reply. Anyway, tomorrow I will be available in the afternoon to come by and pick up that document.\"", "created_at": "2026-06-24T16:27:30.345242", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13333/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47997, "message_id": "A5E545A31E1CFA343147D829BB83CB62", "sender": "user", "message_type": "voice", "content": "[Voice message] صافي غير سير، نسيناه.", "created_at": "2026-06-24T16:28:12.171396", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13334/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47998, "message_id": "bot_A5E545A31E1CFA343147D829BB83CB62_4976", "sender": "bot", "message_type": "text", "content": "شكرا بزاف على التوضيح! إذا احتجتي شي حاجة أخرى ولا تبدل شي جديد، مرحبا في أي وقت 😊", "created_at": "2026-06-24T16:28:32.074947", "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 3977 in training_review_items