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": 7697, "message_id": "3EB0F9D12F9F5EFF94BEAC", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image features a cartoonish, smiling tooth character holding a checklist with a green check mark. The background shows a blurred dental clinic setting. At the top, there is the logo for 'TANGER BAY DENTAL CENTER' with a stylized tooth design. There is text reading 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and 'CHEZ TANGER BAY DENTAL CENTER'. The colors are primarily blue, white, and beige.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": null,\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": null,\n    \"alignment\": null,\n    \"calculus_plaque\": null,\n    \"periapical_areas\": null,\n    \"other_findings\": null\n  },\n  \"text_visible\": [\n    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n\nUser message context: Salut *ESSAUDI YASSMINA*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 28 mars 2026*\r\n🕘 Heure : *12:00*\r\n📍 Adresse : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)\r\n📞 Pour toute question : 06 60 02 22 63\r\n✅ Merci de nous confirmer votre présence en répondant « OUI » à ce message\r\n\r\n⚠️ IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement considéré comme annulé automatiquement. \r\nMerci de votre compréhension.", "created_at": "2026-03-27T18:10:38.578276", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1612/download", "media_mime_type": "image/jpeg"}, {"id": 7698, "message_id": "3A1A788375D8F74E30D9", "sender": "user", "message_type": "text", "content": "Salut localisation s'il te plaît", "created_at": "2026-03-27T18:12:26.698291", "media_url": null, "media_mime_type": null}, {"id": 7699, "message_id": "bot_3A1A788375D8F74E30D9_8368", "sender": "bot", "message_type": "text", "content": "Centre Dentaire Tanger Bay est situé à l'adresse suivante : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17). Voici le lien Google Maps pour vous aider à trouver notre emplacement : [https://maps.app.goo.gl/RCzcJXSXvgMzrRMFA](https://maps.app.goo.gl/RCzcJXSXvgMzrRMFA).", "created_at": "2026-03-27T18:12:52.454956", "media_url": null, "media_mime_type": null}, {"id": 7701, "message_id": "3AF3E24261B766B410CB", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-03-27T18:13:17.209033", "media_url": null, "media_mime_type": null}, {"id": 7702, "message_id": "bot_3AF3E24261B766B410CB_4589", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻", "created_at": "2026-03-27T18:13:29.677625", "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 310 in training_review_items