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": 46161, "message_id": "3A1E314169C9B77BEC30", "sender": "user", "message_type": "text", "content": "Good service tanks", "created_at": "2026-06-20T13:37:24.806575", "media_url": null, "media_mime_type": null}, {"id": 46162, "message_id": "bot_3A1E314169C9B77BEC30_3221", "sender": "bot", "message_type": "text", "content": "Good morning and thank you for your kind words!", "created_at": "2026-06-20T13:38:33.930646", "media_url": null, "media_mime_type": null}, {"id": 46163, "message_id": "bot_3A1E314169C9B77BEC30_801", "sender": "bot", "message_type": "text", "content": "صراحة أنا مجرد مساعد آلي (robo) وماعنديش إمكانية نشوف المواعيد الخاصة بالمرضى.", "created_at": "2026-06-20T13:38:33.973218", "media_url": null, "media_mime_type": null}, {"id": 46164, "message_id": "bot_3A1E314169C9B77BEC30_1522", "sender": "bot", "message_type": "text", "content": "غادي نبلغ الفريق الطبي ديالنا باش يتواصلوا معكوم ويردوا عليكوم بخصوص موعدكوم إن شاء الله.", "created_at": "2026-06-20T13:38:34.027842", "media_url": null, "media_mime_type": null}, {"id": 46165, "message_id": "bot_3A1E314169C9B77BEC30_8050", "sender": "bot", "message_type": "text", "content": "Thank you for your patience!", "created_at": "2026-06-20T13:38:34.069668", "media_url": null, "media_mime_type": null}, {"id": 46169, "message_id": "A5EF369A78D908754114F63AFE58CA25", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic script (as commonly written) and Latin script (Moroccan Darija style):\n\n**Arabic Script:**\nزبشي فينك؟ هو ما خدامش اليوم ياك؟ أنا صونيت عليه ما جاوبنيش، une fois يجاوبني راني نرد عليك.\n\n**Latin Script:**\nZebchi finek? Houwa ma khaddamch lyoum yak? Ana sonnit 3lih ma jawbnich, une fois yjawbni rani nredd 3lik.\n\n**Breakdown of languages used:**\n*   **Darija (Moroccan Arabic):** Most of the sentence (Zebchi finek? Houwa ma khaddamch lyoum yak? Ana sonnit 3lih ma jawbnich... rani nredd 3lik).\n*   **French:** \"une fois\" (once/as soon as).\n*   **Note:** \"Sonnit\" is a Moroccan verb derived from the French \"sonner\" (to ring/call).", "created_at": "2026-06-20T13:44:55.908259", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12810/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47339, "message_id": "3EB0E04FA86445B94AE6D2", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*JABER Bouyahya*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 25 juin 2026* à *16: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لديكم موعد مع ** يوم *الخميس 25 يونيو 2026* على الساعة *16:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-23T11:24:32.369481", "media_url": null, "media_mime_type": null}, {"id": 47340, "message_id": "3A3F079FC1C662D781F7", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-06-23T11:25:01.313845", "media_url": null, "media_mime_type": null}, {"id": 47341, "message_id": "bot_3A3F079FC1C662D781F7_1987", "sender": "bot", "message_type": "text", "content": "Merci pour votre retour !", "created_at": "2026-06-23T11:25:23.648097", "media_url": null, "media_mime_type": null}, {"id": 47342, "message_id": "bot_3A3F079FC1C662D781F7_9940", "sender": "bot", "message_type": "text", "content": "Votre rendez-vous avec le Dr Oussama Mouallem est bien noté pour le jeudi 25 juin 2026 à 16h00.", "created_at": "2026-06-23T11:25:23.694060", "media_url": null, "media_mime_type": null}, {"id": 47343, "message_id": "bot_3A3F079FC1C662D781F7_4625", "sender": "bot", "message_type": "text", "content": "Si jamais vous avez un empêchement, n’hésitez pas à contacter la réception au 060022263 ou 0539948014.", "created_at": "2026-06-23T11:25:23.740567", "media_url": null, "media_mime_type": null}, {"id": 47344, "message_id": "bot_3A3F079FC1C662D781F7_869", "sender": "bot", "message_type": "text", "content": "À bientôt et merci pour votre confiance !", "created_at": "2026-06-23T11:25:23.780482", "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 3931 in training_review_items