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": 40738, "message_id": "bot_AC0D04EEE35116D54BAB6E993ED16E17_3284", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Bienvenue au Centre Dentaire Tanger Bay, cabinet du Dr Haitham Boutaib. Comment puis-je vous aider ?", "created_at": "2026-06-09T11:32:57.813188", "media_url": null, "media_mime_type": null}, {"id": 40739, "message_id": "AC65A4268E7757924B22A0129CA59064", "sender": "user", "message_type": "text", "content": "C est a combien le prix pour fixer une dent qui me manque", "created_at": "2026-06-09T11:34:20.581729", "media_url": null, "media_mime_type": null}, {"id": 40740, "message_id": "bot_AC65A4268E7757924B22A0129CA59064_6682", "sender": "bot", "message_type": "text", "content": "Le tarif pour fixer une dent manquante dépend de votre situation après évaluation par le Dr Haitham Boutaib 😊 La consultation est à 200DH.", "created_at": "2026-06-09T11:34:39.324415", "media_url": null, "media_mime_type": null}, {"id": 40741, "message_id": "bot_AC65A4268E7757924B22A0129CA59064_530", "sender": "bot", "message_type": "text", "content": "Souhaitez-vous prendre un rendez-vous pour une évaluation précise ?", "created_at": "2026-06-09T11:34:39.382447", "media_url": null, "media_mime_type": null}, {"id": 40742, "message_id": "ACFE2D48B6A836D4D0C3B83DDE2E25A0", "sender": "user", "message_type": "text", "content": "<reply_to>Souhaitez-vous prendre un rendez-vous pour une évaluation précise ?</reply_to> Oui", "created_at": "2026-06-09T11:35:26.503149", "media_url": null, "media_mime_type": null}, {"id": 40743, "message_id": "bot_ACFE2D48B6A836D4D0C3B83DDE2E25A0_691", "sender": "bot", "message_type": "text", "content": "Parfait ! 😊 Pouvez-vous me donner votre nom complet ainsi que vos disponibilités pour le rendez-vous ?", "created_at": "2026-06-09T11:35:38.489655", "media_url": null, "media_mime_type": null}, {"id": 40749, "message_id": "ACA0A69BF71C0A5B666789D67E3C8C27", "sender": "user", "message_type": "text", "content": "Samba lo", "created_at": "2026-06-09T11:36:45.825264", "media_url": null, "media_mime_type": null}, {"id": 40751, "message_id": "bot_ACA0A69BF71C0A5B666789D67E3C8C27_1805", "sender": "bot", "message_type": "text", "content": "Merci Samba Lo ! Pour finaliser la demande, pouvez-vous préciser quel créneau vous conviendrait le mieux pour la consultation ? (par exemple : matin, après-midi, ou un jour précis)", "created_at": "2026-06-09T11:36:57.302956", "media_url": null, "media_mime_type": null}, {"id": 40753, "message_id": "ACBA8B626BC7C4B362C3B5DE4A3B320E", "sender": "user", "message_type": "text", "content": "Je Suis a Tánger jusqu a vendredi", "created_at": "2026-06-09T11:37:13.501976", "media_url": null, "media_mime_type": null}, {"id": 40757, "message_id": "bot_ACBA8B626BC7C4B362C3B5DE4A3B320E_9134", "sender": "bot", "message_type": "text", "content": "Merci Samba Lo, c’est noté !", "created_at": "2026-06-09T11:37:26.041933", "media_url": null, "media_mime_type": null}, {"id": 40758, "message_id": "bot_ACBA8B626BC7C4B362C3B5DE4A3B320E_7021", "sender": "bot", "message_type": "text", "content": "L’équipe va vous contacter rapidement pour fixer un rendez-vous avant vendredi.", "created_at": "2026-06-09T11:37:26.108924", "media_url": null, "media_mime_type": null}, {"id": 40759, "message_id": "bot_ACBA8B626BC7C4B362C3B5DE4A3B320E_6428", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-09T11:37:26.176327", "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 3317 in training_review_items