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": 48515, "message_id": "3A1FF550360697E6F0C8", "sender": "user", "message_type": "text", "content": "Donc emli tnine", "created_at": "2026-06-25T14:32:04.257779", "media_url": null, "media_mime_type": null}, {"id": 48516, "message_id": "3A901DD02CD40722A9D4", "sender": "user", "message_type": "text", "content": "O chof saea li dispo", "created_at": "2026-06-25T14:32:10.712218", "media_url": null, "media_mime_type": null}, {"id": 48517, "message_id": "3A33A2114FE8663A8EC5", "sender": "user", "message_type": "text", "content": "O mea dc haitam yak !?", "created_at": "2026-06-25T14:32:22.294025", "media_url": null, "media_mime_type": null}, {"id": 48518, "message_id": "A5132DA69E3739CF169298210B731260", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija (using both Arabic and Latin scripts):\n\n**Arabic Script:**\n\"آه، الدكتور هيثم غير قولي ليه غير يعطيني شوية د الوقت، وساعة ناخذ rendez-vous حيت مشغولة شوية في الـ PC، ساعة نرد عليك.\"\n\n**Latin Script (Transcription):**\n\"Ah, d-docteur Haitam ghir goli lih ghir ya3tini chwiya d l-weqt, o sa3a nakhod rendez-vous hit mchghoula chwiya f l-PC, sa3a n-rred 3lik.\"\n\n**Translation (for context):**\n\"Ah, Dr. Haitam, just tell him to give me a little bit of time, and then I’ll take an appointment because I'm a bit busy on the PC, I'll get back to you in an hour.\"", "created_at": "2026-06-25T14:32:44.593173", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13494/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 48519, "message_id": "3AC2F584158878F2839C", "sender": "user", "message_type": "text", "content": "Sf dik saea rod eliya", "created_at": "2026-06-25T14:32:59.455718", "media_url": null, "media_mime_type": null}, {"id": 48997, "message_id": "3AA71816A87DAF22DF6C", "sender": "user", "message_type": "text", "content": "!?", "created_at": "2026-06-26T12:43:56.338287", "media_url": null, "media_mime_type": null}, {"id": 49218, "message_id": "3EB0B2CE390AF7E6B2D3B5", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*DERAAOUI Ferdaouss*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 29 juin 2026* à *12: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لديكم موعد مع ** يوم *الأثنين 29 يونيو 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-26T18:30:48.712239", "media_url": null, "media_mime_type": null}, {"id": 49247, "message_id": "3A1493CB85879C64DB6B", "sender": "user", "message_type": "text", "content": "Sf nchealah🙏", "created_at": "2026-06-26T21:18:10.465648", "media_url": null, "media_mime_type": null}, {"id": 49248, "message_id": "bot_3A1493CB85879C64DB6B_7442", "sender": "bot", "message_type": "text", "content": "مرحبا Ferdaouss 😊 شكراً على التأكيد.", "created_at": "2026-06-26T21:18:38.333598", "media_url": null, "media_mime_type": null}, {"id": 49249, "message_id": "bot_3A1493CB85879C64DB6B_5283", "sender": "bot", "message_type": "text", "content": "الموعد ديالك مع الدكتور هيثم هو يوم الاثنين 29 يونيو 2026 مع 12:00.", "created_at": "2026-06-26T21:18:38.385382", "media_url": null, "media_mime_type": null}, {"id": 49250, "message_id": "bot_3A1493CB85879C64DB6B_4405", "sender": "bot", "message_type": "text", "content": "إذا وقع أي تغيير أو احتجتي تبدلي الوقت، يمكن لك تتواصلي معانا في أي وقت.", "created_at": "2026-06-26T21:18:38.432408", "media_url": null, "media_mime_type": null}, {"id": 49251, "message_id": "bot_3A1493CB85879C64DB6B_8868", "sender": "bot", "message_type": "text", "content": "مرحبا بيكوم إن شاء الله 🙏🏻", "created_at": "2026-06-26T21:18:38.480264", "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 4047 in training_review_items