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": 41985, "message_id": "A59BE85586EC227ADDC9ABF55666009A", "sender": "bot", "message_type": "text", "content": "<reply_to>Merci pour votre retour.\nIl me manque deux dents, il faudra quand même une prothèse totale ?</reply_to> Non", "created_at": "2026-06-11T11:24:35.809612", "media_url": null, "media_mime_type": null}, {"id": 41986, "message_id": "A571E6910AC37AFC2DC9DC91369906EF", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"object\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This image displays a dental object, specifically a partial denture (prosthesis) made of pink flexible material designed to mimic the gum, with three artificial teeth embedded. The teeth are anatomically shaped and appear to be replacements for lower molar/premolar-type teeth. The prosthesis appears clean and unused, possibly a product demo or catalog image, with a white background. The branding 'Seeddent' is visible faintly across the pink gum portion. The upper section of the image shows a mobile screenshot with the Alibaba app interface, a price listing (€9.66 EUR), a short product description in French about materials for dental prostheses/flexible materials, and links to visit, share, or save options. There are smaller images of similar dental prostheses at the bottom, partially visible.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": null,\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": null,\n    \"alignment\": null,\n    \"calculus_plaque\": null,\n    \"periapical_areas\": null,\n    \"other_findings\": null", "created_at": "2026-06-11T11:25:27.118479", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11621/download", "media_mime_type": "image/jpeg"}, {"id": 41992, "message_id": "3AF8C915782195CB6B81", "sender": "user", "message_type": "text", "content": "Ah oui beaucoup plus discret.\nCombien de temps de préparation s’il vous plait, et vos tarifs ?\nMerci", "created_at": "2026-06-11T11:34:45.021381", "media_url": null, "media_mime_type": null}, {"id": 41993, "message_id": "A5A4561573B39A170E471AA18E88B4E6", "sender": "bot", "message_type": "text", "content": "<reply_to>Ah oui beaucoup plus discret.\nCombien de temps de préparation s’il vous plait, et vos tarifs ?\nMerci</reply_to> Max 2 hours tkon wajda", "created_at": "2026-06-11T11:59:46.676610", "media_url": null, "media_mime_type": null}, {"id": 42067, "message_id": "3AB1231D2A0B8409C9C4", "sender": "user", "message_type": "text", "content": "Parfait merci", "created_at": "2026-06-11T14:31:35.424682", "media_url": null, "media_mime_type": null}, {"id": 42087, "message_id": "A527DE07E4798F98174C3EBC54B2E81D", "sender": "bot", "message_type": "text", "content": "Marhba", "created_at": "2026-06-11T14:44:44.595180", "media_url": null, "media_mime_type": null}, {"id": 44033, "message_id": "3A0310675ED4D4A19AB5", "sender": "user", "message_type": "text", "content": "Chokran et vos tarifs ?\nInchallah je vous contacte lorsque je serai sur place.", "created_at": "2026-06-15T22:34:52.594669", "media_url": null, "media_mime_type": null}, {"id": 44034, "message_id": "bot_3A0310675ED4D4A19AB5_8745", "sender": "bot", "message_type": "text", "content": "Merci pour votre intérêt 😊 La consultation est à 200DH, la radio panoramique aussi à 200DH.", "created_at": "2026-06-15T22:35:32.347991", "media_url": null, "media_mime_type": null}, {"id": 44035, "message_id": "bot_3A0310675ED4D4A19AB5_287", "sender": "bot", "message_type": "text", "content": "Pour les autres soins, le tarif dépend de votre situation après évaluation par le Dr Haitham Boutaib.", "created_at": "2026-06-15T22:35:32.407515", "media_url": null, "media_mime_type": null}, {"id": 44036, "message_id": "bot_3A0310675ED4D4A19AB5_4506", "sender": "bot", "message_type": "text", "content": "N'hésitez pas à nous contacter quand vous serez sur place, on reste à votre disposition !", "created_at": "2026-06-15T22:35:32.467612", "media_url": null, "media_mime_type": null}, {"id": 44058, "message_id": "3AA834A5479F46546BF1", "sender": "user", "message_type": "text", "content": "Parfait \nMerci beaucoup.", "created_at": "2026-06-16T04:58:20.420172", "media_url": null, "media_mime_type": null}, {"id": 44059, "message_id": "bot_3AA834A5479F46546BF1_6359", "sender": "bot", "message_type": "text", "content": "Avec plaisir, merci à vous 🙏🏻 Au plaisir de vous accueillir !", "created_at": "2026-06-16T04:58:32.747921", "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 3656 in training_review_items