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": 8515, "message_id": "AC4770F55A75271FE6923ADEA083AA59", "sender": "user", "message_type": "text", "content": "Le tengo claro te espero por la respuesta Buena noche", "created_at": "2026-03-29T21:38:15.313154", "media_url": null, "media_mime_type": null}, {"id": 8516, "message_id": "bot_AC4770F55A75271FE6923ADEA083AA59_1224", "sender": "bot", "message_type": "text", "content": "Perfecto, Mohamed. El equipo te contactará pronto. Que tengas una excelente noche 😊", "created_at": "2026-03-29T21:38:26.787484", "media_url": null, "media_mime_type": null}, {"id": 8517, "message_id": "ACE376E0A7FCEB79FD691EAF399FDFAC", "sender": "user", "message_type": "text", "content": "Gracias señorita u señora", "created_at": "2026-03-29T21:39:13.218288", "media_url": null, "media_mime_type": null}, {"id": 8518, "message_id": "bot_ACE376E0A7FCEB79FD691EAF399FDFAC_1467", "sender": "bot", "message_type": "text", "content": "De nada Mohamed, un placer ayudarte 😊 ¡Que descanses bien!", "created_at": "2026-03-29T21:39:24.323305", "media_url": null, "media_mime_type": null}, {"id": 8519, "message_id": "AC5BEF872D036E1DB997A62BF62A2266", "sender": "user", "message_type": "text", "content": "Gracias 👍", "created_at": "2026-03-29T21:39:44.896942", "media_url": null, "media_mime_type": null}, {"id": 8520, "message_id": "bot_AC5BEF872D036E1DB997A62BF62A2266_6300", "sender": "bot", "message_type": "text", "content": "Con mucho gusto Mohamed 😊 Si necesitas algo más, aquí estoy. ¡Buena noche!", "created_at": "2026-03-29T21:39:56.317426", "media_url": null, "media_mime_type": null}, {"id": 8521, "message_id": "AC2FAB430E2EDF034503CF6A0DFCA84C", "sender": "user", "message_type": "text", "content": "no perdona por molestarte", "created_at": "2026-03-29T21:40:40.255811", "media_url": null, "media_mime_type": null}, {"id": 8522, "message_id": "bot_AC2FAB430E2EDF034503CF6A0DFCA84C_4080", "sender": "bot", "message_type": "text", "content": "No es ninguna molestia, Mohamed 😊 Estoy aquí para ayudarte cuando lo necesites. ¡Que tengas una buena noche!", "created_at": "2026-03-29T21:40:51.614066", "media_url": null, "media_mime_type": null}, {"id": 8523, "message_id": "ACED0617BD2AACD8164C5DBAD02B97C9", "sender": "user", "message_type": "text", "content": "👍", "created_at": "2026-03-29T21:41:05.957479", "media_url": null, "media_mime_type": null}, {"id": 8524, "message_id": "bot_ACED0617BD2AACD8164C5DBAD02B97C9_5374", "sender": "bot", "message_type": "text", "content": "Gracias Mohamed 😊 Que pases una excelente noche.", "created_at": "2026-03-29T21:41:16.585091", "media_url": null, "media_mime_type": null}, {"id": 8525, "message_id": "ACFF76A83F94E6EB47EC98C6EDE111AC", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"dental_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is a collage with two distinct intraoral dental prosthesis views on a black background, with a central overlay of a clinic logo 'MiBO CENTRO ODONTOLÓGICO INTEGRAL AVANZADO.' The top photo shows a maxillary (upper) full-arch prosthesis with four visible abutment areas (likely for implant attachments), an integrated metal framework, and a set of artificial anterior teeth. The bottom photo shows a mandibular (lower) full-arch prosthesis also with four abutment attachment housings, and no visible teeth (the prosthesis is tissue-borne, designed for use with implants). Both prostheses show areas designed to interface with dental implants, evident by the round attachment housings. The pink acrylic base mimics gum tissue, with some wear and embedded metallic/white areas where abutments would lock. The background is clear and uncluttered.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"Gum tissue not visible; only pink acrylic portions of the prostheses are visible, designed to mimic the mucosa.\",\n    \"bone_level\": null,\n    \"root_canals\": null\n\nUser message context: ```json\n{\n  \"visible_domain\": \"dental_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is composed of two clinical photos showing upper and lower full-arch dental prostheses, likely implant-supported overdentures. Both prostheses are pink in color with visible metallic components and attachment housings for implants (four visible on the upper, two on the lower). The prostheses show artificial teeth in the anterior region of the upper arch with pink acrylic base mimicking gum tissue. No natural teeth are present in the prostheses themselves. Some areas show white blocks suggesting reinforcements or past repairs. The logo 'MIBO Centro Odontológico Integral Avanzado' is prominently overlaid between the two photos, partially obscuring the middle of the upper prosthesis. Background is black, providing good contrast.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"Artificial pink gum base; appears clean and well-adapted to the prosthesis base. No natural gum is visible, only prosthetic tissue.\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [\n      \"Implant components visible (attachment housings, likely locator or similar)\",\n      \"Metal reinforcement bar visible in the upper prost", "created_at": "2026-03-29T21:41:24.583214", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1852/download", "media_mime_type": "image/jpeg"}, {"id": 8526, "message_id": "bot_ACFF76A83F94E6EB47EC98C6EDE111AC_9204", "sender": "bot", "message_type": "text", "content": "Thank you for sharing the photo, Mohamed. This image shows upper and lower full-arch dental prostheses, most likely designed to fit on dental implants. The pink base mimics gum tissue, and the metallic parts are for attachment to implants.\n\nThis is just an initial impression based on the photo, not a medical diagnosis — only the doctor can give a precise evaluation. Would you like me to suggest a service or help you book a consultation to discuss your case?", "created_at": "2026-03-29T21:41:54.767691", "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 411 in training_review_items