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": 44353, "message_id": "A5FA8A64A0237EDE9D0D706B79E5FEAE", "sender": "bot", "message_type": "voice", "content": "[Voice message] بالتأكيد، هذا هو التفريغ النصي للمقطع الصوتي باللهجة المغربية (الدارجة):\n\n\"**السلام عليكم، أهلاً سي محمد، كي تيتي مزيان؟ بخير؟ عواشر مبروكة، ربي يخليك، كي تيتي؟ كلشي هو هداك؟ مرحباً بك، قولي.**\"", "created_at": "2026-06-16T13:16:29.737257", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12215/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44358, "message_id": "AC246E0E3498792F17AE8C0C79DB7142", "sender": "user", "message_type": "text", "content": "Ila tsowli doctor imta n9edu ndiro chi glissa nchofo chnou ndiro f hadchi li b9a", "created_at": "2026-06-16T13:21:04.257789", "media_url": null, "media_mime_type": null}, {"id": 44359, "message_id": "AC4AD2FEC542918364FF5BABE83C45E9", "sender": "user", "message_type": "text", "content": "Accord dial prise en charge rah sifatu lik", "created_at": "2026-06-16T13:21:32.908777", "media_url": null, "media_mime_type": null}, {"id": 44360, "message_id": "A53369B6DE618DC7937DE3509A2035B6", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**\"Bonsoir, chi l'accord fin weslou nchoufou?\"**\n\n**Arabic script:**\n\"بونسوار، شي l'accord فين وصلوا نشوفوا؟\"\n\n**Translation (for context):**\n\"Good evening, let's see where they've reached with the agreement/deal?\"", "created_at": "2026-06-16T13:24:40.129183", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12217/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44361, "message_id": "A5DB9F4D72B4FF76FEC205610A5B1969", "sender": "bot", "message_type": "voice", "content": "[Voice message] صافي وخا، أنا نقول للدكتور.", "created_at": "2026-06-16T13:24:43.908392", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12218/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44431, "message_id": "AC90EC2F61A7E8F11587BF3337B1727C", "sender": "user", "message_type": "document", "content": "26851673.pdf", "created_at": "2026-06-16T14:12:09.442394", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12238/download", "media_mime_type": "application/pdf"}, {"id": 44475, "message_id": "3EB0B93F76F3AFF9E271E0", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*AGGOUR  Mohammed*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 25 juin 2026* à *11:30* .\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* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-16T14:29:39.922667", "media_url": null, "media_mime_type": null}, {"id": 47238, "message_id": "AC6B06C0BC1D583FDB0D64F6709C16F8", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-06-23T09:10:02.369153", "media_url": null, "media_mime_type": null}, {"id": 47239, "message_id": "ACF28BA7B1EE9F9DD72C732A3BBD0B2F", "sender": "user", "message_type": "text", "content": "Ila kan momkin n9ed nakhed chi rendez vous m3a 3 wla 4 pm", "created_at": "2026-06-23T09:10:28.932843", "media_url": null, "media_mime_type": null}, {"id": 47247, "message_id": "bot_ACF28BA7B1EE9F9DD72C732A3BBD0B2F_6022", "sender": "bot", "message_type": "text", "content": "بلغت الفريق بطلبك باش يتبدل الموعد من 11:30 لشي وقت بين 3 و4 ديال العشية نهار الخميس إن شاء الله.", "created_at": "2026-06-23T09:11:02.248916", "media_url": null, "media_mime_type": null}, {"id": 47248, "message_id": "bot_ACF28BA7B1EE9F9DD72C732A3BBD0B2F_4344", "sender": "bot", "message_type": "text", "content": "الفريق غادي يتواصل معاك باش يأكدو واش ممكن هاد التغيير.", "created_at": "2026-06-23T09:11:02.296418", "media_url": null, "media_mime_type": null}, {"id": 47249, "message_id": "bot_ACF28BA7B1EE9F9DD72C732A3BBD0B2F_9612", "sender": "bot", "message_type": "text", "content": "دير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-06-23T09:11:02.345588", "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 3926 in training_review_items