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": 29753, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjYxNDA3MTc4FQIAERgWM0VCMDdDOEVCNjc1NDFCRTk2QUU1NAA=", "sender": "bot", "message_type": "text", "content": "Bonjour,\r\nNous espérons que vous allez bien. Nous voulions simplement nous assurer que tout se passe bien suite à votre extraction et que vous ne ressentez pas de gêne particulière.\r\nSi vous avez la moindre question ou inquiétude, n’hésitez pas à nous contacter.\r\nBon rétablissement.", "created_at": "2026-05-15T09:12:35.675704", "media_url": null, "media_mime_type": null}, {"id": 29830, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjYxNDA3MTc4FQIAEhggQUNGODU3REUwN0FBRERFOUMwQ0M2RkRFNTBBNzNGMzgA", "sender": "user", "message_type": "text", "content": "Bonjour. Je crois que vous faites erreur de destinataire, je nai pas fait d'extraction...mais un détartrage .", "created_at": "2026-05-15T10:44:52.290177", "media_url": null, "media_mime_type": null}, {"id": 30012, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjYxNDA3MTc4FQIAERggQTUzODQyOTEzODE4QzhDMUVFRjgxMTY0REMzRjhCRDAA", "sender": "bot", "message_type": "text", "content": "Désolé", "created_at": "2026-05-15T13:35:01.795642", "media_url": null, "media_mime_type": null}, {"id": 31339, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjYxNDA3MTc4FQIAERgWM0VCMDQwNUEzRDQ1MzA0RkY2RDNCMgA=", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*GMIRA Soundous*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 18 mai 2026* à *14: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لديكم موعد مع ** يوم *الأثنين 18 ماي 2026* على الساعة *14:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-18T09:08:25.006866", "media_url": null, "media_mime_type": null}, {"id": 31613, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjYxNDA3MTc4FQIAERgWM0VCMEZCMDQ5RjI2MUMzNjhDMzM1NAA=", "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 (*Chèque*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-05-18T14:50:11.835832", "media_url": null, "media_mime_type": null}, {"id": 31614, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjYxNDA3MTc4FQIAERgWM0VCMERDM0FERUYyQjQ1RDc2OEM2MgA=", "sender": "bot", "message_type": "document", "content": "", "created_at": "2026-05-18T14:50:40.133608", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9110/download", "media_mime_type": "application/pdf"}, {"id": 32394, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjYxNDA3MTc4FQIAEhggQUMzNEE4QTdGNjVDNUU0NjYyOUQxNzM1OEQ2REUzOUEA", "sender": "user", "message_type": "voice", "content": "[Voice message] Bonjour ça va ? الله يخليك إلى يمكن لكم تصاوبوا... تصاوبوا لي une ordonnance مع هاداك le dossier CNSS لي خديت البارح ديال 21 مارس. كان خرج لي الدكتور رياض une ordonnance فيها Augmentin 1g وفيها Brufen وفيها Codoliprane وفيها واحد le bain de bouche. Mais bon, le bain de bouche n'est pas remboursable، دونك غير هادو إلى يمكن لك تصاوبي لي une ordonnance ندوز ناخدها tout à l'heure، ناخدها يعني مع ديك الخمسة ونص ولا شي حاجة si possible. في la même date باش ندفعها مع داك le dossier ديال 21 مارس لي عطيتيني البارح حيت اليوم آخر أجل باش يمكن لي نقدر ننزلو.", "created_at": "2026-05-19T14:18:40.612036", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9321/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 32395, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjYxNDA3MTc4FQIAEhggQUMzQjJEMEFCRkMxNTM5MTlCRDJCODREQjU2RDRDOUUA", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"object\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows three pharmaceutical product boxes placed on a blue fabric surface. The boxes are as follows: 1) BRUFEN (400 mg ibuprofen), a rectangular box with text in both Latin and Arabic scripts, indicating 30 film-coated tablets. The box has red, pink, and white coloring. 2) Codoliprane (Paracetamol 400 mg / Codeine 20 mg), a rectangular box with predominantly white background with red and blue accents, marked for adults, containing 16 breakable tablets. 3) AUGMENTIN (1g/125mg), a blue and white box with orange elements. It states it contains 16 sachets of powder for oral suspension (amoxicillin & clavulanic acid), with text in French and Arabic. The AUGMENTIN box is open, with the top flap visible; no tablets or sachets are visible outside the boxes. The boxes are set against a plain blue background, with a white cable partially visible at the top of the image.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"", "created_at": "2026-05-19T14:18:47.945827", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9322/download", "media_mime_type": "image/jpeg"}, {"id": 32396, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjYxNDA3MTc4FQIAEhggQUMzMzc5RjM1RUM1MUNDN0JDNzVDQ0VBNEI2RkJEQjcA", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This image shows a close-up of a printed document or letter. The paper is white with black and blue printed text. At the top section, there is a letterhead containing text in Arabic and French: 'CENTRE DENTAIRE' in blue, and in black: 'Dr. Haitham Boutaib' with the same name in Arabic above. Lower on the page, aligned left, there is a printed date: 'Tanger, le 21/03/2026'. The lower left part of the paper has the partial outline of a possible watermark or logo, with part of the word 'AIRE' visible. The paper seems to be slightly curved at the right margin, and there is a blue or teal surface (possibly a chair or desk) in the right background.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"\",\n    \"alignment\": \"\",\n    \"calculus_plaque\": \"\",\n    \"periapical_areas\": \"\",\n    \"other_findings\": \"\"\n  },\n  \"", "created_at": "2026-05-19T14:19:35.385951", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9323/download", "media_mime_type": "image/jpeg"}, {"id": 39387, "message_id": "AC6C01B009A92DECB576D087346A25BF", "sender": "user", "message_type": "voice", "content": "[Voice message] سلام لاباس، هاني لاباس، عافاك تا تعطيني شي رونديفو، ديك التعميرة لي عمل لي الطبيب داك نهار طاحت لي. كنت مسافرة دابا عليها ما عيطت ليكم قبل، كان العيد كنت مسافرة، دابا جيت عاد عيطت ليكم. أونفان جيت، يعني غانجي إن شاء الله فهاد نهار لحد ولا لثنين غاندخل، عليها عيطت لك باش تعطيني الرونديفو.", "created_at": "2026-06-05T14:19:40.814806", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10954/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39388, "message_id": "A508946EEBCDE1F1983E2F2ABCE48C7F", "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-06-05T14:19:41.221364", "media_url": null, "media_mime_type": null}, {"id": 39389, "message_id": "bot_AC6C01B009A92DECB576D087346A25BF_2339", "sender": "bot", "message_type": "text", "content": "مرحبا الله اودي 😊", "created_at": "2026-06-05T14:20:23.045223", "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 3191 in training_review_items