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": 8618, "message_id": "3EB001EE61739512988674", "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 is a colorful, cartoon-style promotional graphic for a dental clinic. The main focus is a large, smiling cartoon tooth character wearing a striped birthday hat. The background appears to be a bright, modern dental office with dental equipment and cabinetry visible but blurred. At the top, large colorful letters spell out 'HAPPY BIRTHDAY.' The logo and name 'TANGER BAY DENTAL CENTER' appear in the corner with a stylized tooth graphic. Below the tooth, there is a blue banner with white text reading 'TANGER BAY DENTAL CENTER' and underneath, another blue banner with the French phrase 'vous souhaite un bon anniversaire.' The environment is bright and clean, reinforcing a friendly, cheerful, and professional dental clinic atmosphere.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\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\nUser message context: Salut  JANOUI Nadia,\r\nNous voulions vous adresser nos vœux les plus chaleureux pour votre anniversaire ! 🥳\r\nNous sommes heureux de célébrer cette occasion spéciale avec vous en tant que patient fidèle.\r\n\r\nÀ cette occasion, nous avons le plaisir de vous offrir une réduction exceptionnelle de 20% sur le blanchiment dentaire + le nettoyage, valable tout au long de votre mois d’anniversaire. ✨🦷\r\n\r\nNous espérons que votre journée sera remplie de bonheur et de moments mémorables.\r\nSi vous avez besoin de quoi que ce soit ou si vous avez des questions, n'hésitez pas à nous contacter.\r\nAvec toute mon affection,\r\n[ Cabient Dr. Boutaib Haitham ]", "created_at": "2026-03-30T09:25:00.268512", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1873/download", "media_mime_type": "image/jpeg"}, {"id": 8676, "message_id": "A56E497BC56BF73D65CEE45BA2B3C9C8", "sender": "user", "message_type": "text", "content": "Merci awele mara qolali chiwahede  mene rire weladi", "created_at": "2026-03-30T10:17:47.689484", "media_url": null, "media_mime_type": null}, {"id": 8682, "message_id": "bot_A56E497BC56BF73D65CEE45BA2B3C9C8_6675", "sender": "bot", "message_type": "text", "content": "Avec plaisir 😊 Si vous avez besoin de plus d’informations ou si vous souhaitez profiter de l’offre, je suis là pour vous aider. Passez une excellente journée et encore joyeux anniversaire !", "created_at": "2026-03-30T10:18:25.640548", "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 444 in training_review_items