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": 11796, "message_id": "3EB0E1E23CFAC35CA0622D", "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\": \"This is a colorful and cheerful digital graphic featuring a cartoon tooth with large eyes, a smiling mouth, pink cheeks, and a striped party hat. The background image appears to show a dental clinic setting, with a dental chair and equipment slightly blurred and out of focus on the left side. Text at the top says 'HAPPY BIRTHDAY' in multi-colored, three-dimensional letters. The lower section of the graphic has two blue banners: the first reads 'TANGER BAY DENTAL CENTER' in white capital letters; the second (below), in smaller font, reads 'vous souhaite un bon anniversaire' in French, meaning 'wishes you a happy birthday.' The upper right features a white logo of a stylized tooth with the text 'TANGER BAY DENTAL CENTER' underneath.\",\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\nUser message context: Salut  Boussid Aya,\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:32.335419", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2931/download", "media_mime_type": "image/jpeg"}, {"id": 11970, "message_id": "AC79B09656501E7FE52F10BAB0D74E90", "sender": "user", "message_type": "text", "content": "Merci bcp❤️😍", "created_at": "2026-04-04T13:17:52.330039", "media_url": null, "media_mime_type": null}, {"id": 11971, "message_id": "bot_AC79B09656501E7FE52F10BAB0D74E90_5083", "sender": "bot", "message_type": "text", "content": "Avec plaisir Aya 😊 Toute l’équipe du Centre Dentaire Tanger Bay vous souhaite encore un très joyeux anniversaire ! Profitez bien de votre journée et n’hésitez pas si vous avez la moindre question ou envie de profiter de votre offre spéciale, on est là pour vous accompagner à tout moment.\n\nAu plaisir de vous revoir bientôt parmi nous !", "created_at": "2026-04-04T13:18:11.419939", "media_url": null, "media_mime_type": null}, {"id": 11972, "message_id": "AC2993B7CAD98BF1A0917B7393ABB890", "sender": "user", "message_type": "text", "content": "❤️❤️", "created_at": "2026-04-04T13:18:28.341624", "media_url": null, "media_mime_type": null}, {"id": 11973, "message_id": "bot_AC2993B7CAD98BF1A0917B7393ABB890_4999", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre gentillesse Aya ❤️😊 On reste à votre disposition quand vous voulez !", "created_at": "2026-04-04T13:18:42.674322", "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 766 in training_review_items