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": 13477, "message_id": "AC95A0EB55AA0D0A4C2C5531777385E3", "sender": "user", "message_type": "text", "content": "slm", "created_at": "2026-04-10T09:51:13.537452", "media_url": null, "media_mime_type": null}, {"id": 13478, "message_id": "A56C24286EA0AF7E3CFB8521AC5A7826", "sender": "bot", "message_type": "text", "content": "Bonjour et bienvenue au Cabinet dentaire Tanger Bay \nمرحبا بكم فـ عيادة طنجة باي لطب الأسنان.\n\n Merci de nous indiquer en quoi nous pouvons vous aider afin que notre équipe puisse vous orienter au mieux.\nمن فضلكم، أخبرونا كيف يمكننا مساعدتكم لكي يتمكن فريقنا من توجيهكم بشكل مناسب\n\n📍 Localisation : https://maps.app.goo.gl/ZCXz3sMZkhk9diph7\n🌐 Site web : www.tangerbay.ma\n📧 Email :\ntangerbay01@gmail.com\n\n✅ Notre équipe vous répondra dans les plus brefs délais.\nسيقوم فريقنا بالرد عليكم في أقرب وقت ممكن", "created_at": "2026-04-10T09:51:15.004908", "media_url": null, "media_mime_type": null}, {"id": 13479, "message_id": "AC8FF416F14DCF5706EDA6382242DC9A", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"building\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a street-level view of the façades of several multi-story buildings. The building on the left side features signage in Arabic and French, as well as the logo and text for CNOPS (Caisse Nationale des Organismes de Prévoyance Sociale) across several windows. Above, there is a prominent blue sign with Arabic script and a medical caduceus symbol, indicating a medical center. Below that is the entrance to a building with a gold-marked panel displaying Arabic text and a decorative glass door. To the right, there are more residential and commercial building façades, with balconies, air conditioning units, and signage, including a blue street sign with the word 'YAMAMA.' Cars are parked along the street, and a portion of the road with a red-and-white curb is visible. Storefronts are present on the ground floor of other buildings, including a business named 'Picasso.'\",\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    \"", "created_at": "2026-04-10T09:51:20.172178", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3458/download", "media_mime_type": "image/jpeg"}, {"id": 13480, "message_id": "ACBBB26FE828E7BD7740FC18C36FAD91", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is a smartphone screenshot of a map interface, most likely from a ride-sharing or delivery application. The map displays a section of a city with labeled streets and several prominent landmarks. The user's current location is indicated by a blue dot, and a green pin with a storefront icon marks the pick-up location. Streets visible include Avenue Moulay Youssef, Av. Marcha Verde, Rue Ibn Atia, Rue Ibn Khozima, and Rue Terracina. Nearby landmarks shown include Hotel Etoile du Nord and a restaurant called Mr. Tacos. The top section displays the phone's system status bar showing the time (10:51), signal strength, battery percentage (86%), and network indicators. The bottom section contains a white overlay with order information: 'Pick-up, 1 pedido, Avenue Moulay Youssef, Cbops residence, 5, 5 - Haitham, TNG' and icons for calling or chatting. Various app menu and navigation icons are also visible.\",\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    \"rest", "created_at": "2026-04-10T09:51:34.839198", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3459/download", "media_mime_type": "image/jpeg"}, {"id": 13481, "message_id": "bot_ACBBB26FE828E7BD7740FC18C36FAD91_2490", "sender": "bot", "message_type": "text", "content": "شكرا على الصور اللي رسلتوهم 🙏🏻\n\nCentre Dentaire Tanger Bay كاين ف Avenue Mohammed VI، Résidence Borj Khalij Tanger 3، étage 5، appartement numéro 197، طنجة. \nها هو الرابط ديال Maps:\nhttps://maps.app.goo.gl/RCzcJXSXvgMzrRMFA\n\nإلى محتاجين أي توضيح إضافي على العنوان أو شي مساعدة أخرى، مرحبا بيكوم! واش بغيتو شي موعد أو عندكوم سؤال على شي خدمة معينة؟", "created_at": "2026-04-10T09:52:19.793806", "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 918 in training_review_items