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": 13878, "message_id": "3EB07543B0B8F20F1C48CB", "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, professionally designed greeting image with a dental theme. It features a large, cartoon-style tooth with a smiling face and rosy cheeks, wearing a striped birthday party hat. The background shows a blurred dental clinic environment, with visible elements including a dental chair, a dental lamp, and drawers, all in soft pastel tones. At the top of the image, the phrase 'HAPPY BIRTHDAY' is written in large, multicolored letters. In the upper right corner, the logo of 'TANGER BAY DENTAL CENTER' is present, showing a stylized tooth and the center's name. Over the lower part of the image, there are two blue bars with text: the first says 'TANGER BAY DENTAL CENTER' in uppercase white letters, and the second says 'vous souhaite un bon anniversaire' in lowercase white letters.\",\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\nUser message context: Salut  SAHSAHI Houda,\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-11T09:25:31.395105", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3585/download", "media_mime_type": "image/jpeg"}, {"id": 13980, "message_id": "3A69906F28BB4DEDC108", "sender": "user", "message_type": "text", "content": "<reply_to>Salut  SAHSAHI Houda,\r\nNous voulions vous adresser nos vœux les plus chaleureux pour votre anniversaire ! 🥳\r\nNous sommes heureux de célébrer cette ...</reply_to> Merci 🙏🏻", "created_at": "2026-04-11T11:48:27.036273", "media_url": null, "media_mime_type": null}, {"id": 13981, "message_id": "bot_3A69906F28BB4DEDC108_9621", "sender": "bot", "message_type": "text", "content": "Merci beaucoup Houda 😊 Toute l’équipe du Centre Dentaire Tanger Bay vous souhaite encore un joyeux anniversaire ! Si vous souhaitez profiter de la réduction ou avez la moindre question, on reste à votre disposition. Passez une très belle journée !", "created_at": "2026-04-11T11:48:47.217303", "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 959 in training_review_items