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": 38278, "message_id": "bot_AC858F6190DA3DD263DD70108E4F1152_2172", "sender": "bot", "message_type": "text", "content": "مرحبا amine laayoun 😊 تسجّل الطلب ديالكوم، والفريق غادي يتواصلوا بيكوم باش يأكدو الموعد ديال consultation diagnostic إن شاء الله 🙏🏻", "created_at": "2026-06-03T09:42:32.158362", "media_url": null, "media_mime_type": null}, {"id": 38627, "message_id": "ACAC51C5418B43C6E2627F6BC0987A2E", "sender": "user", "message_type": "text", "content": "Salut", "created_at": "2026-06-04T07:16:20.730154", "media_url": null, "media_mime_type": null}, {"id": 38628, "message_id": "bot_ACAC51C5418B43C6E2627F6BC0987A2E_2069", "sender": "bot", "message_type": "text", "content": "Salut et bienvenue 😊 Si vous avez besoin d’un rendez-vous ou d’une information, dites-moi comment je peux vous aider !", "created_at": "2026-06-04T07:16:33.450672", "media_url": null, "media_mime_type": null}, {"id": 38629, "message_id": "AC6CEB5557F2452EFB02128C0BE30713", "sender": "user", "message_type": "text", "content": "Je t'est demandé hier le rendez-vous", "created_at": "2026-06-04T07:17:32.058205", "media_url": null, "media_mime_type": null}, {"id": 38630, "message_id": "bot_AC6CEB5557F2452EFB02128C0BE30713_8594", "sender": "bot", "message_type": "text", "content": "Merci pour votre message !", "created_at": "2026-06-04T07:17:46.019177", "media_url": null, "media_mime_type": null}, {"id": 38631, "message_id": "bot_AC6CEB5557F2452EFB02128C0BE30713_9119", "sender": "bot", "message_type": "text", "content": "Votre demande de rendez-vous a bien été transmise à l’équipe, mais le rendez-vous n’est pas encore confirmé.", "created_at": "2026-06-04T07:17:46.075704", "media_url": null, "media_mime_type": null}, {"id": 38632, "message_id": "bot_AC6CEB5557F2452EFB02128C0BE30713_993", "sender": "bot", "message_type": "text", "content": "L’équipe va vous contacter pour la confirmation إن شاء الله 🙏🏻\n\nSi c’est urgent, n’hésitez pas à le préciser.", "created_at": "2026-06-04T07:17:46.133187", "media_url": null, "media_mime_type": null}, {"id": 38633, "message_id": "ACC0200D25C35D017C375AABB38AD8E6", "sender": "user", "message_type": "text", "content": "<reply_to>مرحبا amine laayoun 😊 تسجّل الطلب ديالكوم، والفريق غادي يتواصلوا بيكوم باش يأكدو الموعد ديال consultation diagnostic إن شاء الله 🙏🏻</reply_to> Tu m'a dit", "created_at": "2026-06-04T07:17:48.580915", "media_url": null, "media_mime_type": null}, {"id": 38634, "message_id": "bot_ACC0200D25C35D017C375AABB38AD8E6_9944", "sender": "bot", "message_type": "text", "content": "Je comprends, merci pour votre message.", "created_at": "2026-06-04T07:18:01.207072", "media_url": null, "media_mime_type": null}, {"id": 38635, "message_id": "bot_ACC0200D25C35D017C375AABB38AD8E6_8021", "sender": "bot", "message_type": "text", "content": "Pour l’instant, votre demande de rendez-vous a bien été transmise à l’équipe, mais le rendez-vous n’est pas encore confirmé — l’équipe va vous contacter pour la confirmation إن شاء الله 🙏🏻\n\nSi c’est urgent, vous pouvez aussi appeler directement la clinique au 05 37 86 02 03.", "created_at": "2026-06-04T07:18:01.260981", "media_url": null, "media_mime_type": null}, {"id": 41413, "message_id": "AC46A9B430D8E4C3BDA7F4786CA30A90", "sender": "user", "message_type": "text", "content": "Rdv svp", "created_at": "2026-06-10T13:53:06.114953", "media_url": null, "media_mime_type": null}, {"id": 41414, "message_id": "bot_AC46A9B430D8E4C3BDA7F4786CA30A90_1511", "sender": "bot", "message_type": "text", "content": "Votre demande est bien enregistrée, l’équipe va vous contacter pour confirmer le rendez-vous إن شاء الله 🙏🏻", "created_at": "2026-06-10T13:53:20.188771", "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 3361 in training_review_items