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": 44549, "message_id": "3EB0E5F114BC3661D1DD4C", "sender": "bot", "message_type": "document", "content": "2026061616431361.pdf", "created_at": "2026-06-16T15:44:33.271465", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12259/download", "media_mime_type": "application/pdf"}, {"id": 44550, "message_id": "3EB0D2BB39D8FB6950F1C9", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MARIAM  Rambouk*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *vendredi 19 juin 2026* à *15:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الجمعة 19 يونيو 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-16T15:44:54.312043", "media_url": null, "media_mime_type": null}, {"id": 44653, "message_id": "3EB05E7099229DEFCF114E", "sender": "bot", "message_type": "text", "content": "Bonjour MARIAM  Rambouk", "created_at": "2026-06-16T18:22:18.682195", "media_url": null, "media_mime_type": null}, {"id": 44654, "message_id": "A59000D936E2973E44EE0D2AD28161FA", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a printed document, likely a dental product recommendation or prescription sheet. The sheet is held by a person's left hand, and part of a desk and dark clothing are visible in the background. The document is divided into sections, each featuring dental products and their descriptions. Products from brands such as PERIO-AID, VITIS, and HALITA are visible, with images of mouthwashes, toothpastes, gels, and brushes. Checkboxes are next to each product description for selection. There is a logo at the bottom labeled 'IBERMA' with a caduceus-like symbol and a space at the bottom for 'Patient' and 'Cachet du médecin' (Doctor's stamp), and a partially visible 'DENTAID' label at the lower right. Product descriptions are in French and list attributes like fighting biofilm, complete gum care, care for orthodontic appliances, teeth whitening, cavity protection, sensitivity relief, and halitosis management. Some items are marked with 'NOUVEAU' indicating new products.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_can", "created_at": "2026-06-16T18:22:41.499596", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12298/download", "media_mime_type": "image/jpeg"}, {"id": 44655, "message_id": "A5BE4D586C73A4E2B5A0BF3E1A04C436", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nويه كمارة مسكين د مزيان بخير، شوفي أ مريم، هاد لعلامة إكس ديال ديور، هاداك شريه صافي.\n\n**Latin Script:**\nWayeh, kmarte meskin d mzyan bikhir. Chof a Meriem, had l'alama X dial Dior, hadak chrih safi.\n\n**English Translation (for context):**\n\"Yes, his face (look), poor guy, is good/fine. Look Meriem, that 'X' mark of Dior, buy that one, that's it.\"", "created_at": "2026-06-16T18:23:06.960943", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12299/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44681, "message_id": "3A16CD40D3080CE8976F", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام اسمحي لي عاد سمعت الميساج ديالك. هو هاداك اللي شرا ليا راجلي مللي قبيلاتي كنت فـ cabinet، راجلي مشا لـ pharmacie وهاداك اللي شرا ليا. شرا ليا معاه la brosse à dents و le dentifrice، جا le complet فواحد البواطة، جا فيه le complet. شكراً بزاف بسلامة.", "created_at": "2026-06-16T19:32:18.072567", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12309/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44683, "message_id": "A508C21E9952A4C2FE0F146B4A1FBA87", "sender": "bot", "message_type": "voice", "content": "[Voice message] هذا هو تفريغ المقطع الصوتي (بالدارجة المغربية):\n\n**بالعربية:**\n\"صافي، هو هذاك، وآخر فيديو ديالي. صافي، إلى احتاجيتي شي حاجة عيطي ليا.\"\n\n**باللاتينية (Transcription):**\n\"Safi, houwa hadak, w akher vidéo dyali. Safi, ila htajiti chi haja 3ayti lya.\"", "created_at": "2026-06-16T19:35:12.184968", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12311/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44690, "message_id": "3A06EA2A009BE3A51519", "sender": "user", "message_type": "text", "content": "Merci 🙏🏼", "created_at": "2026-06-16T20:13:18.836829", "media_url": null, "media_mime_type": null}, {"id": 45138, "message_id": "3A74C402D75BEB5EBF24", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم حبيبة، كيف دايرة لاباس عليك كلشي مزيان الصحة لاباس؟ سمح لي بغيت نسولك عندي راندي ڤو غدا فالتلاتة، ولكن عندنا واحد السيد من العائلة توفى، وعندنا غدا الڭنازة فهمتي غدا غايدفنوه، وبغينا نمشيو معاهم نصليو على داك السيد، وإلى قدرتي خاي الله تعملي ليا الراندي ڤو قبل طناش، إلى قدرتي، جاوبي عليا خاي الله، شكراً بزاف سمح لي.", "created_at": "2026-06-18T11:21:10.289461", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12464/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 45139, "message_id": "3AE2375ED2730E0DCFA0", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Latin Script:**\nAslan darna ghi contrôle, ghay chouf li wash koulchi mzyan o safi, fhamti?\n\n**Arabic Script:**\nأصلا درنا غير كونطرول، غايشوف ليا واش كولشي مزيان وصافي، فهمتي؟\n\n**Translation (for context):**\nBasically, we just did a check-up, he’s going to check if everything is fine and that’s it, you understand?", "created_at": "2026-06-18T11:21:19.571204", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12465/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 45144, "message_id": "bot_3AE2375ED2730E0DCFA0_7035", "sender": "bot", "message_type": "text", "content": "فهمتك Mariam، وغادي نبلغ الفريق الطبي ديالنا بطلبك باش يحاولو يقدمو ليك الرانديڤو قبل 12h بسبب ظروف الجنازة.", "created_at": "2026-06-18T11:22:24.502078", "media_url": null, "media_mime_type": null}, {"id": 45145, "message_id": "bot_3AE2375ED2730E0DCFA0_4877", "sender": "bot", "message_type": "text", "content": "غادي يتواصلوا معكوم في أقرب وقت إن شاء الله 🙏🏻\n\nدير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-06-18T11:22:24.560578", "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 3732 in training_review_items