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": 15354, "message_id": "3EB0AC236C95A0EC7561D5", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *800,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+400,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-14T10:08:33.415418", "media_url": null, "media_mime_type": null}, {"id": 15355, "message_id": "3EB0625C48A2147DA383DD", "sender": "bot", "message_type": "document", "content": "2026041411082871.pdf", "created_at": "2026-04-14T10:08:46.223105", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3966/download", "media_mime_type": "application/pdf"}, {"id": 15356, "message_id": "3EB01D0636449932EC029B", "sender": "bot", "message_type": "document", "content": "_radios_SALIMA Lanjri_20260414_11085639.pdf", "created_at": "2026-04-14T10:09:03.295097", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3967/download", "media_mime_type": "application/pdf"}, {"id": 15357, "message_id": "A53C3946EB608FDB32F99F0F6DBC7C4D", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-04-14T10:13:42.670535", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3968/download", "media_mime_type": "video/mp4"}, {"id": 15358, "message_id": "A5C03460101DEE5945A9D7F52CA2E303", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-04-14T10:13:44.706299", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3969/download", "media_mime_type": "video/mp4"}, {"id": 15359, "message_id": "A5B864C01D7534279A985FF55C4F7EBA", "sender": "bot", "message_type": "document", "content": "conseil post detart copy.pdf", "created_at": "2026-04-14T10:13:45.040507", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3970/download", "media_mime_type": "application/pdf"}, {"id": 15360, "message_id": "A56BA07351667F2FB740FAC8220DB74A", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-04-14T10:13:45.234008", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3971/download", "media_mime_type": "video/mp4"}, {"id": 15371, "message_id": "3ACD573EBBC5D0D6D420", "sender": "user", "message_type": "text", "content": "Merci beaucoup ☺️", "created_at": "2026-04-14T10:17:19.730749", "media_url": null, "media_mime_type": null}, {"id": 15435, "message_id": "3A0476BBA7BF9098143B", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"object\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a box of toothpaste with the brand name 'elmex' prominently displayed in bold white lettering on a turquoise-green background. The word 'SENSITIVE' appears underneath, both on the front and on the side of the box. There is an icon of a tooth with some plus symbols near it and French text next to it. The packaging also displays several claims, such as 'FLUORURE D'AMINES OLAFLOUOR', '0% COLORANTS', and another circular icon indicating some form of clinical or protective assurance. Additional French text provides more product information near the lower right corner of the box, mentioning 'Une protection efficace pendant 24h* et un nettoyage en douceur pour les dents sensibles.' The overall box is white and turquoise-green, standard rectangular in shape, and is photographed on a white background. No visible damage, labels, or other products appear in the image.\",\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    \"calculus_plaque\n\nUser message context: ```json\n{\n  \"visible_domain\": \"object\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a box of toothpaste, positioned horizontally against a white background. The brand name 'elmex' is prominently displayed in bold white letters on a turquoise-green background. The word 'SENSITIVE' appears below the brand name, suggesting the toothpaste is formulated for sensitive teeth. There is an illustration of a tooth, and additional text in French indicating that the toothpaste contains 'FLUORURE D'AMINES OLAFUOR' and that it provides 24-hour effective protection and gentle cleaning for sensitive teeth. There is a '0% COLORANTS' label, signaling the absence of artificial coloring. Additional French text is present on the front and side, along with a symbol that looks like a medical cross.\",\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    \"calculus_plaque\": \"\",\n    \"periapical_areas\": \"\",\n    \"other_findings\": \"\"\n  },\n  \"text_visible\": [\n    \"elmex SENSITIVE\",\n    \"FLUORURE", "created_at": "2026-04-14T10:55:35.981868", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4005/download", "media_mime_type": "image/jpeg"}, {"id": 15436, "message_id": "3A2F742492E9BE40A75C", "sender": "user", "message_type": "image", "content": "```json\n{\n  \"visible_domain\": \"object\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a tube and its corresponding box packaging of a dental gel product named 'PerioKIN'. The product branding is clear, with the main colors being white and pink, contrasted by navy blue text. The text on both the tube and the box indicates that the product is for gums ('Encías' in Spanish and 'Gencivas' in Portuguese) and contains 0.20% Chlorhexidine DG. The box also features a section labeled 'Cuidado Intensivo' (Intensive Care) and specifies the flavor as mint ('Sabor menta'). The weight/volume listed is 30 ml/36g, and the presentation is a gel. There is additional text in several languages, emphasizing its use for intensive gum care. The Kin brand logo is present on both the tube and the box. The product is lying on a plain white background with no other objects 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    \"restorations_visible\": [],\n    \"missing_teeth\": \"\",\n    \"alignment\": \"\",\n    \"calculus_plaque\": \"\",", "created_at": "2026-04-14T10:55:36.592056", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4006/download", "media_mime_type": "image/jpeg"}, {"id": 15437, "message_id": "3A522D44E389E8FF3581", "sender": "user", "message_type": "text", "content": "Je veux juste m’assurer hado li tlebli docteur🙏", "created_at": "2026-04-14T10:56:07.232473", "media_url": null, "media_mime_type": null}, {"id": 15441, "message_id": "bot_3A522D44E389E8FF3581_6677", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 😊 واش ممكن تعطيني الإسم الكامل ديالك باش نأكد مع الفريق الطبي ديالنا؟", "created_at": "2026-04-14T10:56:48.276033", "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 1126 in training_review_items