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": 43059, "message_id": "bot_ACAFA83EE6B00A4C7B39296468C1C3FA_4594", "sender": "bot", "message_type": "text", "content": "Bonsoir 😊 Nous sommes le Centre Dentaire Tanger Bay, cabinet du Dr Haitham Boutaib.", "created_at": "2026-06-14T06:04:11.190760", "media_url": null, "media_mime_type": null}, {"id": 43060, "message_id": "bot_ACAFA83EE6B00A4C7B39296468C1C3FA_1433", "sender": "bot", "message_type": "text", "content": "Nous proposons des soins dentaires, chirurgie et orthodontie.", "created_at": "2026-06-14T06:04:11.262795", "media_url": null, "media_mime_type": null}, {"id": 43061, "message_id": "bot_ACAFA83EE6B00A4C7B39296468C1C3FA_4556", "sender": "bot", "message_type": "text", "content": "Vous souhaitez des informations sur un service en particulier ?", "created_at": "2026-06-14T06:04:11.327961", "media_url": null, "media_mime_type": null}, {"id": 43062, "message_id": "ACE070979CA58CCC2FFAD6CE5C6F01F7", "sender": "user", "message_type": "text", "content": "Il me semble que vous faites céramique", "created_at": "2026-06-14T06:05:58.301373", "media_url": null, "media_mime_type": null}, {"id": 43063, "message_id": "bot_ACE070979CA58CCC2FFAD6CE5C6F01F7_3522", "sender": "bot", "message_type": "text", "content": "Oui, tout à fait !", "created_at": "2026-06-14T06:06:16.800422", "media_url": null, "media_mime_type": null}, {"id": 43064, "message_id": "bot_ACE070979CA58CCC2FFAD6CE5C6F01F7_1016", "sender": "bot", "message_type": "text", "content": "Nous réalisons des facettes en céramique pour l’esthétique du sourire, ainsi que le contouring et l’harmonisation du sourire.", "created_at": "2026-06-14T06:06:16.867856", "media_url": null, "media_mime_type": null}, {"id": 43065, "message_id": "bot_ACE070979CA58CCC2FFAD6CE5C6F01F7_3633", "sender": "bot", "message_type": "text", "content": "Si vous souhaitez plus de détails ou une évaluation personnalisée, je peux transmettre votre demande à l’équipe.", "created_at": "2026-06-14T06:06:16.930347", "media_url": null, "media_mime_type": null}, {"id": 43066, "message_id": "bot_ACE070979CA58CCC2FFAD6CE5C6F01F7_4271", "sender": "bot", "message_type": "text", "content": "Souhaitez-vous prendre un rendez-vous ?", "created_at": "2026-06-14T06:06:16.991546", "media_url": null, "media_mime_type": null}, {"id": 43069, "message_id": "ACBCF2155CD4D09C545A0DEC6D07AA74", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-06-14T06:25:17.877681", "media_url": null, "media_mime_type": null}, {"id": 43070, "message_id": "bot_ACBCF2155CD4D09C545A0DEC6D07AA74_5338", "sender": "bot", "message_type": "text", "content": "Je transmets votre demande à l’équipe pour organiser un rendez-vous pour une consultation esthétique avec Dr Haitham Boutaib.", "created_at": "2026-06-14T06:25:30.777931", "media_url": null, "media_mime_type": null}, {"id": 43071, "message_id": "bot_ACBCF2155CD4D09C545A0DEC6D07AA74_4431", "sender": "bot", "message_type": "text", "content": "Vous serez contactée très prochainement pour la confirmation et les détails.", "created_at": "2026-06-14T06:25:30.834548", "media_url": null, "media_mime_type": null}, {"id": 43072, "message_id": "bot_ACBCF2155CD4D09C545A0DEC6D07AA74_1415", "sender": "bot", "message_type": "text", "content": "Merci pour votre confiance 😊", "created_at": "2026-06-14T06:25:30.905588", "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 3540 in training_review_items