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": 32646, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjEwOTc0NjQ3FQIAEhggQUMyRkY4OTUwODY0RDI2QkYwRDFCQkYwQ0U0N0FCODQA", "sender": "user", "message_type": "text", "content": "Xof akhti l7ri9 tzad 3liya lil kolo man3asat 7ta sa3a m3a 3adi tfet7o 3adi nkon tma", "created_at": "2026-05-20T03:28:33.371549", "media_url": null, "media_mime_type": null}, {"id": 32681, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjEwOTc0NjQ3FQIAERggQTVBN0M3NEQ5MDMzRkMwMTA2QThENERFNUJGRUU0MDkA", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-05-20T09:13:05.114465", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9406/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 32720, "message_id": "meta_495384013668010_wamid.HBgMMjEyNjEwOTc0NjQ3FQIAEhggQUMwRjIwMDY4QzU3NDExRjdEMDNBODEzMkYxMTYxMTQA", "sender": "user", "message_type": "text", "content": "Sba7 lkhir kan 3andi telephone tafi ana db xwiya 3anji", "created_at": "2026-05-20T09:30:12.174928", "media_url": null, "media_mime_type": null}, {"id": 32877, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjEwOTc0NjQ3FQIAERgWM0VCMEVGNDc1QTlDRTg2OEM3NUQxRAA=", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *1400,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-20T12:37:24.679048", "media_url": null, "media_mime_type": null}, {"id": 32878, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjEwOTc0NjQ3FQIAERgWM0VCMEM5NTJEODdBMUZFMkFGNUIyMgA=", "sender": "bot", "message_type": "document", "content": "", "created_at": "2026-05-20T12:37:46.915969", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9451/download", "media_mime_type": "application/pdf"}, {"id": 32879, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNjEwOTc0NjQ3FQIAERgWM0VCMDMzMTMxMTkwRTQ4N0U5QjM3NQA=", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BEKRAOUI ABDESLAM*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 25 mai 2026* à *15: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لديكم موعد مع ** يوم *الأثنين 25 ماي 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-20T12:41:13.448712", "media_url": null, "media_mime_type": null}, {"id": 35134, "message_id": "3EB0D531C0800AA7EDA4DD", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BEKRAOUI ABDESLAM*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 25 mai 2026* à *15: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لديكم موعد مع ** يوم *الأثنين 25 ماي 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-25T09:03:22.209469", "media_url": null, "media_mime_type": null}, {"id": 35304, "message_id": "3EB07F8E61F425EE4821A0", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BEKRAOUI ABDESLAM*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 25 mai 2026* à *15: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لديكم موعد مع ** يوم *الأثنين 25 ماي 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-25T13:12:26.114598", "media_url": null, "media_mime_type": null}, {"id": 35367, "message_id": "3EB02F63F7C46DC35E9015", "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 (*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-25T15:30:27.821567", "media_url": null, "media_mime_type": null}, {"id": 35368, "message_id": "3EB0B7B9F6555A0EC9D521", "sender": "bot", "message_type": "document", "content": "2026052516300747.pdf", "created_at": "2026-05-25T15:30:38.888298", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9975/download", "media_mime_type": "application/pdf"}, {"id": 37866, "message_id": "AC3C290F615F969BBDC67013C5D23239", "sender": "user", "message_type": "text", "content": "Salam, 3idkom mobarak.", "created_at": "2026-06-02T06:19:10.317898", "media_url": null, "media_mime_type": null}, {"id": 37867, "message_id": "bot_AC3C290F615F969BBDC67013C5D23239_4158", "sender": "bot", "message_type": "text", "content": "الله يبارك فيكوم، عيدكم مبارك سعيد 🎉 وكل عام وانتوما بخير!", "created_at": "2026-06-02T06:19:22.864743", "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 3024 in training_review_items