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": 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}, {"id": 41065, "message_id": "3A5464EF4405842BD709", "sender": "user", "message_type": "text", "content": "<reply_to>Donc la demande de consultation est uniquement pour Khawlah Zaman, pas pour Usman Khan.</reply_to> Yes, consultation and servuce only for Khawlah Zaman", "created_at": "2026-06-09T19:00:55.602326", "media_url": null, "media_mime_type": null}, {"id": 41066, "message_id": "bot_3A5464EF4405842BD709_6401", "sender": "bot", "message_type": "text", "content": "Merci pour la confirmation ! Pour finaliser la demande, pouvez-vous me préciser le jour et l'heure qui arrangent le plus Khawlah Zaman pour la consultation et le détartrage ?", "created_at": "2026-06-09T19:01:06.556470", "media_url": null, "media_mime_type": null}, {"id": 41067, "message_id": "3A69B7C0F60AE94CCB02", "sender": "user", "message_type": "text", "content": "Teeth cleaning service, what time do you open and close?", "created_at": "2026-06-09T19:01:47.470772", "media_url": null, "media_mime_type": null}, {"id": 41068, "message_id": "bot_3A69B7C0F60AE94CCB02_3463", "sender": "bot", "message_type": "text", "content": "Nous sommes ouverts du lundi au vendredi de 09h00 à 19h00, et le samedi de 09h00 à 14h00.", "created_at": "2026-06-09T19:01:58.612601", "media_url": null, "media_mime_type": null}, {"id": 41069, "message_id": "bot_3A69B7C0F60AE94CCB02_4443", "sender": "bot", "message_type": "text", "content": "Le dimanche, le cabinet est fermé.", "created_at": "2026-06-09T19:01:58.654904", "media_url": null, "media_mime_type": null}, {"id": 41070, "message_id": "bot_3A69B7C0F60AE94CCB02_9699", "sender": "bot", "message_type": "text", "content": "Souhaitez-vous un rendez-vous pour le détartrage à une date ou heure précise ?", "created_at": "2026-06-09T19:01:58.698529", "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 3339 in training_review_items