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": 27949, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzAxMTYyMDE4FQIAERgWM0VCMDI0MTVEMjQzRTBBOERBNEQxMwA=", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *2800,00* dirhams (*Espèce*) 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-05-12T16:18:45.889596", "media_url": null, "media_mime_type": null}, {"id": 27950, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzAxMTYyMDE4FQIAERgWM0VCMEM5RDgxQzUxNjMyNUVGREU1NAA=", "sender": "bot", "message_type": "document", "content": "", "created_at": "2026-05-12T16:19:14.477910", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/8101/download", "media_mime_type": "application/pdf"}, {"id": 27956, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzAxMTYyMDE4FQIAERggQTVCNTY3QzkxOTc5NkYzRjUxRTAzMTlENzExNjIyRjQA", "sender": "bot", "message_type": "document", "content": "", "created_at": "2026-05-12T16:21:11.719044", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/8103/download", "media_mime_type": "application/pdf"}, {"id": 27957, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzAxMTYyMDE4FQIAERggQTVCNUFGRDJBRUNGMjc5MTU5Q0VCQ0U4MzUyNUQxQkYA", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-05-12T16:21:14.450218", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/8104/download", "media_mime_type": "video/mp4"}, {"id": 27958, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzAxMTYyMDE4FQIAERggQTUyQzE2NjBBQzVGMkM1RTEzQkRFQjQ0MjNGNjE3QzMA", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-05-12T16:21:15.279732", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/8105/download", "media_mime_type": "video/mp4"}, {"id": 27959, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzAxMTYyMDE4FQIAERggQTU2MjQ3NjVBMDI0QTg0MkU1RjU3M0M4OUY2NDdFOEQA", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-05-12T16:21:16.660913", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/8106/download", "media_mime_type": "video/mp4"}, {"id": 27960, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzAxMTYyMDE4FQIAERgWM0VCMDkxRDAwNjBDMjI0NzNGRUFCQgA=", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL LAHIOUI WIAME*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 21 mai 2026* à *17: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لديكم موعد مع ** يوم *الخميس 21 ماي 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-12T16:21:52.209468", "media_url": null, "media_mime_type": null}, {"id": 32715, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzAxMTYyMDE4FQIAERgWM0VCMDFGMzE4MzI5NTM4RDg3N0EyMQA=", "sender": "bot", "message_type": "image", "content": "Salut  EL LAHIOUI WIAME,\r\nNous voulions vous adresser nos vœux les plus chaleureux pour votre anniversaire ! 🥳\r\nNous sommes heureux de célébrer cette occasion spéciale avec vous en tant que patient fidèle.\r\n\r\nÀ cette occasion, nous avons le plaisir de vous offrir une réduction exceptionnelle de 20% sur le blanchiment dentaire + le nettoyage, valable tout au long de votre mois d’anniversaire. ✨🦷\r\n\r\nNous espérons que votre journée sera remplie de bonheur et de moments mémorables.\r\nSi vous avez besoin de quoi que ce soit ou si vous avez des questions, n'hésitez pas à nous contacter.\r\nAvec toute mon affection,\r\n[ Cabient Dr. Boutaib Haitham ]", "created_at": "2026-05-20T09:26:53.681070", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9410/download", "media_mime_type": "image/jpeg"}, {"id": 32782, "message_id": "meta_495384013668010_wamid.HBgMMjEyNzAxMTYyMDE4FQIAEhgUM0FGNTJGQ0IyQTRBRjEyQUE5MzQA", "sender": "user", "message_type": "text", "content": "Merci 🤩", "created_at": "2026-05-20T10:41:03.224887", "media_url": null, "media_mime_type": null}, {"id": 32783, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNzAxMTYyMDE4FQIAEhgUM0FGNTJGQ0IyQTRBRjEyQUE5MzQA_763", "sender": "bot", "message_type": "text", "content": "Avec plaisir 😊 Si vous avez besoin de quelque chose, je suis là !", "created_at": "2026-05-20T10:41:18.089331", "media_url": null, "media_mime_type": null}, {"id": 38853, "message_id": "3AE8BF47D843B03278BA", "sender": "user", "message_type": "voice", "content": "[Voice message] سلام أختي، صافا بخير؟ أنا قلت ليك، أنا دابا شي حاجة ما جاي نتريني على حساب لعاميتي (l'amitié)، صافي؟ أنا ووئام لّـهيه.\n\n**Latin Script (Darija/French mix):**\n\"Salam akhti, ça va bikhir? Ana galt lik, ana daba chi haja ma jay n-train-i 3la hsab l'amitié, safi? Ana w Wiam l-hih.\"", "created_at": "2026-06-04T12:26:26.070465", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10800/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 38854, "message_id": "bot_3AE8BF47D843B03278BA_8060", "sender": "bot", "message_type": "text", "content": "مرحبا بيكوم 😊 واش ممكن توضحولي شنو بالضبط محتاجين أو كيفاش نقدر نعاونكوم؟ إذا ممكن تكتبو ليا التفاصيل هنا باش نفهم مزيان.", "created_at": "2026-06-04T12:26:52.184328", "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 3134 in training_review_items