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": 11793, "message_id": "3EB0B46D1AC235452C3D3F", "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, well-lit graphic. It features a large cartoon tooth character in the foreground, smiling and wearing a striped birthday party hat. In the background, there appears to be a dental clinic setting with a dental chair and bright window, slightly out of focus. At the top, large multi-colored letters spell out 'HAPPY BIRTHDAY'. The lower section contains two blue banners with white text. The top banner says 'TANGER BAY DENTAL CENTER' in capital letters, and the lower banner says 'vous souhaite un bon anniversaire', which is French for 'wishes you a happy birthday.' In the upper right corner is a dental-themed logo with a stylized tooth and the text 'TANGER BAY DENTAL CENTER'. The overall style is festive and friendly.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"\",\n    \"alignment\": \"\",\n    \"calculus_plaque\": \"\",\n    \"periapical_areas\": \"\",\n    \"other_findings\": \"\"\n  },\n  \"\n\nUser message context: Salut  BENYAHYA Hanan,\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-04-04T09:23:05.802384", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2929/download", "media_mime_type": "image/jpeg"}, {"id": 11842, "message_id": "3AD3FEDCF18CC4968470", "sender": "user", "message_type": "text", "content": "Bonjour merci bcp", "created_at": "2026-04-04T10:23:43.078796", "media_url": null, "media_mime_type": null}, {"id": 11843, "message_id": "bot_3AD3FEDCF18CC4968470_2108", "sender": "bot", "message_type": "text", "content": "Bonjour Hanan 😊 Merci pour votre gentil message ! Toute l’équipe du Centre Dentaire Tanger Bay vous souhaite encore un joyeux anniversaire 🎉\n\nSi vous souhaitez profiter de la réduction sur le blanchiment et le nettoyage, ou si vous avez la moindre question, dites-le-moi, je suis là pour vous aider ! Passez une excellente journée ✨", "created_at": "2026-04-04T10:24:00.527376", "media_url": null, "media_mime_type": null}, {"id": 12254, "message_id": "3A6B01A46608675966A5", "sender": "user", "message_type": "text", "content": "Merci encore une fois", "created_at": "2026-04-05T09:33:10.282591", "media_url": null, "media_mime_type": null}, {"id": 12255, "message_id": "bot_3A6B01A46608675966A5_1101", "sender": "bot", "message_type": "text", "content": "Avec plaisir, Hanan ! 🎂 N’hésitez pas si vous avez besoin de quoi que ce soit. Belle journée à vous !", "created_at": "2026-04-05T09:33:24.767294", "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 798 in training_review_items