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": 39668, "message_id": "3EB08E23B1B3F8FB9940F8", "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 view of the lower dental arch with the patient's mouth wide open and cheeks retracted using plastic retractors. Both lower left and lower right posterior regions are clearly visible. The anterior lower teeth (incisors and canines) appear aligned and are of similar shade. There are multiple teeth with white restorations or crowns, and the two most posterior teeth on each side appear to have large, brownish restorations, possibly old composite or amalgam fillings. The visible gum tissue is pink and does not demonstrate obvious swelling or redness. The oral mucosa (floor of mouth) is visible and appears moist and healthy, without notable lesions.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"lower_right_posterior\",\n        \"observation\": \"Most posterior molar exhibits a large brown restoration and moderate wear; adjacent tooth shows a white restoration/crown.\",\n        \"severity_signal\": \"moderate\"\n      },\n      {\n        \"location\": \"lower_left_posterior\",\n        \"observation\": \"Most posterior molar exhibits a large brown restoration and moderate wear; adjacent tooth shows a white restoration/crown.\",\n        \"severity_signal", "created_at": "2026-06-06T08:01:40.054630", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11042/download", "media_mime_type": "image/jpeg"}, {"id": 39669, "message_id": "3EB06970FB4810FDA23FE9", "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\": \"The image shows an intraoral view of the upper and lower arches with the mouth open, using cheek retractors to allow full visibility of the teeth and gums. The teeth appear uniformly white, bright, and have a uniform shape and contour indicating the likely presence of prosthetic crowns or veneers on all visible teeth. The gums are visible, with a healthy pink coloration in most areas, but there is some mild redness and recession, especially in the lower anterior region. There is calculus or staining visible in the lower right and left posterior regions near the gumline. Alignment appears good and symmetrical; no obvious crowding or spacing is observed. The occlusion shows no obvious trauma or irregular contact. There are no visible soft tissue lesions or swelling. No orthodontic appliances are present.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"White, uniform crowns/veneers, smooth surfaces, appear prosthetic\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"White, uniform crowns/veneers, smooth surfaces, appear prosthetic\",\n        \"severity", "created_at": "2026-06-06T08:01:58.149343", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11043/download", "media_mime_type": "image/jpeg"}, {"id": 39670, "message_id": "3EB06450E9519D1892379E", "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 high-quality clinical intraoral photo showing both upper and lower dental arches in occlusion. The view includes all anterior and premolar teeth, with some posterior teeth partially visible. The teeth are uniformly white, symmetrical, and show a smooth surface and rounded contours, suggesting the presence of full dental restorations (likely crowns or veneers) on most or all teeth. The gum tissue is pink with a stippled appearance, though mild redness and swelling are seen in certain areas, predominantly the lower anterior region. There is a thin line of yellowish-brown discoloration at the gum line of some lower anterior teeth, possibly indicative of plaque or calculus accumulation.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Full white crowns or veneers visible; smooth surface, symmetrical, no apparent chips or fractures.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Full white crowns or veneers visible; slight yellowish discoloration at gum line; otherwise smooth and intact.\",\n        \"severity_signal\": \"mild\"\n      },\n      {\n        \"location", "created_at": "2026-06-06T08:02:11.997208", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11044/download", "media_mime_type": "image/jpeg"}, {"id": 39685, "message_id": "3A0C1F5330D41319C46F", "sender": "user", "message_type": "voice", "content": "[Voice message] بالتأكيد، إليك تفريغ المقطع الصوتي باللهجة المغربية:\n\n\"السلام عليكم أحبيبة، صباح الخير، كيف صبحتِ مزيانة بخير؟ تقدري تبدلي لي الرونديفو (rendez-vous) ديال وفاء الخمليشي حيت حتى هي عندها الطبيب نهار... نهار لثنين عندها الطبيب مع الجوج، مغادركش ترجع عندكم. تخليه ليها تال الثلاثة.\"", "created_at": "2026-06-06T08:29:34.070739", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11055/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39688, "message_id": "A589E13CF7318E17D139F6DBC204DC5B", "sender": "bot", "message_type": "voice", "content": "[Voice message] لاباس الحمد لله، نتينا؟ كيف نتينا؟ مزيانة؟ كلشي بخير؟ أجي نقول ليك، نبدل le rendez-vous نهار التلاتة مع l'apa؟ ديك ساعة رد عليا.", "created_at": "2026-06-06T08:59:28.297533", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11056/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39708, "message_id": "3AD8927BE9C2BA7A9D10", "sender": "user", "message_type": "voice", "content": "[Voice message] إليك تفريغ المقطع الصوتي باللهجة المغربية:\n\n\"الأول ومن أحسن نهار د الثلاثاء، حيتاش غادة الطبيبة د النسا، عندها تحاليل وكاع داك التخربيق خاصها تديهم ليها، وعاد تعطل معاها.\"", "created_at": "2026-06-06T09:23:01.886659", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11061/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39715, "message_id": "A5FEAC7FF62077B7900D427708096F20", "sender": "bot", "message_type": "text", "content": "Safi wakha", "created_at": "2026-06-06T09:27:50.905515", "media_url": null, "media_mime_type": null}, {"id": 39717, "message_id": "3EB06BE922F098E80BF046", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL KHAMLICHI Oufae*\r\nVous avez Rendez Vous avec *Dr. RIAD GUENNOUNI* le *mardi 09 juin 2026* à *14: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*EL KHAMLICHI*\r\nلديكم موعد مع ** يوم *الثلاثاء 9 يونيو 2026* على الساعة *14:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-06T09:28:56.426106", "media_url": null, "media_mime_type": null}, {"id": 39743, "message_id": "3A22168BA9DA8FD9FAA2", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-06-06T09:49:01.751986", "media_url": null, "media_mime_type": null}, {"id": 39745, "message_id": "3EB05946C34DFFF8095BED", "sender": "bot", "message_type": "text", "content": "mrhba", "created_at": "2026-06-06T09:51:38.782816", "media_url": null, "media_mime_type": null}, {"id": 40422, "message_id": "3A5F4C2C2C63E233DD6D", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nالسلام عليكم أختي، كيف نتينا؟ مزيانة؟ بخير؟ شوفي هاهما عطاوني السكانير، هاهما غايصيفطوهم لك دابا، إن شاء الله يا ربي، شوفي لنا السكانير...\n\n**Latin Script (Phonetic):**\nSalam oulaykum khti, kif ntina? Mezyana? Bikher? Choufi ha homa 3tawni scanner, ha homa ghaysiftohom lek daba, incha'Allah ya rabbi, choufi lna scanner...\n\n**Translation (for context):**\n\"Peace be upon you my sister, how are you? Are you good? Fine? Look, they gave me the scans, they are going to send them to you now, God willing. Look at the scans for us...\"", "created_at": "2026-06-08T14:20:44.159357", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11216/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40426, "message_id": "bot_3A5F4C2C2C63E233DD6D_6075", "sender": "bot", "message_type": "text", "content": "فهمتكوم، ولكن أنا غير مجرد مساعد آلي وماعنديش دراية بلي واقع برا هاد المحادثة. بعثنا طلبكوم للفريق وغادي يتواصلوا بيكوم إن شاء الله 🙏🏻", "created_at": "2026-06-08T14:22:09.216531", "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 3284 in training_review_items