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": 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}, {"id": 41071, "message_id": "3A35629930F772293D2D", "sender": "user", "message_type": "text", "content": "How long is the service for ?", "created_at": "2026-06-09T19:03:28.408677", "media_url": null, "media_mime_type": null}, {"id": 41072, "message_id": "bot_3A35629930F772293D2D_5171", "sender": "bot", "message_type": "text", "content": "The appointment usually lasts between 30 and 45 minutes, but it can vary depending on your case. If you have any special requests or concerns, let me know!", "created_at": "2026-06-09T19:03:40.051815", "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 3340 in training_review_items