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": 15916, "message_id": "A591BB875E54746B8959C8F2264B0ADB", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija and French:\n\n\"السلام عليكم سي عبد الحق، صباح الخير، كي صبحتي مزيان؟ بيخير؟ سي عبد الحق عندك rendez-vous اليوم معانا مع العشرة، صافي ديك ساعة عيط لي إلا ما عرفتيش localisation.\"", "created_at": "2026-04-15T08:35:27.760212", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4153/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15917, "message_id": "AC2C4EBC850BFF2196317C0B1C22EC28", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure, here is the transcription of the audio:\n\n**Arabic Script:**\n\"لالة صباح الخير، سي محمد، صافا بيخير؟ أنا لقيتيني جاي لعندكم إن شاء الله، أنا قريب لعندكم. واحد 5 د الدقائق ولا 7 د الدقائق نكون عندكم إن شاء الله.\"\n\n**Latin Script (Darija):**\n\"Lalla sbah l-khir, si Mohammed, ça va bikhir? Ana lqitini jay l-3ndkom nchallah, ana qrib l-3ndkom. Wahed 5 d-dqayeq wla 7 d-dqayeq nkoun 3ndkom nchallah.\"", "created_at": "2026-04-15T08:36:06.955869", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4154/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16266, "message_id": "3EB0DF14C029EB85C5D656", "sender": "bot", "message_type": "image", "content": " ", "created_at": "2026-04-15T15:42:20.734492", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4286/download", "media_mime_type": "image/jpeg"}, {"id": 16268, "message_id": "3EB0729F58A46A30CDD895", "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 shows an intraoral occlusal view of the lower arch. The tongue and lower teeth are clearly visible, retracted by mouth mirrors for unobstructed view. Most of the visible molars and premolars have significant dark brown to black discoloration involving occlusal, buccal, and lingual surfaces. The crowns of several teeth appear extensively damaged by carious lesions. Some molars have deep cavitations and possible remnants of food debris or necrotic tissue. The gingival tissue appears moist and pink but may have minor irritation close to carious lesions. The rest of the oral mucosa looks unremarkable. No dental restorations (e.g. fillings, crowns) are visible. No text is present.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"lower_right_molars\",\n        \"observation\": \"Extensive dark brown/black carious lesions with deep cavitations and surface breakdown.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"lower_left_molars\",\n        \"observation\": \"Extensive dark brown/black decay present, large enamel and dentin", "created_at": "2026-04-15T15:42:41.429066", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4287/download", "media_mime_type": "image/jpeg"}, {"id": 16269, "message_id": "3EB0F180D6780241FB33B7", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"dental_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is an intraoral photo showing the upper dental arch and palate. The teeth are clearly visible, with significant brown discoloration, cavitated lesions, and areas of darkened decay on multiple molars and premolars on both sides. There is extensive loss of tooth structure especially on the left and right posterior teeth (molars and premolars). The anterior teeth (front upper teeth) also show brown staining, particularly along the edges near the gumline. The gingival tissue appears mostly pink with mild redness adjacent to the decayed areas. Soft tissue of the hard palate appears normal in color, with no visible lesions or swelling.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_left posterior (molars & premolars)\",\n        \"observation\": \"Multiple teeth exhibit large cavitated carious lesions with extensive brown-black decay. Structural loss is evident.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"upper_right posterior (molars & premolars)\",\n        \"observation\": \"Large carious lesions with dark brown/black decay present on most teeth. Substantial loss of tooth structure observed", "created_at": "2026-04-15T15:43:03.678910", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4288/download", "media_mime_type": "image/jpeg"}, {"id": 16270, "message_id": "3EB0EC72F94DC6D0FA8C07", "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-quality intraoral clinical photo showing both the upper and lower anterior and posterior teeth. The mouth is being held open with retractors, allowing a clear view of the teeth and surrounding gum tissue. Nearly all teeth are heavily stained with dark brown to black deposits, particularly near the gumline and on the occlusal and incisal surfaces. The staining is widespread, affecting both arches, and appears to be consistent with external deposits or heavy tobacco use. There appears to be plaque and potentially calculus accumulation, especially near the gingival margin and on the lingual and proximal surfaces. The teeth have irregular surfaces, though the extent of decay versus staining is difficult to confirm from the image alone. The gingiva appears erythematous with some swelling, particularly in the lower anterior area.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Widespread, dark brown staining and irregular discoloration on all visible surfaces. Incisal edges show staining and possible attrition. Some possible decalcification or erosion.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"front_lower\",", "created_at": "2026-04-15T15:43:26.117696", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4289/download", "media_mime_type": "image/jpeg"}, {"id": 16271, "message_id": "3EB0609333AF218598BFDA", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"dental_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a close-up intraoral clinical photograph of the anterior teeth on both upper and lower jaws. The photo is taken with cheek retractors in place, providing a clear view of teeth and marginal gum tissues. There is extensive, dark brown to black staining and deposits on both upper and lower front teeth. The stains are both on the surfaces and in interproximal spaces. Some incisal edges show visible chipping and wear. The gingiva appears pink but may exhibit mild inflammation adjacent to some teeth. Plaque and/or calculus deposits are prominent, especially along the gum line and between the teeth. Enamel surfaces display areas of translucency and erosion. Most teeth present are heavily stained, and the pattern suggests chronic exposure to staining agents.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Significant brown/black staining and surface deposits, multiple teeth with chipping and wear at incisal edges\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Severe brown/black staining and surface build-up, several teeth with signs of", "created_at": "2026-04-15T15:43:40.362162", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4290/download", "media_mime_type": "image/jpeg"}, {"id": 16576, "message_id": "AC1801DE6D08FDD7F202113412C2B531", "sender": "user", "message_type": "text", "content": "Bonjour, merci de m'organise un rendez vous samedi 18.04.2026", "created_at": "2026-04-16T09:16:41.694019", "media_url": null, "media_mime_type": null}, {"id": 16577, "message_id": "AC52C69D83CFA9BCA03669D1A530A87E", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-04-16T09:16:42.145227", "media_url": null, "media_mime_type": null}, {"id": 16579, "message_id": "bot_AC52C69D83CFA9BCA03669D1A530A87E_8426", "sender": "bot", "message_type": "text", "content": "Bonjour Twijar Abdelhak 😊\n\nPour organiser votre rendez-vous le samedi 18 avril 2026, pouvez-vous me préciser le motif de votre visite (par exemple : détartrage, contrôle, douleur, etc.) ? Merci de me le confirmer pour que l’équipe puisse valider votre demande rapidement.\n\nNote : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-04-16T09:17:38.308613", "media_url": null, "media_mime_type": null}, {"id": 16581, "message_id": "AC653A26FD80658C2A57E0D2E0D63FD6", "sender": "user", "message_type": "text", "content": "Motif détartrage", "created_at": "2026-04-16T09:18:54.452297", "media_url": null, "media_mime_type": null}, {"id": 16585, "message_id": "bot_AC653A26FD80658C2A57E0D2E0D63FD6_7967", "sender": "bot", "message_type": "text", "content": "Merci Twijar Abdelhak ! Votre demande pour un rendez-vous de détartrage le samedi 18 avril 2026 a bien été transmise à l’équipe 😊\n\nNote : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-04-16T09:19:07.972389", "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 1247 in training_review_items