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": 14330, "message_id": "3A21DB07276470C26589", "sender": "user", "message_type": "text", "content": "Rdv demain 12h ok confirmé?", "created_at": "2026-04-12T11:34:06.127764", "media_url": null, "media_mime_type": null}, {"id": 14340, "message_id": "A5470A3E936F1009F4EACA5F4BE042A1", "sender": "bot", "message_type": "voice", "content": "[Voice message] السلام عليكم، oui c’est confirmé demain matin ان شاء الله à midi.", "created_at": "2026-04-12T11:46:27.694686", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3695/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 14596, "message_id": "3A36842AB566D9E4C75C", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-04-13T07:07:09.676558", "media_url": null, "media_mime_type": null}, {"id": 14597, "message_id": "3AD8D1ACE712F71C3CAB", "sender": "user", "message_type": "text", "content": "Je peux venir pour l’ouverture svp?", "created_at": "2026-04-13T07:07:18.864628", "media_url": null, "media_mime_type": null}, {"id": 14598, "message_id": "3AC4214930883B5AC3B9", "sender": "user", "message_type": "text", "content": "Je suis dans le mal absolu", "created_at": "2026-04-13T07:07:30.410264", "media_url": null, "media_mime_type": null}, {"id": 14615, "message_id": "A571C3A0F10CCCDA0408E807B400B909", "sender": "bot", "message_type": "text", "content": "Bonjour", "created_at": "2026-04-13T08:05:52.556889", "media_url": null, "media_mime_type": null}, {"id": 14616, "message_id": "A5FFCA1E252FB3FB554FA781DEA56C0F", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic Script:**\n\"السلام عليكم سيدي، صباح الخير، ça va لاباس عليك؟ تقدر تجي مع الـ11؟\"\n\n**Latin Script:**\n\"Salamu alaykum sidi, sba7 l-khir, ça va labas 3lik? T9der tji m3a l-11?\"", "created_at": "2026-04-13T08:06:05.457882", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3755/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15345, "message_id": "A571622903372F6E497AF19442C1EDE6", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija:\n\n**\"السلام عليكم سيدي عباس، لاباس بخير؟ الصحة لاباس؟ أنا خطيت ليك لكونجي ديال لبارح، ما جيتيش، إيوا زعما غدوا عندي عامر مع التمنية.\"**\n\n**Transcription in Latin script:**\n\"Assalamu alaykum Sidi Abbas, labas bikhir? Seha labas? Ana khtit lek l'congé dyal lbarah, ma jitish. Ewa zaama ghadwa andi aamar m'a tmenya.\"\n\n**English Translation (for context):**\n\"Peace be upon you Mr. Abbas, how are you? Is your health okay? I marked your leave for yesterday, you didn't come. So tomorrow, my schedule is full starting from 8:00.\"", "created_at": "2026-04-14T09:47:37.058460", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3965/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16320, "message_id": "A530E2CB7433BC620F6AA54CE97CDB4E", "sender": "bot", "message_type": "text", "content": "Salam alikom", "created_at": "2026-04-15T16:16:56.798563", "media_url": null, "media_mime_type": null}, {"id": 16705, "message_id": "A5B96B7F292209F9CA5504215CF076EA", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija and French:\n\n**\"السلام عليكم، كيف دايرة؟ مزيان؟ بخير؟ الصحة لاباس؟ عافاك فوقاش بغيتي ناخد الـ rendez-vous؟\"**\n\n**Transliteration (Latin script):**\n\"Salam o-alaykum, kif dayra? Mezian? Bekhir? Seha labas? Aafak foqach bghiti nakhod l-rendez-vous?\"", "created_at": "2026-04-16T12:04:06.732796", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4458/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16731, "message_id": "3A0955BE4FD96504B14B", "sender": "user", "message_type": "voice", "content": "[Voice message] وعليكم السلام أختي، كيدايرة؟ لاباس؟ كلشي مزيان؟ بخير؟ الحمد لله.\n\nEuh non, je suis plus... je suis plus sur Tanger moi, c'est pour ça que j'ai pas répondu. مشيت، تما، ما بقيتش في طنجة.\n\nمشيت j'ai soigné، c'est pour ça. J'ai soigné ailleurs parce que j'avais pas le temps donc je suis parti.", "created_at": "2026-04-16T12:13:32.178336", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4463/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16734, "message_id": "bot_3A0955BE4FD96504B14B_882", "sender": "bot", "message_type": "text", "content": "بارك الله فيك على التوضيح، الحمد لله على سلامتك والله يسهل عليك فين ما كنتي. إذا احتاجيتي شي حاجة أخرى ولا بغيت ترجع عندنا مستقبلا، حنا دائما رهن الإشارة ديالكوم 😊", "created_at": "2026-04-16T12:14:16.652734", "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 1260 in training_review_items