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": 6534, "message_id": "bot_ACD305C79E3A2EAE7B1200003DFA3819_8800", "sender": "bot", "message_type": "text", "content": "كنعتدر، مفهمتش الرسالة الصوتية بالضبط. واش تقدر توضح ليا شنو قصدك؟", "created_at": "2026-03-19T15:15:48.650023", "media_url": null, "media_mime_type": null}, {"id": 6541, "message_id": "AC4552B34449CFC9206F0021E122B745", "sender": "user", "message_type": "document", "content": "pdf.pdf", "created_at": "2026-03-19T16:10:11.916450", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/1301/download", "media_mime_type": "application/pdf"}, {"id": 6632, "message_id": "ACB4B91EFA4C6E9DCFF243286655E109", "sender": "bot", "message_type": "text", "content": "ننهي الى علم مرضانا الكرام ان يوم عيد الفطر بالمغرب غدا الجمعة 20 مارس و بالتالى فإن موعدكم غدا سيلغى،  و سيتواصل معكم فريقنا فور العودة يوم الاثنين 30 مارس لترتيب مواعيدكم وضمان استقبالكم في أفضل الظروف.\nشكراً لثقتكم وتفهمكم.", "created_at": "2026-03-19T19:27:41.786479", "media_url": null, "media_mime_type": null}, {"id": 11530, "message_id": "AC369FF55421EFB1520321AD4AB1EC7C", "sender": "user", "message_type": "document", "content": "BL DR DINANI SANS FACTURE .pdf", "created_at": "2026-04-03T15:29:45.138972", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/2846/download", "media_mime_type": "application/pdf"}, {"id": 11883, "message_id": "3EB02614EADBE0585652C7", "sender": "bot", "message_type": "text", "content": "نقدر رضاك ونود أن نطلب منك تقييم تجربتك معنا باتباع هذا الرابط https://bit.ly/3yYyxc3. يتطلب التقييم خطوتين بسيطتين، يرجى التأكد من إكمال كل منهما حتى يتم قبول نتيجة التقييم بشكل جيد. شكرًا !\n\nVotre santé est notre priorité, et nous sommes heureux de vous servir au sein du Centre dentaire du Dr Dinani Hicham. Nous accordons une grande importance à votre satisfaction et aimerions vous demander d'évaluer votre expérience avec nous en suivant ce lien https://bit.ly/3yYyxc3. L'évaluation nécessite deux étapes simples, veuillez-vous assurer de compléter chacune d'elles afin que le résultat de votre évaluation soit bien", "created_at": "2026-04-04T11:37:49.008980", "media_url": null, "media_mime_type": null}, {"id": 12534, "message_id": "AC6FD917070232190B9835106BAF85D9", "sender": "user", "message_type": "image", "content": "Image description: (a) The image appears to be a document.\n\n(b) Not applicable.\n\n(c) Visible text (OCR):\n\n```\nMorocco Dental Lab\nCreative Digital Dentistry\nFACTURE No : 06\nDATE : 02/02/2026\nDINANI HICHAM\nICE : 001646846000055\n\nPATIENT            TRAVAUX              PRIX    QANTITE   TOTAL\nBouazzaoui Rachida  Couronne Zircone      600        1      600\nLkhadir Nabil      Couronne Zircone      600        1      600\nRharrabi Sanae     Couronne Zircone      600        1      600\nTOTAL TTC                                                 1 800 DH\n\nLa présente facture est arrêtée a la somme de :\nMILLE HUIT CENT DIRHAMS.\n\nAdresse. 23 Rue Carnot 6eme étage appt 1. Tanger. Maroc .90000\nIF.45974123 . ICE.002596121000037. IP.50413971 . RC.108187\n\nMoroccodentallab@gmail.com\n+212 666 308 076 / +212 808 506 495\n\nwww.moroccodentallab.com\nRabat, Tanger, Casablanca\n```\n\n(d) Flag: NONE\n\nUser message context: Bonsoir Docteur,\nVoici la facture", "created_at": "2026-04-07T16:19:58.083000", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/3179/download", "media_mime_type": "image/jpeg"}, {"id": 12593, "message_id": "ACFA40E65FF46E1B6B908C2676B3066A", "sender": "user", "message_type": "document", "content": "FACTURE DR HICHAM DINANI.pdf", "created_at": "2026-04-08T08:41:22.706638", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/3202/download", "media_mime_type": "application/pdf"}, {"id": 12606, "message_id": "ACFBC5948597082E3295466F1C05CA5F", "sender": "bot", "message_type": "text", "content": "0726429425", "created_at": "2026-04-08T09:26:22.537169", "media_url": null, "media_mime_type": null}, {"id": 13486, "message_id": "3EB0F41AFC28F47A36D0F5", "sender": "bot", "message_type": "document", "content": "LE MOIS 5 RED 2025 NV.xlsx", "created_at": "2026-04-10T09:53:36.239479", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/3462/download", "media_mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"}, {"id": 13488, "message_id": "3EB0E5ABF3C7DC0BDE0E3A", "sender": "bot", "message_type": "document", "content": "LE MOIS 5 RED 2024.pdf", "created_at": "2026-04-10T09:53:55.266755", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/3464/download", "media_mime_type": "application/pdf"}, {"id": 16644, "message_id": "AC42A06DBE856877B65EF4283C3F3B70", "sender": "user", "message_type": "text", "content": "Lettre d'accompagnement (Réponse à un complément d'information)\nNom et Prénom : M. OULFRACH M'HAMED\nN° Adhérent : 94181330\nN° Dossier : 93026725\nÀ l’attention du Service des Prestations Maladie\nMutuelle Générale de l’Éducation Nationale\nObjet : Précisions concernant les dents remplacées (Dossier Stellite)\nMadame, Monsieur,\nSuite à votre demande de complément d'information concernant mon dossier n° 93026725, je vous communique ci-dessous les précisions demandées par vos services concernant les dents remplacées par l'appareil métallique (Stellite) :\nPour le Stellite Haut (Arcade supérieure) : [هنا يكتب أرقام الأسنان اللي تعوضات]\nPour le Stellite Bas (Arcade inférieure) : [هنا يكتب أرقام الأسنان اللي تعوضات]\nVeuillez trouver ci-joint les pièces justificatives complétées par mon chirurgien-dentiste pour permettre la régularisation de mon remboursement.\nJe vous remercie par avance de l'intérêt que vous porterez à ma demande.\nCordialement,", "created_at": "2026-04-16T10:42:58.770212", "media_url": null, "media_mime_type": null}, {"id": 16645, "message_id": "bot_AC42A06DBE856877B65EF4283C3F3B70_3407", "sender": "bot", "message_type": "text", "content": "Pouvez-vous me donner votre nom complet ?", "created_at": "2026-04-16T10:43:11.452396", "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 1251 in training_review_items