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": 36959, "message_id": "bot_3A3E1FDB49EEEFFB1A46_5681", "sender": "bot", "message_type": "text", "content": "Thank you!", "created_at": "2026-05-30T20:42:52.574864", "media_url": null, "media_mime_type": null}, {"id": 36960, "message_id": "bot_3A3E1FDB49EEEFFB1A46_313", "sender": "bot", "message_type": "text", "content": "I’ve sent the request for Usman Khan’s teeth cleaning on 12th June as well, together with your own.", "created_at": "2026-05-30T20:42:52.636681", "media_url": null, "media_mime_type": null}, {"id": 36961, "message_id": "bot_3A3E1FDB49EEEFFB1A46_3657", "sender": "bot", "message_type": "text", "content": "The team will contact you soon to confirm both appointments.", "created_at": "2026-05-30T20:42:52.689486", "media_url": null, "media_mime_type": null}, {"id": 36962, "message_id": "bot_3A3E1FDB49EEEFFB1A46_3853", "sender": "bot", "message_type": "text", "content": "Please note: your appointments will only be confirmed after our team contacts you directly 🙏🏻", "created_at": "2026-05-30T20:42:52.745990", "media_url": null, "media_mime_type": null}, {"id": 37340, "message_id": "3EB062177B8DCCDC688909", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*KHAWLAH Zaman*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 11 juin 2026* à *10: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*KHAWLAH*\r\nلديكم موعد مع ** يوم *الخميس 11 يونيو 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-01T09:47:39.278950", "media_url": null, "media_mime_type": null}, {"id": 37341, "message_id": "3EB0A3C24C9498F11E0312", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*USMAN Khan*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 11 juin 2026* à *10:45* .\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*USMAN*\r\nلديكم موعد مع ** يوم *الخميس 11 يونيو 2026* على الساعة *10:45*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-01T09:47:51.545808", "media_url": null, "media_mime_type": null}, {"id": 41044, "message_id": "3ABEAC8B48B1EA8484F7", "sender": "user", "message_type": "text", "content": "<reply_to>Bonjour \r\n*KHAWLAH Zaman*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 11 juin 2026* à *10:00* .\r\nEn cas d'empêchement, veuillez con...</reply_to> كم ثمن هذا", "created_at": "2026-06-09T18:55:12.045353", "media_url": null, "media_mime_type": null}, {"id": 41045, "message_id": "bot_3ABEAC8B48B1EA8484F7_7748", "sender": "bot", "message_type": "text", "content": "الثمن ديال consultation عندنا هو 200DH 😊 واش بغيتو شي خدمة إضافية أو عندكوم شي سؤال آخر؟", "created_at": "2026-06-09T18:55:24.652259", "media_url": null, "media_mime_type": null}, {"id": 41046, "message_id": "3AE3D65FB67564EB02C9", "sender": "user", "message_type": "text", "content": "For teeth cleaning ?", "created_at": "2026-06-09T18:57:11.799447", "media_url": null, "media_mime_type": null}, {"id": 41047, "message_id": "bot_3AE3D65FB67564EB02C9_7715", "sender": "bot", "message_type": "text", "content": "The price for teeth cleaning is determined after an evaluation, as it depends on your specific case.", "created_at": "2026-06-09T18:57:40.358201", "media_url": null, "media_mime_type": null}, {"id": 41048, "message_id": "bot_3AE3D65FB67564EB02C9_7440", "sender": "bot", "message_type": "text", "content": "If you’d like, you can book a consultation first (200DH) and Dr Haitham Boutaib will give you all the details and the exact price for the cleaning.", "created_at": "2026-06-09T18:57:40.424054", "media_url": null, "media_mime_type": null}, {"id": 41049, "message_id": "bot_3AE3D65FB67564EB02C9_2915", "sender": "bot", "message_type": "text", "content": "Would you like to schedule a consultation?", "created_at": "2026-06-09T18:57:40.480757", "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 3335 in training_review_items