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": 35120, "message_id": "bot_3AAE422E6EE7CC30F5F5_2909", "sender": "bot", "message_type": "text", "content": "صباح النور Chaimae 😊 حسب المعلومات اللي عندي، الفريق غادي يتواصل معكوم باش يأكدو لكوم الموعد ديال اليوم إن شاء الله. \n\nدير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-05-25T08:38:29.602412", "media_url": null, "media_mime_type": null}, {"id": 35122, "message_id": "A51EB7DC4596196758985B7748871B80", "sender": "bot", "message_type": "voice", "content": "[Voice message] The audio is in Moroccan Darija with a French loanword. Here is the transcription:\n\n**Arabic Script:**\nصباح الخير، صبحتي مزيان؟ على ود... بغيت نسولك واش عندك شي رانديفو؟\n\n**Latin Script:**\nSbah lkhir, sbehti mzyan? 3la wed... bghit nswlek wach 3ndek chi rendez-vous?\n\n**English Translation (for context):**\n\"Good morning, did you wake up well? Regarding... I wanted to ask you if you have an appointment?\"", "created_at": "2026-05-25T08:39:27.089758", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9930/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 35123, "message_id": "3A4EF6A243A1ECB69149", "sender": "user", "message_type": "text", "content": "Kunti kolti li tenin", "created_at": "2026-05-25T08:42:26.948885", "media_url": null, "media_mime_type": null}, {"id": 35124, "message_id": "3A5D1F2E1CDB8562245A", "sender": "user", "message_type": "text", "content": "Alghzalaa", "created_at": "2026-05-25T08:42:30.012227", "media_url": null, "media_mime_type": null}, {"id": 35125, "message_id": "A544D36D6E3628C1D6C9A36B79532874", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"لما ڤلتي ليا غادي نتسنى و رديت عليك، ما رديت عليك باش تسنى و نرد عليك نشوف شنو غادي ندير ولا لا، ماشي التنين، التنين فاش كان الـ rendez-vous كان عندي sur place و صيفط ليك ميساج.\"\n\n**Latin Script:**\n\"La ma gulti liya ghadi ntsenna w rddit 3lik, ma rddit 3lik bach ttsenna w nrdd 3lik nchouf chno ghadi ndir wlla la, machi ttnin, ttnin fach kan l-rendez-vous kan 3ndi sur place w sifft lik message.\"", "created_at": "2026-05-25T08:43:16.540747", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9931/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37347, "message_id": "3EB0DEFD2121DE7FB157DD", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*DRAOUI Oumaima*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 01 juin 2026* à *16: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لديكم موعد مع ** يوم *الأثنين 1 يونيو 2026* على الساعة *16:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-01T10:10:16.075620", "media_url": null, "media_mime_type": null}, {"id": 37762, "message_id": "3EB0DFA9FD5F83524DED84", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *2000,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-1300,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-01T17:13:39.013694", "media_url": null, "media_mime_type": null}, {"id": 37763, "message_id": "3EB023A280322AAE2D0FE9", "sender": "bot", "message_type": "document", "content": "2026060118130687.pdf", "created_at": "2026-06-01T17:14:07.233271", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10557/download", "media_mime_type": "application/pdf"}, {"id": 39046, "message_id": "3A32F55285E595B1E947", "sender": "user", "message_type": "text", "content": "Chaimae", "created_at": "2026-06-04T18:49:39.742337", "media_url": null, "media_mime_type": null}, {"id": 39047, "message_id": "bot_3A32F55285E595B1E947_3679", "sender": "bot", "message_type": "text", "content": "شكرا Chaimae، الرسالة ديالك وصلات للفريق وغادي يتواصلوا معك قريبا باش يأكدو لك الموعد ديال اليوم أو أي استفسار عندك إن شاء الله 🙏🏻", "created_at": "2026-06-04T18:50:09.546489", "media_url": null, "media_mime_type": null}, {"id": 39048, "message_id": "3A8CC3D431A064552303", "sender": "user", "message_type": "text", "content": "Eandi rendez vous lundi?", "created_at": "2026-06-04T18:50:20.444080", "media_url": null, "media_mime_type": null}, {"id": 39049, "message_id": "bot_3A8CC3D431A064552303_4976", "sender": "bot", "message_type": "text", "content": "الطلب ديالك وصل للفريق ولكن الموعد مزال ما تأكدش — غادي يتواصلوا بيكوم إن شاء الله 🙏🏻", "created_at": "2026-06-04T18:50:31.806716", "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 3152 in training_review_items