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": 13368, "message_id": "3EB0BDB6C7A82ADA43B2B2", "sender": "bot", "message_type": "image", "content": " ", "created_at": "2026-04-09T18:19:37.801904", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3424/download", "media_mime_type": "image/jpeg"}, {"id": 13374, "message_id": "3EB0B175BDB1D9716BDF67", "sender": "bot", "message_type": "image", "content": " ", "created_at": "2026-04-09T18:20:06.265259", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3425/download", "media_mime_type": "image/jpeg"}, {"id": 13376, "message_id": "3EB0FB329F6D2A1694A305", "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\": \"This is an intraoral photo showing the mandibular (lower jaw) arch. The photo displays the occlusal (top) surfaces of the lower teeth, as well as the palate and the supporting gum tissue. The right side of the image (clinically the patient's left) shows several molar teeth that are severely decayed with large areas of crown destruction and visible loss of tooth structure. There is a mix of colors including brown, yellow, and black associated with decay and necrotic debris. The gums in the area appear red and inflamed, possibly with loss of normal contour. The left side of the image (clinically the patient's right) shows posterior teeth with multiple darkly stained occlusal grooves, possible old restorations or deep carious lesions. The anterior teeth appear relatively intact. No text, labels, or identifiers are visible.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"lower_left_first_and_second_molars\",\n        \"observation\": \"Severe crown destruction due to caries, brown/yellow/black necrotic debris, gross loss of tooth structure, possibly pulp exposure.\",\n        \"severity_signal\": \"sign", "created_at": "2026-04-09T18:20:30.531097", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3426/download", "media_mime_type": "image/jpeg"}, {"id": 13381, "message_id": "3EB0CD456C77EE814095FB", "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\": \"This is an intraoral clinical photograph showing the upper and lower anterior and posterior teeth with cheek retractors in place. The image is well-focused and high resolution. The photo reveals partial dentition with most teeth visible from premolar to premolar, and some posterior teeth partially visible. Teeth color varies with noticeable yellowing and some darker staining, particularly on the lower and posterior teeth. There is moderate crowding in the lower anterior teeth and some crowding in the upper anterior as well. The gingival tissues are pink in most areas but with a slightly erythematous (reddened) appearance in the upper anterior region. There is visible plaque and calculus, especially along the gumline and on the lower anterior teeth. Some teeth show signs of wear and possibly chipping on incisal edges. No visible large carious lesions, but areas of possible enamel opacity and staining. No visible metal or ceramic restorations.\",\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, off-white with some yellow discoloration and irregular alignment. Mild incisal edge wear.\",\n        \"severity_signal", "created_at": "2026-04-09T18:21:00.067390", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3427/download", "media_mime_type": "image/jpeg"}, {"id": 13382, "message_id": "3EB04AF43CED317E7E5B67", "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\": \"This is a high-resolution intraoral clinical photograph showing the right lateral view of the patient's upper and lower anterior and premolar teeth, gums, and surrounding mucosa. A cheek retractor is in place, exposing the dental and gingival tissues clearly. The teeth show noticeable yellow-brown staining, especially on the cervical and interproximal regions. Alignment of the teeth is visibly irregular, with crowding and overlapping of both upper and lower incisors and canines. The gum tissue appears generally pink but presents with mild localized erythema, especially in the upper canine area. No obvious open caries or fractures are seen. There is some plaque or calculus deposit visible primarily along the gingival margins. No soft tissue lesions, swelling, or ulcerations are observed on the visible gum tissue. There are no metal restorations, crowns, or visible prosthetic appliances. Lips, facial hair, and parts of the cheek are visible at the periphery.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_right\",\n        \"observation\": \"Teeth are present and show moderate staining on the surfaces, with noticeable crowding and overlapping of canine and lateral incisors", "created_at": "2026-04-09T18:21:25.022142", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3428/download", "media_mime_type": "image/jpeg"}, {"id": 13385, "message_id": "3EB0A18E86C97942E4BC9A", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ZEGGAF Redouane*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 16 avril 2026* à *10:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الخميس 16 أبريل 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-09T18:27:05.039954", "media_url": null, "media_mime_type": null}, {"id": 16205, "message_id": "3EB088B1184D1AB3D60F39", "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 features a digitally illustrated smiling tooth character with cartoon facial features (eyes, mouth, eyebrows) giving a thumbs-up gesture. The tooth is holding a notepad featuring a large green check mark. In the background is a blurred dental office setting with a dental chair, counter, and window. At the top of the image is the Tanger Bay Dental Center logo, which is a white tooth outline with the text 'TANGER BAY DENTAL CENTER' below. There are two blue boxes with white French text: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' (with a check mark emoji) and 'CHEZ TANGER BAY DENTAL CENTER.' The overall tone is bright and inviting, with a blue and white color palette.\",\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_visible\": [\n    \"\n\nUser message context: Salut *ZEGGAF Redouane*👋\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 : *10:00*\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:02:54.388910", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4259/download", "media_mime_type": "image/jpeg"}, {"id": 16241, "message_id": "3EB0468A6B1ADB7A6C40E9", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ZEGGAF Redouane*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 16 avril 2026* à *10:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الخميس 16 أبريل 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-15T15:25:34.049867", "media_url": null, "media_mime_type": null}, {"id": 16245, "message_id": "3A52451A5D2F5C3820E7", "sender": "user", "message_type": "text", "content": "<reply_to>Bonjour \r\n*ZEGGAF Redouane*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 16 avril 2026* à *10:00* .\r\nEn cas d'empêchement, veuillez ...</reply_to> Ok inshaallah", "created_at": "2026-04-15T15:27:57.876810", "media_url": null, "media_mime_type": null}, {"id": 16246, "message_id": "bot_3A52451A5D2F5C3820E7_6573", "sender": "bot", "message_type": "text", "content": "Merci pour votre confirmation ZEGGAF Redouane 😊 Votre rendez-vous avec Dr Oussama Mouallem est bien noté pour jeudi 16 avril à 10:00.\n\nSi vous avez besoin de modifier ou d’annuler, n’hésitez pas à nous contacter. À très bientôt chez Tanger Bay Dental Center !", "created_at": "2026-04-15T15:28:51.177889", "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 1208 in training_review_items