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": 5512, "message_id": "bot_AC2A611FABE4E19F76690855DC7FF006_7021", "sender": "bot", "message_type": "text", "content": "سمعتك 😊 غادي نبلغ الفريق باش ينسقوا الموعد نهار الثلاثاء بعد رمضان إن شاء الله. غادي يتاصلوا بيكوم باش يأكدو الموعد. إذا كان عندك شي حاجة أخرى نقدر نعاونك بها، حنا هنا رهن الإشارة ديالك.", "created_at": "2026-03-16T20:19:31.875293", "media_url": null, "media_mime_type": null}, {"id": 5513, "message_id": "A58A5BA5C98C7EA3C83157BBB3A65B8F", "sender": "bot", "message_type": "text", "content": "<reply_to>[Audio Message]</reply_to> Sf wakha", "created_at": "2026-03-16T20:19:40.049765", "media_url": null, "media_mime_type": null}, {"id": 5514, "message_id": "A56207B9432D1B2F3656A97FB2B9D811", "sender": "bot", "message_type": "voice", "content": "[Voice message] صافي واخا شوف الروبو هذا انتقادشي تجاوبني.", "created_at": "2026-03-16T20:19:46.729007", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1019/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 5515, "message_id": "ACF8DAFF2558BD3C8504399F9A729F68", "sender": "user", "message_type": "voice", "content": "[Voice message] صاف خليا نهار ثلاث نشوف بلاصة خاوية نقدر نجي معاه.", "created_at": "2026-03-16T20:20:14.744299", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1020/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 5517, "message_id": "AC076203271143768ADC52F1EB2DA77C", "sender": "user", "message_type": "voice", "content": "[Voice message] لكن أنا ما كاتقراو لي رسائلي.", "created_at": "2026-03-16T20:20:30.978267", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1021/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 5518, "message_id": "AC9EB5A91A5C5E3AB1552BC6AC52457E", "sender": "user", "message_type": "voice", "content": "[Voice message] نهار تلات واش مسلكاك انتي مع الرابعة باش نقدر نجي معاه.", "created_at": "2026-03-16T20:23:30.502887", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1022/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 5519, "message_id": "bot_AC9EB5A91A5C5E3AB1552BC6AC52457E_907", "sender": "bot", "message_type": "text", "content": "سمعتك 😊 غادي نبلغ الفريق باش ينسقوا الموعد نهار الثلاثاء مع الرابعة بعد رمضان إن شاء الله. غادي يتاصلوا بيكوم باش يأكدو الموعد. إذا كان عندك شي حاجة أخرى نقدر نعاونك بها، حنا هنا رهن الإشارة ديالك.", "created_at": "2026-03-16T20:23:48.077749", "media_url": null, "media_mime_type": null}, {"id": 5522, "message_id": "A506542114F61D4B28A99C2B44009908", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-16T20:31:27.090374", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1023/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 5523, "message_id": "A5D760FC0FC0BB84D00F506CEF6D6A7D", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-16T20:31:34.798205", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1024/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 5727, "message_id": "3EB0529046BCEB975614F4", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*Mugia Giovanni battista*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mardi 24 mars 2026* à *15: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لديكم موعد مع ** يوم *الثلاثاء 24 مارس 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-17T12:17:49.990421", "media_url": null, "media_mime_type": null}, {"id": 7592, "message_id": "AC2FA5F86C97A14610139E40E95C2ACA", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"shadow\"]\n  },\n  \"description\": \"The image shows a dental invoice from Tanger Bay Dental Center. The document includes the clinic's logo and name at the top. The text is primarily in French. There is a list detailing two dental procedures involving 'Couronne ceramo-ceramique' on teeth numbers 36 and 37 scheduled for the date 04/03/2026. The client's name is Mugia Giovanni Battista. The total amount mentioned is 7,000.00 Dhs, payable in cash.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\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    \"Orthodontie - Implantologie\",\n    \"Dentisterie Esthetique - Endodontie\",\n    \"Parodontie - Blanchiment\",\n    \"Invisalign\",\n    \"ICE:\n\nUser message context: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"partial_view\"]\n  },\n  \"description\": \"This is an image of a document related to dental services from Tanger Bay Dental Center. The document includes a list of procedures, dates, and the patient's name. The text mentions dental services such as orthodontics, implantology, esthetic dentistry, endodontics, and more. It also shows the clinic's name, logo, and contact information. The total amount charged is 7,000.00 DHS, and payment is made in cash.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\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    \"Tanger Bay Dental Center\",\n    \"Orthodontie - Implantologie\",\n    \"Dentisterie Esthetique - Endodontie\",\n    \"Parodontie - Blanchiment\",\n    \"Invisalign\",\n    \"ICE: 003671367000010 - IF: 66201949 -", "created_at": "2026-03-27T15:37:11.242998", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1596/download", "media_mime_type": "image/jpeg"}, {"id": 7594, "message_id": "bot_AC2FA5F86C97A14610139E40E95C2ACA_2518", "sender": "bot", "message_type": "text", "content": "Thank you for sharing the image. It appears to be a dental invoice from Tanger Bay Dental Center, detailing procedures for 'Couronne ceramo-ceramique' on teeth numbers 36 and 37, scheduled for 04/03/2026. The total amount is 7,000.00 Dhs, payable in cash.\n\nIf you have any questions or need further assistance regarding this invoice, please let me know!", "created_at": "2026-03-27T15:37:37.293397", "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 279 in training_review_items