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": 4548, "message_id": "3EB06B5538BE06DE352B4C", "sender": "bot", "message_type": "text", "content": "🔔 Human Intervention Required\n\nChatbot: Cabinet Dr. Haitham Boutaib\nReason: Patient asks for a detailed comparison between 'coiffure' and 'le bac' for upper teeth treatment\nCustomer: ريم\nPhone: 212673300720\n\nRecent conversation:\nBot: مرحبا ريم 😊 فهمت سؤالك. بالنسبة للقرار بين القوتير واللباق، من الأفضل أن Dr Haitham Boutaib يشوف الح\nCustomer: هذا هو الرقم ديالي.\nBot:", "created_at": "2026-03-14T13:04:59.042414", "media_url": null, "media_mime_type": null}, {"id": 4686, "message_id": "3EB08C096D44AB42456B47", "sender": "bot", "message_type": "text", "content": "🔔 Human Intervention Required\n\nChatbot: Cabinet Dr. Haitham Boutaib\nReason: Client requests verification of payment receipt with duplicate number on the invoice and previous session invoice\nCustomer: Sara Bensarghin\nPhone: 212636603922\n\nRecent conversation:\nBot: Je suis désolé pour ce désagrément. Je vais transmettre votre demande à l'équipe du Centre Dentaire \nCustomer: Sara Bensarghin\nBot:", "created_at": "2026-03-14T16:06:49.201636", "media_url": null, "media_mime_type": null}, {"id": 5035, "message_id": "3EB03744D6A8A15706FFF4", "sender": "bot", "message_type": "text", "content": "🔔 Intervention Humaine Requise\n\nNom de l'Agent IA : Cabinet Dr. Haitham Boutaib\nRaison : Patient sent an image of teeth with yellowish staining and asks if there is a solution. Human evaluation needed.\nClient : extract_from_user_id\nTéléphone : 212610586469", "created_at": "2026-03-15T19:08:43.452942", "media_url": null, "media_mime_type": null}, {"id": 5119, "message_id": "3EB00726F99B14F78A31E2", "sender": "bot", "message_type": "text", "content": "🔔 Intervention Humaine Requise\n\nNom de l'Agent IA : Cabinet Dr. Haitham Boutaib\nRaison : Client Bounif Khadija needs to reschedule her appointment to next week\nClient : Bounif Khadija\nTéléphone : 212684391355", "created_at": "2026-03-16T06:49:44.107463", "media_url": null, "media_mime_type": null}, {"id": 5191, "message_id": "3EB0A945D15144AC79F9D4", "sender": "bot", "message_type": "text", "content": "🔔 Intervention Humaine Requise\n\nNom de l'Agent IA : Cabinet Dr. Haitham Boutaib\nRaison : Client sent a bank transfer confirmation image for an implant advance payment. Verification needed.\nClient : Doha Oummany\nTéléphone : 212602366285", "created_at": "2026-03-16T11:06:58.497925", "media_url": null, "media_mime_type": null}, {"id": 5194, "message_id": "3EB04B8ACE3A62B7634CC3", "sender": "bot", "message_type": "text", "content": "🔔 Intervention Humaine Requise\n\nNom de l'Agent IA : Cabinet Dr. Haitham Boutaib\nRaison : Image received: confirmation of bank transfer from Mademoiselle Doha Oummany for 3100 Dirhams to Haitham Boutaib. Verification needed.\nClient : Doha Oummany\nTéléphone : 212602366285", "created_at": "2026-03-16T11:07:10.207347", "media_url": null, "media_mime_type": null}, {"id": 5328, "message_id": "3EB0FF6396963425E0421D", "sender": "bot", "message_type": "text", "content": "🔔 Intervention Humaine Requise\n\nNom de l'Agent IA : Cabinet Dr. Haitham Boutaib\nRaison : Patient asks about blanchiment dentaire price with best results\nClient : SAOUDI Khaoula\nTéléphone : 212675807436", "created_at": "2026-03-16T14:11:00.666481", "media_url": null, "media_mime_type": null}, {"id": 5377, "message_id": "3EB044D91E04D6EA0F46B5", "sender": "bot", "message_type": "text", "content": "🔔 Intervention Humaine Requise\n\nNom de l'Agent IA : Cabinet Dr. Haitham Boutaib\nRaison : Patient asks for price of blanchiment and composite replacement\nClient : BOUSBAL Yasamine\nTéléphone : 32465760249", "created_at": "2026-03-16T15:54:49.092812", "media_url": null, "media_mime_type": null}, {"id": 5540, "message_id": "3EB086EA14AE0D7AF67F12", "sender": "bot", "message_type": "text", "content": "🔔 Intervention Humaine Requise\n\nNom de l'Agent IA : Cabinet Dr. Haitham Boutaib\nRaison : Patient asks about duration of implant operation and required stay in Tanger\nClient : Unknown\nTéléphone : 33768552777", "created_at": "2026-03-16T21:30:47.489059", "media_url": null, "media_mime_type": null}, {"id": 5610, "message_id": "3EB0E170AE5085C480A475", "sender": "bot", "message_type": "text", "content": "🔔 Intervention Humaine Requise\n\nNom de l'Agent IA : Cabinet Dr. Haitham Boutaib\nRaison : Annulation de rendez-vous pour Najma Zargui\nClient : Najma Zargui\nTéléphone : 212698866997", "created_at": "2026-03-17T10:28:57.078098", "media_url": null, "media_mime_type": null}, {"id": 7544, "message_id": "3A62F9AD871C9535C03D", "sender": "user", "message_type": "text", "content": ".", "created_at": "2026-03-27T15:09:33.182316", "media_url": null, "media_mime_type": null}, {"id": 7545, "message_id": "bot_3A62F9AD871C9535C03D_3120", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 كيف يمكنني نعاونكوم اليوم؟", "created_at": "2026-03-27T15:09:51.764920", "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 265 in training_review_items