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": 8314, "message_id": "AC81E09117CAB65472B4A5BCEEEF5E8C", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-03-29T13:16:28.063517", "media_url": null, "media_mime_type": null}, {"id": 8315, "message_id": "A5197024914B395A9430AC7C791B7BD1", "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-03-29T13:16:29.142846", "media_url": null, "media_mime_type": null}, {"id": 8316, "message_id": "AC2EE3F8E4BAC545F82DDE7AE6F67EAF", "sender": "user", "message_type": "text", "content": "C Anouar hamzaoui", "created_at": "2026-03-29T13:16:33.540922", "media_url": null, "media_mime_type": null}, {"id": 8317, "message_id": "bot_AC2EE3F8E4BAC545F82DDE7AE6F67EAF_5024", "sender": "bot", "message_type": "text", "content": "Bonjour Anouar hamzaoui et bienvenue chez Centre Dentaire Tanger Bay ! 😊\n\nDites-moi, comment puis-je vous aider aujourd'hui ? Vous cherchez des informations sur un service précis ou vous souhaitez prendre rendez-vous ?", "created_at": "2026-03-29T13:16:58.691416", "media_url": null, "media_mime_type": null}, {"id": 8318, "message_id": "AC8A4ECD9E255F37CC56126BF1443109", "sender": "user", "message_type": "text", "content": "Merci de donner le numéro de docteur achraf", "created_at": "2026-03-29T13:17:35.865545", "media_url": null, "media_mime_type": null}, {"id": 8622, "message_id": "3EB075631D1178C82ABF04", "sender": "bot", "message_type": "document", "content": "_radios_HAMZAOUI Anouar_20260330_10302165.pdf", "created_at": "2026-03-30T09:31:01.494294", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1877/download", "media_mime_type": "application/pdf"}, {"id": 8623, "message_id": "3EB00EC2F7A01566B719F4", "sender": "bot", "message_type": "document", "content": "_radios_HAMZAOUI Anouar_20260330_10305726.pdf", "created_at": "2026-03-30T09:31:35.806908", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1878/download", "media_mime_type": "application/pdf"}, {"id": 8624, "message_id": "A57A64DD266C58B1082AA64D331E3E6F", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija and French:\n\n**Arabic Script:**\n\"السلام عليكم مدام، صباح الخير، كي صبحتي مزيانة؟ مدام هاهو الراديو ديال راجلك، وإذا احتاجيتي أي حاجة، أي سؤال عيطي ليا. أنا صيفطت ليك جوج د الراديو قبل وبعد، قبل ما يحيد الضرسة، وقبل زعما ومن بعد ما يحيدها.\"\n\n**Latin Script (Transliteration):**\n\"Assalamu alaykum madame, sba7 l'khir, ki sbehti meziana? Madame hahouwa l'radio dyal rajlek, w ida htajiti ay 7aja, ay soual 3eyti liya. Ana seft lik jouj d l'radio qbel w be3d, qbel ma y7eyed ddersa, w qbel za3ma w men be3d ma y7eyedha.\"\n\n**Translation (for context):**\n\"Peace be upon you Madam, good morning, how are you doing? Madam, here is the X-ray of your husband, and if you need anything, or have any questions, call me. I sent you two X-rays, before and after; before he had the tooth removed, and—I mean—after he had it removed.\"", "created_at": "2026-03-30T09:31:51.388262", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1879/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8625, "message_id": "AC51EE8A728CF377BD64F1C96AF0E8B4", "sender": "user", "message_type": "voice", "content": "[Voice message] The transcription of the audio is as follows:\n\n**Arabic Script:**\n\"السلام عليكم، ça va؟ لاباس؟ بخير؟ الحمد لله، شكراً بزاف مرة أخرى.\"\n\n**Latin Script (Transliteration):**\n\"Assalamou alaykoum, ça va ? Labas ? Bikher ? Alhamdoulillah, choukran bzaf mra khera.\"", "created_at": "2026-03-30T09:33:50.586044", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1880/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8626, "message_id": "bot_AC51EE8A728CF377BD64F1C96AF0E8B4_695", "sender": "bot", "message_type": "text", "content": "بارك الله فيك، نتوما بخير؟ 😊 إذا احتاجيتو شي حاجة أخرى أو عندكوم أي سؤال على الراديو أو العلاج، حنا رهن الاشارة.", "created_at": "2026-03-30T09:34:23.243032", "media_url": null, "media_mime_type": null}, {"id": 8627, "message_id": "AC491B2A7BA43D3B331CA81606C49FB0", "sender": "user", "message_type": "text", "content": "شكرا", "created_at": "2026-03-30T09:34:39.609706", "media_url": null, "media_mime_type": null}, {"id": 8628, "message_id": "bot_AC491B2A7BA43D3B331CA81606C49FB0_1757", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻", "created_at": "2026-03-30T09:34:50.647500", "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 429 in training_review_items