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": 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}, {"id": 41050, "message_id": "3A5DB26D678A5010151A", "sender": "user", "message_type": "text", "content": "<reply_to>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.</reply_to> Will he do the service on the day then?", "created_at": "2026-06-09T18:58:52.026494", "media_url": null, "media_mime_type": null}, {"id": 41051, "message_id": "bot_3A5DB26D678A5010151A_9914", "sender": "bot", "message_type": "text", "content": "Usually, the consultation and cleaning can be done on the same day if your case allows and there are no complications.", "created_at": "2026-06-09T18:59:03.523360", "media_url": null, "media_mime_type": null}, {"id": 41052, "message_id": "bot_3A5DB26D678A5010151A_1418", "sender": "bot", "message_type": "text", "content": "Dr Haitham Boutaib will first evaluate your teeth, and if everything is fine, he can proceed with the cleaning during the same appointment.", "created_at": "2026-06-09T18:59:03.590918", "media_url": null, "media_mime_type": null}, {"id": 41053, "message_id": "bot_3A5DB26D678A5010151A_7267", "sender": "bot", "message_type": "text", "content": "If you have any specific concerns or requests, let me know so I can note them for the team.", "created_at": "2026-06-09T18:59:03.654739", "media_url": null, "media_mime_type": null}, {"id": 41054, "message_id": "bot_3A5DB26D678A5010151A_7128", "sender": "bot", "message_type": "text", "content": "Would you like to confirm a consultation?", "created_at": "2026-06-09T18:59:03.722055", "media_url": null, "media_mime_type": null}, {"id": 41055, "message_id": "3A7B1D8CD4B1BE201E80", "sender": "user", "message_type": "text", "content": "<reply_to>Would you like to confirm a consultation?</reply_to> Yes just for khawlah zamab", "created_at": "2026-06-09T18:59:56.020999", "media_url": null, "media_mime_type": null}, {"id": 41056, "message_id": "3ACA1B7E3F7D1B1E4F35", "sender": "user", "message_type": "text", "content": "<reply_to>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 contac...</reply_to> Not for this person", "created_at": "2026-06-09T19:00:06.256016", "media_url": null, "media_mime_type": null}, {"id": 41060, "message_id": "bot_3ACA1B7E3F7D1B1E4F35_3484", "sender": "bot", "message_type": "text", "content": "Merci pour la précision !", "created_at": "2026-06-09T19:00:16.525208", "media_url": null, "media_mime_type": null}, {"id": 41061, "message_id": "bot_3ACA1B7E3F7D1B1E4F35_9573", "sender": "bot", "message_type": "text", "content": "Donc la demande de consultation est uniquement pour Khawlah Zaman, pas pour Usman Khan.", "created_at": "2026-06-09T19:00:16.576941", "media_url": null, "media_mime_type": null}, {"id": 41062, "message_id": "bot_3ACA1B7E3F7D1B1E4F35_7886", "sender": "bot", "message_type": "text", "content": "Pour bien transmettre la demande, pouvez-vous me confirmer le soin souhaité (détartrage/détartrage + autre chose) et le créneau qui vous arrange pour Khawlah Zaman ?", "created_at": "2026-06-09T19:00:16.641063", "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 3337 in training_review_items