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": 9278, "message_id": "3EB09E87C5EBB664554AA0", "sender": "bot", "message_type": "image", "content": " ", "created_at": "2026-03-31T10:07:08.355835", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2137/download", "media_mime_type": "image/jpeg"}, {"id": 9279, "message_id": "3EB0EBD381C23C5535EA01", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is an intraoral photo showing the upper and lower anterior and posterior teeth in occlusion. The patient's lips are retracted. The upper central and lateral incisors appear to have crowns or veneers, which are lighter in color than the adjacent teeth. There are visible metallic dental restorations on the upper right and upper left posterior teeth, likely crowns or large amalgam/composite restorations. There are brownish-yellow discolorations and possible calculus deposits along the gingival margins of several lower anterior and some posterior teeth. The gingival tissues appear erythematous, particularly at the lower anterior region, with some mild swelling noted. Generalized mild gum recession is present, and the teeth alignment shows mild crowding of the lower anterior teeth. The lower anterior gingiva shows localized redness and possible irritation. The overall teeth color on natural teeth is more yellowish compared to the prosthetic crowns.\"\n  ,\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Central and lateral incisors have crowns or veneers with lighter color and smooth surface\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"", "created_at": "2026-03-31T10:07:22.280151", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2138/download", "media_mime_type": "image/jpeg"}, {"id": 9280, "message_id": "3EB0291F01D062E91AFC38", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is a high-quality intraoral clinical photograph showing both upper and lower anterior and premolar teeth in occlusion, retracted with cheek retractors. The gums, tooth crowns, and some soft tissue are visible. There are visible yellow-brownish deposits at the gumlines of multiple teeth, especially on lower anterior and upper lateral/ canine regions. The upper left and right posterior teeth show visible metallic restorations. Gum tissues show mild redness at some locations, particularly around the lower anterior teeth. There are no obvious soft tissue lesions or large cavities visible, but there is some crowding in the lower anterior teeth and mild marginal gingival swelling. The photograph appears to be taken with clinical lighting and focus, with good detail of tooth color, surface texture, and tissue.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Central and lateral incisors and canines present, mild staining near gumlines, overall intact crowns, no fractures seen.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"All six anterior teeth present, obvious yellow", "created_at": "2026-03-31T10:07:38.713695", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2139/download", "media_mime_type": "image/jpeg"}, {"id": 10926, "message_id": "A53F783439B84003AA82D0AB56441CCE", "sender": "bot", "message_type": "text", "content": "Salam alikom", "created_at": "2026-04-02T16:42:40.936188", "media_url": null, "media_mime_type": null}, {"id": 10927, "message_id": "A503D388B5C2F992060E5BF1D17CD8CA", "sender": "bot", "message_type": "text", "content": "Cava j'espère que vous allez bien", "created_at": "2026-04-02T16:43:06.123160", "media_url": null, "media_mime_type": null}, {"id": 10928, "message_id": "A5AFA775B0F62946D75C55E0653887E7", "sender": "bot", "message_type": "text", "content": "?", "created_at": "2026-04-02T16:43:25.627332", "media_url": null, "media_mime_type": null}, {"id": 10986, "message_id": "3EB0D3E60C6730F7C6A8FF", "sender": "bot", "message_type": "document", "content": "_radios_Traore Samory_20260402_18094366.pdf", "created_at": "2026-04-02T17:10:26.730946", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2686/download", "media_mime_type": "application/pdf"}, {"id": 10987, "message_id": "3EB0B1F62A1DEE0799A35C", "sender": "bot", "message_type": "document", "content": "_radios_Traore Khalidou_20260402_18101427.pdf", "created_at": "2026-04-02T17:10:57.590383", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2687/download", "media_mime_type": "application/pdf"}, {"id": 16218, "message_id": "3EB0579DC2D80AEF05C1C6", "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 promotional or informational graphic for a dental clinic. It features a 3D cartoon tooth character with a smiling face, giving a thumbs up and holding a calendar with a green checkmark. The background appears to be an out-of-focus dental clinic room, visible by the presence of dental chair equipment. The top of the image displays the logo and name 'Tanger Bay Dental Center.' There is a blue gradient background with prominent white and blue text stating 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and 'CHEZ TANGER BAY DENTAL CENTER.' The overall aesthetic is clean and professional, designed to reassure the recipient about their appointment confirmation.\",\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    \"TANGER BAY DENTAL CENTER\",\n\nUser message context: Salut *TRAORÉ Mamary*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 16 avril 2026*\r\n🕘 Heure : *17:30*\r\n📍 Adresse : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)\r\n📞 Pour toute question : 06 60 02 22 63\r\n✅ Merci de nous confirmer votre présence en répondant « OUI » à ce message\r\n\r\n⚠️ IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement considéré comme annulé automatiquement. \r\nMerci de votre compréhension.", "created_at": "2026-04-15T15:06:46.425133", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4270/download", "media_mime_type": "image/jpeg"}, {"id": 16219, "message_id": "3EB0DAA008ABDDE8E166D8", "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 promotional or informational graphic for Tanger Bay Dental Center. It features a large, animated cartoon tooth character with facial features, holding a spiral notepad with a green checkmark and giving a thumbs-up gesture. In the background, there is a blurred dental office setting, including a dental chair and equipment, giving a characteristic clinical ambiance. The upper part of the image has the Tanger Bay Dental Center logo, which is a stylized tooth outline, as well as the name of the clinic. Two text banners in blue state 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' (your appointment is confirmed) with a checkmark symbol and 'CHEZ TANGER BAY DENTAL CENTER.' No real teeth, people, or patients are visible in the image.\",\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  \"text\n\nUser message context: Salut *Traore Samory*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 16 avril 2026*\r\n🕘 Heure : *17:30*\r\n📍 Adresse : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)\r\n📞 Pour toute question : 06 60 02 22 63\r\n✅ Merci de nous confirmer votre présence en répondant « OUI » à ce message\r\n\r\n⚠️ IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement considéré comme annulé automatiquement. \r\nMerci de votre compréhension.", "created_at": "2026-04-15T15:07:14.087918", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4271/download", "media_mime_type": "image/jpeg"}, {"id": 16225, "message_id": "ACB517EA408F11987BED451997017D3F", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-04-15T15:12:46.506791", "media_url": null, "media_mime_type": null}, {"id": 16226, "message_id": "bot_ACB517EA408F11987BED451997017D3F_9032", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre confirmation ! Votre rendez-vous pour vous et vos enfants est bien noté pour jeudi 16 avril à 17h30 chez Tanger Bay Dental Center.\n\nN’hésitez pas à nous contacter si vous avez la moindre question ou besoin de modifier quoi que ce soit. À très bientôt !", "created_at": "2026-04-15T15:13:29.532193", "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 1206 in training_review_items