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": 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}, {"id": 37668, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyOTU2NjA0MTQxMzAxMDAzNjEzODM2MzA2MDIyNAZDZD", "sender": "user", "message_type": "text", "content": "0725121684", "created_at": "2026-06-01T15:10:23.191243", "media_url": null, "media_mime_type": null}, {"id": 37670, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIyOTU2NjA0MTQxMzAxMDAzNjEzODM2MzA2MDIyNAZDZD_5429", "sender": "bot", "message_type": "text", "content": "Merci beaucoup ! Votre demande est enregistrée pour un détartrage et un appareil dentaire demain à 11h30. Notre équipe va vous contacter pour confirmer le rendez-vous إن شاء الله 🙏🏻\n\nPouvez-vous aussi me donner votre nom complet pour finaliser la demande ?", "created_at": "2026-06-01T15:10:36.493955", "media_url": null, "media_mime_type": null}, {"id": 37671, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIzMDUyOTk3Nzk3OTkzNjYwMDU3MTI2OTYxMTUyMAZDZD", "sender": "user", "message_type": "text", "content": "Salma Benkhaibar", "created_at": "2026-06-01T15:11:15.582758", "media_url": null, "media_mime_type": null}, {"id": 37672, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIzMDUyOTk3Nzk3OTkzNjYwMDU3MTI2OTYxMTUyMAZDZD_9005", "sender": "bot", "message_type": "text", "content": "Merci Salma Benkhaibar ! J’ai bien noté votre nom. Votre demande est complète, l’équipe va vous contacter pour confirmer le rendez-vous إن شاء الله 🙏🏻", "created_at": "2026-06-01T15:11:26.919864", "media_url": null, "media_mime_type": null}, {"id": 37673, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIzMTQ4NzUzNTUxNTE4ODUyMzY1MTU1MDkzNzA4OAZDZD", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-06-01T15:12:07.640498", "media_url": null, "media_mime_type": null}, {"id": 37674, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTIzMTQ4NzUzNTUxNTE4ODUyMzY1MTU1MDkzNzA4OAZDZD_5612", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيك 😊 واش كاين شي حاجة أخرى نقدر نعاونكوم بها؟", "created_at": "2026-06-01T15:12:19.784256", "media_url": null, "media_mime_type": null}, {"id": 37693, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTI0ODc4MDg2NTA5NTA1NTg1ODQwMzc4Mzk5OTQ4OAZDZD", "sender": "user", "message_type": "text", "content": "Je voudrais savoir les tarifs s’il vous plait", "created_at": "2026-06-01T15:27:45.120695", "media_url": null, "media_mime_type": null}, {"id": 37694, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTI0ODc4MDg2NTA5NTA1NTg1ODQwMzc4Mzk5OTQ4OAZDZD_3527", "sender": "bot", "message_type": "text", "content": "Le tarif dépend de votre cas 😊 L’équipe doit d’abord évaluer votre situation pour vous donner un devis précis. Ils vont vous contacter très bientôt avec tous les détails. Si vous avez une question sur un soin spécifique, n’hésitez pas à me le préciser !", "created_at": "2026-06-01T15:28:10.247317", "media_url": null, "media_mime_type": null}, {"id": 37813, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTQ1MTY5MjUyMTIwNzczNjU1ODAwMDczODkyNjU5MgZDZD", "sender": "user", "message_type": "text", "content": "Je n’ai pas reçu aucun appel de votre part pour la confirmation,", "created_at": "2026-06-01T18:31:05.425145", "media_url": null, "media_mime_type": null}, {"id": 37814, "message_id": "meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTQ1MTcxNDY5MDM3NTYzNzEzMzYyMzkwNDE3NDA4MAZDZD", "sender": "user", "message_type": "text", "content": "?", "created_at": "2026-06-01T18:31:06.752282", "media_url": null, "media_mime_type": null}, {"id": 37815, "message_id": "bot_meta_1126507554064860_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDQ4MjcwMDU0NDU2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTU0NTgwMTI2ODY0Nzc0MjozMjg0MTQ1MTcxNDY5MDM3NTYzNzEzMzYyMzkwNDE3NDA4MAZDZD_4952", "sender": "bot", "message_type": "text", "content": "Je comprends votre inquiétude. صراحة أنا مجرد مساعد آلي (روبو)، وقد أرسلنا طلبكم للفريق. Si c’est urgent, vous pouvez aussi appeler directement le cabinet au 05 37 86 02 03. Merci pour votre patience !", "created_at": "2026-06-01T18:31:21.604279", "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 3015 in training_review_items