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": 7742, "message_id": "3EB0ABCD0E97ED13F076C7", "sender": "bot", "message_type": "document", "content": "2026032720413949.pdf", "created_at": "2026-03-27T19:42:25.344294", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1617/download", "media_mime_type": "application/pdf"}, {"id": 7743, "message_id": "3EB01CD48B3BFBC6936078", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *2600,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-03-27T19:42:37.469527", "media_url": null, "media_mime_type": null}, {"id": 7744, "message_id": "3EB00FE50DB4653D1377EE", "sender": "bot", "message_type": "document", "content": "2026032720420106.pdf", "created_at": "2026-03-27T19:42:50.280469", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1618/download", "media_mime_type": "application/pdf"}, {"id": 7752, "message_id": "3A58AA677F1974B4BD03", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-03-27T19:50:30.941809", "media_url": null, "media_mime_type": null}, {"id": 7753, "message_id": "bot_3A58AA677F1974B4BD03_8578", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻", "created_at": "2026-03-27T19:50:41.981888", "media_url": null, "media_mime_type": null}, {"id": 7754, "message_id": "3A6A2289CB2D9CF55902", "sender": "user", "message_type": "text", "content": "C quoi ton prenon", "created_at": "2026-03-27T19:50:57.303028", "media_url": null, "media_mime_type": null}, {"id": 7755, "message_id": "bot_3A6A2289CB2D9CF55902_672", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 أنا assistant ديال Centre Dentaire Tanger Bay. واش نقدر نعاونك بخصوص موعد، خدمة، ولا العنوان؟", "created_at": "2026-03-27T19:51:10.346018", "media_url": null, "media_mime_type": null}, {"id": 7756, "message_id": "3AA82F457E20C73D6156", "sender": "user", "message_type": "text", "content": "ماتعاونوني مانعاونكم تعلمو هي تكتبو بلغة سليمة باش يفهموكم الجميع", "created_at": "2026-03-27T20:40:19.897781", "media_url": null, "media_mime_type": null}, {"id": 7757, "message_id": "bot_3AA82F457E20C73D6156_6924", "sender": "bot", "message_type": "text", "content": "كنعتدر إذا كان شي حاجة ما كانتش واضحة. واش نقدر نعاونك فشي حاجة معينة؟", "created_at": "2026-03-27T20:40:34.315581", "media_url": null, "media_mime_type": null}, {"id": 7759, "message_id": "A51E01B1857DA8BB2EFE26E950E918AD", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here's the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"السلام عليكم سي ياسر، مزيان؟ بخير؟ هذا غير روبو كيبقى يكتب ماتجاوبوش، هذا غير روبو ماشي أنا اللي كنت كنهضر معاك.\"\n\n**Latin Script (Arabizi):**\n\"السلام عليكم Si Yasir، mzyan? bikhir? hada ghir robot kybqa ykteb matjawbouhsh, hada ghir robot machi ana li knt kan hdar m3ak.\"\n\n**Translation (for context):**\n\"Peace be upon you Si Yasir, are you good? fine? This is just a robot that keeps writing, don't reply to it. It's just a robot, it wasn't me who was talking to you.\"", "created_at": "2026-03-27T21:04:03.256957", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1620/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7766, "message_id": "3A96EC3A00D3B1531447", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in the original languages used (French and Moroccan Darija):\n\n**Latin Script:**\n\"Oui, salam. Kif dayer? Labas 3lik? Bikher? Kif dayer m3a l-khedma? Khedma s3iba daba?\"\n\n**Arabic Script:**\n\"وي، سلام. كي داير؟ لاباس عليك؟ بخير؟ كي داير مع الخدمة؟ الخدمة صعيبة دابا؟\"", "created_at": "2026-03-27T21:07:21.453839", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1622/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7767, "message_id": "bot_3A96EC3A00D3B1531447_6928", "sender": "bot", "message_type": "text", "content": "بارك الله فيك، نتمنى تكون الأمور كلها بخير. واش نقدر نعاونك فشي حاجة معينة؟", "created_at": "2026-03-27T21:07:51.079538", "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 331 in training_review_items