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": 37650, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyNTA3NTE2ODgwMzExODU0Njc5MDQzODE0MTk1MgZDZD_5784", "sender": "bot", "message_type": "text", "content": "Merci Salma ! Il me manque juste le type de soin ou la raison de votre visite pour compléter la demande. Pouvez-vous me préciser ce dont vous avez besoin pour le rendez-vous demain ?", "created_at": "2026-06-01T15:06:32.221814", "media_url": null, "media_mime_type": null}, {"id": 37651, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyNTQzMjU5MjkxNjI5MDc0MzA2MjU0OTc1Nzk1MgZDZD", "sender": "user", "message_type": "text", "content": "Je voulais faire détartrage", "created_at": "2026-06-01T15:06:39.267497", "media_url": null, "media_mime_type": null}, {"id": 37653, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyNTYyNDQ1Nzk2MjU2OTk5Nzk1MTY0NjU2NDM1MgZDZD", "sender": "user", "message_type": "text", "content": "Et aussi l’appareil dentaire", "created_at": "2026-06-01T15:06:50.105711", "media_url": null, "media_mime_type": null}, {"id": 37655, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyNTYyNDQ1Nzk2MjU2OTk5Nzk1MTY0NjU2NDM1MgZDZD_5532", "sender": "bot", "message_type": "text", "content": "Merci Salma, votre demande pour un détartrage et l’appareil dentaire demain a bien été enregistrée. Notre équipe va vous contacter pour confirmer le rendez-vous إن شاء الله 🙏🏻", "created_at": "2026-06-01T15:07:02.455906", "media_url": null, "media_mime_type": null}, {"id": 37657, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyNjEzODcxMDQ4MzEzMjQ4OTYxMzA4ODY1MzMxMgZDZD", "sender": "user", "message_type": "text", "content": "Merci beaucoup", "created_at": "2026-06-01T15:07:17.641047", "media_url": null, "media_mime_type": null}, {"id": 37658, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyNjEzODcxMDQ4MzEzMjQ4OTYxMzA4ODY1MzMxMgZDZD_5225", "sender": "bot", "message_type": "text", "content": "Avec plaisir 😊 Si vous avez d’autres questions, n’hésitez pas ! Bonne journée à vous.", "created_at": "2026-06-01T15:07:28.182560", "media_url": null, "media_mime_type": null}, {"id": 37660, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyNjc1ODcyNTg5ODIwODU4MDk0NDUzNzg0NTc2MAZDZD", "sender": "user", "message_type": "text", "content": "À quelle heure", "created_at": "2026-06-01T15:07:51.283610", "media_url": null, "media_mime_type": null}, {"id": 37662, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyNjc1ODcyNTg5ODIwODU4MDk0NDUzNzg0NTc2MAZDZD_3817", "sender": "bot", "message_type": "text", "content": "Le cabinet est ouvert demain de 09h30 à 18h00. L’équipe va vous contacter pour vous proposer l’heure exacte selon les disponibilités. Si vous avez une préférence d’horaire, dites-le-moi !", "created_at": "2026-06-01T15:08:14.567301", "media_url": null, "media_mime_type": null}, {"id": 37663, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyNzg1NjE4NjczMTgwMjI0MjAxNjAyNzM0NDg5NgZDZD", "sender": "user", "message_type": "text", "content": "11h30", "created_at": "2026-06-01T15:08:50.624757", "media_url": null, "media_mime_type": null}, {"id": 37664, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyNzg1NjE4NjczMTgwMjI0MjAxNjAyNzM0NDg5NgZDZD_514", "sender": "bot", "message_type": "text", "content": "Merci, vous souhaitez donc un rendez-vous demain à 11h30. Pouvez-vous me préciser le motif de votre visite (par exemple : détartrage, appareil dentaire, etc.) ? Et j’aurais aussi besoin de votre numéro de téléphone pour transmettre la demande à l’équipe.", "created_at": "2026-06-01T15:09:01.885372", "media_url": null, "media_mime_type": null}, {"id": 37666, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyODY0NzIxMjA0MjE3NzYxNTE2NTg5ODM1ODc4NAZDZD", "sender": "user", "message_type": "text", "content": "Je voudrais faire les deux en même temps", "created_at": "2026-06-01T15:09:33.744306", "media_url": null, "media_mime_type": null}, {"id": 37667, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyODY0NzIxMjA0MjE3NzYxNTE2NTg5ODM1ODc4NAZDZD_7897", "sender": "bot", "message_type": "text", "content": "Merci pour la précision ! Pouvez-vous me donner votre numéro de téléphone pour que je transmette la demande à l’équipe et qu’ils puissent vous confirmer le rendez-vous pour demain à 11h30 ?", "created_at": "2026-06-01T15:09:45.358017", "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 3001 in training_review_items