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": 14698, "message_id": "3EB0B6DEBE8D55E8094925", "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 brightly colored, cheerful digital graphic with a dental theme. At the center is a cartoon tooth character with a happy face, round eyes, a wide smile, slightly blushed cheeks, and wearing a striped party hat. In the upper background, the phrase 'HAPPY BIRTHDAY' is written in large, colorful, three-dimensional letters (orange, green, blue, yellow). The lower third of the image displays two blue text banners. The first reads 'TANGER BAY DENTAL CENTER' in white uppercase letters, and the second, in smaller white text, reads 'vous souhaite un bon anniversaire'. The background is a softly-focused dental clinic scene with a dental chair, light, white countertop, and a cup or container. The logo of Tanger Bay Dental Center, which stylizes a tooth outline with the name below, is in the top right corner.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\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    \"per\n\nUser message context: Salut  BELGACHA ASMAE,\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-13T09:23:58.098942", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3777/download", "media_mime_type": "image/jpeg"}, {"id": 14723, "message_id": "ACD54D1AD5BFA1C668E8AC2B3C71A600", "sender": "user", "message_type": "text", "content": "Merci beaucoup 😊", "created_at": "2026-04-13T10:11:26.517304", "media_url": null, "media_mime_type": null}, {"id": 14724, "message_id": "bot_ACD54D1AD5BFA1C668E8AC2B3C71A600_7930", "sender": "bot", "message_type": "text", "content": "Avec plaisir Asmae 😊 Toute l’équipe du Centre Dentaire Tanger Bay vous souhaite encore un joyeux anniversaire et plein de belles choses ! Si vous souhaitez profiter de l’offre ou si vous avez la moindre question, on est là pour vous accompagner.\n\nN’hésitez pas à nous dire si vous voulez prendre rendez-vous ou si vous avez besoin d’informations supplémentaires. Passez une excellente journée !", "created_at": "2026-04-13T10:11:47.507261", "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 1049 in training_review_items