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": 37498, "message_id": "bot_2AB02C872F36E613719C_1336", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-01T11:59:25.081934", "media_url": null, "media_mime_type": null}, {"id": 37499, "message_id": "A544FDCE7F106B4740DB9072F1642C18", "sender": "bot", "message_type": "voice", "content": "[Voice message] هذا هو التفريغ النصي للمقطع الصوتي (بالدارجة المغربية):\n\n**النص بالعربية:**\n\"السلام فاطمة الزهراء، كي دايرة، لاباس عليك، بخير؟ الصحة لاباس؟ فاطمة الزهراء عافاك، مع الدكتور ماهي واش ما غيكونش هاد السيمانة هادي؟ والله...\"\n\n**Transcription in Latin script (Darija):**\n\"Salam Fatim-Zahra, kidayra, labas 3lik, bikhir? Sa7a labas? Fatim-Zahra 3afak, m3a docteur Mahi wach maghaykounch had simana hadi? Wallah...\"", "created_at": "2026-06-01T11:59:26.708651", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10487/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37500, "message_id": "2A6666745BFBA771D549", "sender": "user", "message_type": "text", "content": "N’importe quel heure", "created_at": "2026-06-01T11:59:27.499287", "media_url": null, "media_mime_type": null}, {"id": 39400, "message_id": "2A5532BE461A427A30A3", "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**Arabic Script:**\n\"Salut... يلاه شفت الميساج ديالك. Ok ça marche. يلاه خودي لي rendez-vous هاد semaine الجاية، ok؟ ما كرهتش كون lundi ولا mardi.\"\n\n**Latin Script (Transliteration):**\n\"Salut... yallah cheft l-message dyalek. Ok ça marche. Yallah khoudi li rendez-vous had semaine jayya, ok? Makrahtch koun lundi wla mardi.\"\n\n**Translation (for context):**\n\"Hi... I just saw your message. Ok, that works. Go ahead and book me an appointment for next week, okay? I wouldn't mind if it's Monday or Tuesday.\"", "created_at": "2026-06-05T14:31:38.318878", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10955/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39404, "message_id": "bot_2A5532BE461A427A30A3_934", "sender": "bot", "message_type": "text", "content": "Merci Fatima !", "created_at": "2026-06-05T14:31:59.669224", "media_url": null, "media_mime_type": null}, {"id": 39405, "message_id": "bot_2A5532BE461A427A30A3_9153", "sender": "bot", "message_type": "text", "content": "C’est noté pour lundi ou mardi de la semaine prochaine pour continuer vos soins.", "created_at": "2026-06-05T14:31:59.726681", "media_url": null, "media_mime_type": null}, {"id": 39406, "message_id": "bot_2A5532BE461A427A30A3_8618", "sender": "bot", "message_type": "text", "content": "L’équipe va vous contacter très bientôt pour confirmer le rendez-vous.", "created_at": "2026-06-05T14:31:59.786467", "media_url": null, "media_mime_type": null}, {"id": 39407, "message_id": "bot_2A5532BE461A427A30A3_2671", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-05T14:31:59.845319", "media_url": null, "media_mime_type": null}, {"id": 40378, "message_id": "2A93055FDB28F626D608", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-06-08T12:59:03.743235", "media_url": null, "media_mime_type": null}, {"id": 40379, "message_id": "bot_2A93055FDB28F626D608_6898", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Bienvenue au Centre Dentaire Tanger Bay, cabinet du Dr Haitham Boutaib. Comment puis-je vous aider ?", "created_at": "2026-06-08T12:59:17.003887", "media_url": null, "media_mime_type": null}, {"id": 40380, "message_id": "2A1EC9C2ACD52586259A", "sender": "user", "message_type": "voice", "content": "[Voice message] The audio is in Moroccan Darija. Here is the transcription:\n\n**Arabic script:**\nألو، السلام عليكم، زعما مابقات خدمة والو؟ شوفوش...\n\n**Latin script (Darija):**\nAlo, Salamo alaykoum, ze3ma mabqat khdma walou? Shofosh...", "created_at": "2026-06-08T12:59:32.858065", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11204/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40383, "message_id": "bot_2A1EC9C2ACD52586259A_8066", "sender": "bot", "message_type": "text", "content": "وعليكم السلام! واش ممكن توضح ليا شنو بالضبط السؤال ديالك أو شنو محتاج تعرف؟ إذا عندك شي استفسار أو طلب معين، كتب لي التفاصيل هنا باش نقدر نعاونك أكتر.", "created_at": "2026-06-08T12:59:53.262061", "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 3279 in training_review_items