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": 47090, "message_id": "ACF485AC6ACA5F88FA19B5395E1E90DC", "sender": "user", "message_type": "text", "content": "Luna 8ans noussayba 7ans", "created_at": "2026-06-22T19:31:12.956425", "media_url": null, "media_mime_type": null}, {"id": 47091, "message_id": "bot_ACF485AC6ACA5F88FA19B5395E1E90DC_4631", "sender": "bot", "message_type": "text", "content": "Merci beaucoup !", "created_at": "2026-06-22T19:31:26.106288", "media_url": null, "media_mime_type": null}, {"id": 47092, "message_id": "bot_ACF485AC6ACA5F88FA19B5395E1E90DC_5270", "sender": "bot", "message_type": "text", "content": "Pour finaliser la demande, pouvez-vous me préciser le motif de la visite pour Luna et Noussayba (contrôle, douleur, soin particulier...) ainsi que vos disponibilités pour le rendez-vous ?", "created_at": "2026-06-22T19:31:26.162613", "media_url": null, "media_mime_type": null}, {"id": 47093, "message_id": "AC676CE01ECDD68F4F38D6B0319140C8", "sender": "user", "message_type": "text", "content": "Lina 8ans sanhaji et noussayba 7ans sanhaji", "created_at": "2026-06-22T19:31:37.071815", "media_url": null, "media_mime_type": null}, {"id": 47094, "message_id": "bot_AC676CE01ECDD68F4F38D6B0319140C8_2365", "sender": "bot", "message_type": "text", "content": "Merci pour la correction des prénoms et noms : Lina Sanhaji (8 ans) et Noussayba Sanhaji (7 ans).", "created_at": "2026-06-22T19:31:50.855432", "media_url": null, "media_mime_type": null}, {"id": 47095, "message_id": "bot_AC676CE01ECDD68F4F38D6B0319140C8_5539", "sender": "bot", "message_type": "text", "content": "Pouvez-vous me dire pourquoi vous souhaitez prendre rendez-vous pour elles (contrôle, douleur, soin spécifique...) et à quel moment vous seriez disponible ?", "created_at": "2026-06-22T19:31:50.889436", "media_url": null, "media_mime_type": null}, {"id": 47096, "message_id": "bot_AC676CE01ECDD68F4F38D6B0319140C8_3377", "sender": "bot", "message_type": "text", "content": "Dès que j’ai ces informations, je transmets la demande à l’équipe.", "created_at": "2026-06-22T19:31:50.920756", "media_url": null, "media_mime_type": null}, {"id": 47097, "message_id": "AC8DB69FA6F237121231D63A935CD877", "sender": "user", "message_type": "text", "content": "Cest pour des soins de carries. Combien le soin dune carri coute?", "created_at": "2026-06-22T19:31:57.244588", "media_url": null, "media_mime_type": null}, {"id": 47098, "message_id": "AC30C6BAEFCEB39DC2202F8D08FE3197", "sender": "user", "message_type": "text", "content": "<reply_to>Pouvez-vous me dire pourquoi vous souhaitez prendre rendez-vous pour elles (contrôle, douleur, soin spécifique...) et à quel moment vous seriez dis...</reply_to> Elles ont des carries", "created_at": "2026-06-22T19:32:17.234383", "media_url": null, "media_mime_type": null}, {"id": 47099, "message_id": "bot_AC30C6BAEFCEB39DC2202F8D08FE3197_3451", "sender": "bot", "message_type": "text", "content": "Le tarif pour le soin d'une carie dépend de la situation après évaluation par le Dr Haitham Boutaib.", "created_at": "2026-06-22T19:32:34.526366", "media_url": null, "media_mime_type": null}, {"id": 47100, "message_id": "bot_AC30C6BAEFCEB39DC2202F8D08FE3197_8739", "sender": "bot", "message_type": "text", "content": "La consultation est à 200DH, et le prix du traitement sera déterminé après examen.", "created_at": "2026-06-22T19:32:34.573054", "media_url": null, "media_mime_type": null}, {"id": 47101, "message_id": "bot_AC30C6BAEFCEB39DC2202F8D08FE3197_7458", "sender": "bot", "message_type": "text", "content": "Souhaitez-vous prendre un rendez-vous pour vos enfants ?", "created_at": "2026-06-22T19:32:34.618793", "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 3903 in training_review_items