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": 8404, "message_id": "AC0AB0250C4AA147A748E422C7222A4A", "sender": "user", "message_type": "text", "content": "La 3la arha sar", "created_at": "2026-03-29T14:44:11.690872", "media_url": null, "media_mime_type": null}, {"id": 8405, "message_id": "bot_AC0AB0250C4AA147A748E422C7222A4A_930", "sender": "bot", "message_type": "text", "content": "كنعتدر 😊 Centre Dentaire Tanger Bay ما كيتنافسش على السعر الأرخص، كيتنافس على أحسن نتيجة للمريض. إذا كان هدفكوم الجودة، أنتوما فالمكان الصحيح. واش بغيتو شي consultation باش يشوف دكتور الحالة ديالكوم بالضبط؟", "created_at": "2026-03-29T14:44:24.674258", "media_url": null, "media_mime_type": null}, {"id": 8406, "message_id": "AC4E2FC75E28F10C35BCFD2B19AE98BD", "sender": "user", "message_type": "text", "content": "Arhas wahd", "created_at": "2026-03-29T14:44:31.155105", "media_url": null, "media_mime_type": null}, {"id": 8407, "message_id": "bot_AC4E2FC75E28F10C35BCFD2B19AE98BD_6090", "sender": "bot", "message_type": "text", "content": "كنفهمكوم، ولكن ف Centre Dentaire Tanger Bay التركيز ديالنا هو على الجودة والنتيجة المضمونة للمريض، ماشي على أرخص ثمن. إذا كنتو مهتمين بالنتيجة الأحسن، مرحبا بيكوم. واش بغيتو شي consultation باش يشوف الدكتور الحالة ديالكوم؟", "created_at": "2026-03-29T14:44:44.553077", "media_url": null, "media_mime_type": null}, {"id": 8408, "message_id": "ACDF37A47A595977DE6E28C14CF197A2", "sender": "user", "message_type": "text", "content": "Safi by", "created_at": "2026-03-29T14:45:01.753346", "media_url": null, "media_mime_type": null}, {"id": 8409, "message_id": "AC25744F579B236BF2AF4B96B1DEA858", "sender": "user", "message_type": "text", "content": "Ahouya", "created_at": "2026-03-29T14:45:12.625578", "media_url": null, "media_mime_type": null}, {"id": 8410, "message_id": "bot_AC25744F579B236BF2AF4B96B1DEA858_8753", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 😊 إذا احتاجيتو شي حاجة فالمستقبل، حنا رهن الإشارة. نهاركم مبروك!", "created_at": "2026-03-29T14:45:21.302076", "media_url": null, "media_mime_type": null}, {"id": 8411, "message_id": "AC9B1CD9A93A789F611CDCD674DA6D7A", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-03-29T14:45:38.989185", "media_url": null, "media_mime_type": null}, {"id": 8412, "message_id": "bot_AC9B1CD9A93A789F611CDCD674DA6D7A_4682", "sender": "bot", "message_type": "text", "content": "مرحبا بيكوم 🙏🏻", "created_at": "2026-03-29T14:45:50.212455", "media_url": null, "media_mime_type": null}, {"id": 8471, "message_id": "A52E730543DEF5EFE41EF452DE0A1602", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nالسلام عليكم، كيف نتينا مزيان؟ بخير؟ الصحة لاباس؟ هاداك اللي كان كيجاوْبك الروبو، تفضل قولي شنو بغيتي تعمل، واش بغيتي تعمل السلك، ياك؟\n\n**Latin Script:**\n\"Salam o-alikom, kif ntina mzyan? bikhir? saha labas? Hadak li kan kay jawbek r-robot, tfadal qoli chnou bghiti t3mal, wach bghiti t3mal s-silk, yak?\"", "created_at": "2026-03-29T17:31:11.416573", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1850/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8483, "message_id": "AC354D9D4AA500C7597FFE2241B81012", "sender": "user", "message_type": "text", "content": "Ah", "created_at": "2026-03-29T17:59:00.076038", "media_url": null, "media_mime_type": null}, {"id": 8484, "message_id": "bot_AC354D9D4AA500C7597FFE2241B81012_6375", "sender": "bot", "message_type": "text", "content": "واخا تعطيني الإسم الكامل ديالك؟", "created_at": "2026-03-29T17:59:21.412707", "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 396 in training_review_items