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": 49411, "message_id": "meta_1168014699720514_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDY3MTY1NTQ5Njk5OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI2MDQzNjA2MTExMTcyMDc4MDozMjg4NDI2NTA2MzYzMjQxNTg3NjE1MDkwMTE4NzAxODc1MgZDZD", "sender": "user", "message_type": "text", "content": "Bonjour Docteur, je voulais savoir si vous aviez besoin d’une assistante dentaire. J’ai 4 ans d’expérience dans le domaine", "created_at": "2026-06-28T15:13:05.271478", "media_url": null, "media_mime_type": null}, {"id": 49412, "message_id": "meta_1168014699720514_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDY3MTY1NTQ5Njk5OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI2MDQzNjA2MTExMTcyMDc4MDozMjg4NDI2NTI5MzEwMjIwMTQxNDA3NDkxMjY5NzQ4MzI2NAZDZD", "sender": "user", "message_type": "text", "content": "[Attachment: image]", "created_at": "2026-06-28T15:13:15.206972", "media_url": null, "media_mime_type": null}, {"id": 49413, "message_id": "meta_1168014699720514_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDY3MTY1NTQ5Njk5OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI2MDQzNjA2MTExMTcyMDc4MDozMjg4NDI2NTI5MzEwMjIwMTQxNDA3NDkxMjY5NzQ4MzI2NAZDZD_image", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This image is a CV/resume. It contains a portrait photo of a woman in the upper left corner and text divided into several clearly labeled sections. The sections include: name and contact information, objective, personal information (date of birth), competencies, language proficiency, professional experience, and education background. Contact details (address, phone number, and email) are in a blue header at the top right. The professional experience is detailed, listing tasks and dentists worked for, with years included. The education section is at the bottom with years and institutions listed. Visual organization uses blue and white boxes, icons for each section, and bullet points. No signatures, stamps, or handwritten notes are present.\",\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    \"MEZGUELDI SOUMAYA ASSISTANTE ET SECRÉTAIRE\n\nUser message context: [Attachment: image]", "created_at": "2026-06-28T15:13:15.756643", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13805/download", "media_mime_type": "image/jpeg"}, {"id": 49414, "message_id": "bot_meta_1168014699720514_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDY3MTY1NTQ5Njk5OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI2MDQzNjA2MTExMTcyMDc4MDozMjg4NDI2NTI5MzEwMjIwMTQxNDA3NDkxMjY5NzQ4MzI2NAZDZD_image_4889", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre message et pour l’envoi de votre CV ! Afin de transmettre votre candidature à l’équipe, pourriez-vous me communiquer votre numéro de téléphone s’il vous plaît ?", "created_at": "2026-06-28T15:13:32.426904", "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 4065 in training_review_items