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": 15894, "message_id": "A5AAC7DA05DF78AC761D4D0F29E72947", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic script:**\nالسلام عليكم، صّباحتي مزيان؟ وعا غير سمح لي على داك الغراض ديال لبارح...\n\n**Latin script (Darija):**\n\"Salam-u-alaykum, sbahti mzyan? Wa gha ghir sma7 liya 3la dak l-gharad dyal l-bare7...\"\n\n**Translation (for context):**\n\"Peace be upon you, did you wake up well (good morning)? And please just forgive me for that matter (errand) of yesterday...\"", "created_at": "2026-04-15T08:20:32.239356", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4150/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15895, "message_id": "3A35EBA6FCB15F977E75", "sender": "user", "message_type": "text", "content": "Aaah", "created_at": "2026-04-15T08:20:50.099346", "media_url": null, "media_mime_type": null}, {"id": 15898, "message_id": "3A783C886E86879658F2", "sender": "user", "message_type": "text", "content": "Normalement mardi prochain à 10h30", "created_at": "2026-04-15T08:21:27.929902", "media_url": null, "media_mime_type": null}, {"id": 15900, "message_id": "A5A6ABBCC835C8A2CEE1B8E18719F4F5", "sender": "bot", "message_type": "voice", "content": "[Voice message] The transcription of the audio is as follows:\n\n**Latin Script:**\n\"Alexi, ghir le rendez-vous d'barrah ghadi tfacture-ih lyoma, bghit ghir...\"\n\n**Arabic Script:**\n\"أليكسي، غير لو رونديفو د البارح غادي تفاكتوريه اليوم، بغيت غير...\"\n\n**Language Breakdown:**\n*   **Alexi:** Name (Alexis).\n*   **Ghir:** Just / Only (Darija).\n*   **Le rendez-vous:** The appointment (French).\n*   **D’barrah:** Of yesterday (Darija).\n*   **Ghadi:** Will / Future marker (Darija).\n*   **Tfacture-ih:** Bill it (French verb *facturer* with Darija conjugation).\n*   **Lyoma:** Today (Darija).\n*   **Bghit ghir:** I just wanted... (Darija).", "created_at": "2026-04-15T08:24:21.185442", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4151/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16371, "message_id": "3EB0B37D0B236B9EEB536A", "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\": \"Intraoral clinical photo showing the mandibular (lower) arch. A dental mirror is used to provide a clear view of the lower anterior and posterior teeth. The image shows a near-complete lower arch with good lighting and focus. The gingiva appears visible around the teeth. There is some visible buildup on the lower anterior teeth along the lingual surfaces, as well as observable wear, staining, and possible irregularities on certain posterior teeth. Dental retractors are used to keep lips and cheeks away, and the patient is wearing a blue bib.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Teeth generally intact, with visible yellowish calculus or staining on the lingual surfaces. Mild crowding is present.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"lower_left\",\n        \"observation\": \"Posterior teeth show some occlusal wear, with possible presence of composite restorations or moderate staining/discoloration, especially on the first and second premolars.\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"lower", "created_at": "2026-04-15T16:44:15.051939", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4351/download", "media_mime_type": "image/jpeg"}, {"id": 16372, "message_id": "3EB0FBBD58E33BE6E87AF6", "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 mandibular (lower) arch viewed from above. The image is sharply focused and well-lit, utilizing a cheek and tongue retractor and dental mirror. All lower teeth from molars to incisors on both sides are visible. The tongue is partially visible at the bottom of the field. The mucosa appears moist and healthy with no obvious lesions. Some posterior teeth, particularly on the lower left, show discoloration and dark material suggestive of possible decay or large restoration failures. A few teeth have filling material. The gum tissue visible is generally pink and not swollen. There is evidence of plaque/calculus on some teeth.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"lower_left molars\",\n        \"observation\": \"Discoloration and brownish areas, possible caries or stained fissures; filling material present on first molar. The distal molar shows extended areas of brown/yellow material, possibly caries or large restoration defect.\",\n        \"severity_signal\": \"significant\"\n      },\n      {\n        \"location\": \"lower_right molars\",\n        \"observation\": \"Filling material visible on", "created_at": "2026-04-15T16:44:45.688520", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4352/download", "media_mime_type": "image/jpeg"}, {"id": 16373, "message_id": "3EB007016EA90F2F647F89", "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 clear intraoral clinical photograph showing the lower dental arch and palate. The mouth is open with cheek retractors in place, providing a direct view of the mandibular teeth, gums, and part of the palate. Most teeth in the lower arch are visible, and both left and right posterior quadrants are observable. There are multiple dental restorations on the lower right quadrant, including what appears to be a metallic (amalgam) filling. The gum tissue appears mostly healthy and pink, with no major visible swelling or lesions. There is minor yellowish staining or wear on the incisal edges of the lower anterior teeth.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"lower_left\",\n        \"observation\": \"Teeth appear to be intact with multiple posterior teeth present. Occlusal surfaces are visible and appear to have natural anatomy.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"lower_right\",\n        \"observation\": \"Posterior teeth present including premolars and molars. One molar has a metallic (amalgam) restoration. Other teeth show natural morphology with no obvious large cavities or", "created_at": "2026-04-15T16:44:55.870840", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4353/download", "media_mime_type": "image/jpeg"}, {"id": 16374, "message_id": "3EB049EE4C63A98F658A59", "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\": \"Close-up intraoral image of upper and lower anterior and posterior teeth, with a cheek retractor in place. The upper and lower teeth and gums are clearly visible. The teeth show some degree of yellowish discoloration. Several teeth (mainly lower anteriors) have visible brown deposits near the gumline, likely calculus. The gums appear generally pink but there is evidence of localized redness, particularly around the lower anterior teeth. Mild gum recession is apparent on the lower front teeth. Some wear is visible on the incisal edges of the upper front teeth, and the lower front teeth have uneven margins. A dark restoration or carious lesion can be seen on a lower right molar. No dental appliances or braces are visible. No patient information is visible in the image.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Incisal edges of central incisors show enamel wear and minor chipping. Surfaces show diffuse yellowish discoloration and some white opacity.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Teeth with brownish", "created_at": "2026-04-15T16:45:08.105858", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4354/download", "media_mime_type": "image/jpeg"}, {"id": 16375, "message_id": "3EB04586D16CD759138D9A", "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 a close-up intraoral view of the upper and lower anterior and premolar teeth. The lips are retracted using cheek retractors, exposing the gingiva and teeth clearly. Both upper and lower arches are visible from first premolar to first premolar (some molars partially visible). Teeth show a yellowish hue, with noticeable brownish discoloration, particularly near the gum line and interproximal areas. There is visible accumulation of calculus and/or staining, especially on the lower anterior and upper lateral/canine areas. The gum tissue appears generally pink but shows mild swelling and irregularity along the marginal gingiva. There is visible crowding of the lower anteriors and a slight misalignment between upper and lower dental midlines. Some existing dental restorations (possible composite or amalgam) can be seen on upper right posterior teeth.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Yellowish color, mild wear on incisal edges, mild brown staining interproximally\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation", "created_at": "2026-04-15T16:45:26.324659", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4355/download", "media_mime_type": "image/jpeg"}, {"id": 16376, "message_id": "3ADC68E8868E7561FE98", "sender": "user", "message_type": "text", "content": "👍👍😔😔", "created_at": "2026-04-15T16:48:50.245469", "media_url": null, "media_mime_type": null}, {"id": 16377, "message_id": "3A2F81F8400E9E6A1B34", "sender": "user", "message_type": "text", "content": "Merci beaucoup", "created_at": "2026-04-15T16:48:55.720490", "media_url": null, "media_mime_type": null}, {"id": 16378, "message_id": "bot_3A2F81F8400E9E6A1B34_9432", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻 إذا احتاجيتو شي حاجة أخرى ولا استفسار، حنا رهن الإشارة ديالكوم.", "created_at": "2026-04-15T16:50:12.174547", "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 1218 in training_review_items