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": 17676, "message_id": "3EB08F121F87C427267C2D", "sender": "bot", "message_type": "text", "content": "صحتك  هي أولويتنا، ويسعدنا خدمتك في مركز الدكتور ديناني هشام لطب الأسنان. نحن نقدر رضاك ونود أن نطلب منك تقييم تجربتك معنا باتباع هذا الرابط https://bit.ly/3yYyxc3. يتطلب التقييم خطوتين بسيطتين، يرجى التأكد من إكمال كل منهما حتى يتم قبول نتيجة التقييم بشكل جيد. شكرًا !\r\n\r\nVotre santé est notre priorité, et nous sommes heureux de vous servir au sein du Centre dentaire du Dr Dinani Hicham. Nous accordons une grande importance à votre satisfaction et aimerions vous demander d'évaluer votre expérience avec nous en suivant ce lien https://bit.ly/3yYyxc3. L'évaluation nécessite deux étapes simples, veuillez-vous assurer de compléter chacune d'elles afin que le résultat de votre évaluation soit bien reçu. Merci !", "created_at": "2026-04-23T09:43:50.438317", "media_url": null, "media_mime_type": null}, {"id": 17695, "message_id": "AC8AA365D4AC786B48EF4EE07114C43C", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: (a) Type of image: This appears to be a dental photo.\n\n(b) Visually observable details (neutral, non-diagnostic language): The image shows a close-up of a person's teeth with clear orthodontic brackets attached to the front teeth. Multiple teeth appear to have visible dark brown discoloration and uneven coloration. The lips and part of the surrounding skin are also visible. The teeth are in various positions, and the gums can be seen above the upper teeth.\n\n(c) Visible text (OCR): There is no visible text in the image.\n\n(d) Flag: No diagnostic terms, no suggestions of conditions, no recommendations for treatment provided. Output is strictly factual and observational.\n\nUser message context: (a) Image type: Dental photo  \n(b) Description: The image shows an open mouth with visible upper and lower teeth. There are clear or white orthodontic brackets attached to the teeth. There is visible brown discoloration on multiple teeth.  \n(c) Visible text (OCR): There is no visible text in the image.  \n(d) Flag: No diagnostic terms used, no conditions suggested, no treatments recommended. This is a factual and observational description only.", "created_at": "2026-04-23T10:16:33.708445", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/4818/download", "media_mime_type": "image/jpeg"}, {"id": 17696, "message_id": "AC301B3C9437CDFA2786B9C829F0E061", "sender": "user", "message_type": "image", "content": "(a) **Type of image:**  \nDental photo (intraoral photograph).\n\n(b) **Visually observable details:**  \n- Several upper teeth are visible, with transparent or white braces/brackets attached to them.\n- There is a visible green arrow drawn on the image, pointing toward one of the teeth.\n- The gums in the area being pointed to are visible.\n- The person is pulling their cheek back with their finger to expose the teeth and gums.\n- Some visible variations in tooth color are present.\n\n(c) **Visible text (OCR):**  \nThere is no visible text in the image except for the green arrow.\n\n(d) **Flag:**  \n- No diagnostic terms used.\n- No conditions suggested.\n- No treatment recommendations made.", "created_at": "2026-04-23T10:16:34.433616", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/4819/download", "media_mime_type": "image/jpeg"}, {"id": 17697, "message_id": "bot_AC301B3C9437CDFA2786B9C829F0E061_8461", "sender": "bot", "message_type": "text", "content": "الفريق غادي يتواصلوا بيكوم بهاد الموضوع إن شاء الله 🙏🏻", "created_at": "2026-04-23T10:17:05.588212", "media_url": null, "media_mime_type": null}, {"id": 17698, "message_id": "AC1EF09A4C775B6AF8CB95E13A64B07E", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: (a) Type of image: Dental photo\n\n(b) Visually observable description (neutral, non-diagnostic):  \n- This is a close-up image of the front teeth and lips of an individual.\n- The teeth have visible brackets attached, which are part of orthodontic braces.\n- There is visible brown discoloration on several teeth.\n- Two of the teeth are circled in green.\n- The circled areas show the surfaces of teeth with visible yellowish-brown areas.\n- The gums and lips are partially visible.\n\n(c) Visible text (OCR):  \n- There is no visible text present in the image.\n\n(d) Flag:  \n- No diagnostic terms or conditions have been used.\n- No treatment or recommendations are made.  \n- The description is purely factual and observational.\n\nUser message context: (a) Type of image: This appears to be a dental photo.\n\n(b) Visually observable description (neutral, non-diagnostic language):\n- The image shows the front upper and lower teeth of an individual with ceramic or clear braces (orthodontic brackets) attached.\n- There is visible discoloration on multiple teeth, ranging from yellow to brown.\n- Two teeth are marked with green circles; within these circles, the teeth appear to have areas of lightness or spots that look visually different from the rest of the tooth surface.\n- The gums, lips, and facial skin are visible at the edges of the image.\n\n(c) Visible text (OCR): No visible text is present in the image.\n\n(d) Flag: \n- No diagnostic terms used.\n- No condition suggested.\n- No treatment recommended.\n- Factual and observational only.", "created_at": "2026-04-23T10:17:50.530044", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/4820/download", "media_mime_type": "image/jpeg"}, {"id": 17699, "message_id": "bot_AC1EF09A4C775B6AF8CB95E13A64B07E_8461", "sender": "bot", "message_type": "text", "content": "الفريق غادي يتواصلوا بيكوم بهاد الموضوع إن شاء الله 🙏🏻", "created_at": "2026-04-23T10:18:13.244701", "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 1365 in training_review_items