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": 6761, "message_id": "bot_3AE7AF717FAA969730E9_2670", "sender": "bot", "message_type": "text", "content": "Bonjour Amine 😊 Merci pour ton message. Pour confirmer, tu souhaites réserver un rendez-vous pour demain. À quelle heure préfères-tu qu'on fixe l'appel ?", "created_at": "2026-03-22T01:29:21.053306", "media_url": null, "media_mime_type": null}, {"id": 6782, "message_id": "3A0185AA399BC68BE315", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم، صافا مزيان؟ كلشي مزيان؟", "created_at": "2026-03-23T17:15:31.506197", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/1351/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 6783, "message_id": "bot_3A0185AA399BC68BE315_9499", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله 😊 بارك الله فيك، نتوما بخير؟ واش كاين شي حاجة أخرى نقدر نعاونك بها؟", "created_at": "2026-03-23T17:15:50.589747", "media_url": null, "media_mime_type": null}, {"id": 6784, "message_id": "3AAAE5A14B07078903D2", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: 1) What I can see:\n- The image shows teeth with noticeable redness and swelling in the gums.\n\n2) What this could indicate (non-diagnostic):\n- This might suggest gingivitis or another form of gum inflammation.\n\n3) What you can do now:\n- Maintain good oral hygiene by brushing and flossing regularly.\n- Consider using an antiseptic mouthwash.\n- Avoid irritating foods or habits (e.g., smoking).\n\n4) When to seek urgent care:\n- If there is severe pain, intense swelling, or bleeding that doesn't stop, seek immediate care.\n\n5) Disclaimer + consultation offer:\n- “I’m an AI assistant, not a medical professional. This is general guidance based on the image only and is not a diagnosis.”\n- “If you want, I can help you book a consultation now.”\n\nUser message context: 1) What I can see:\n- The image shows upper and lower teeth with visible redness and swelling of the gums. Some teeth appear to be misaligned or crowded.\n\n2) What this could indicate (non-diagnostic):\n- The redness and swelling could suggest gingivitis or gum inflammation. Tooth misalignment can be due to crowding or orthodontic issues.\n\n3) What you can do now:\n- Maintain good oral hygiene by brushing and flossing regularly to reduce plaque buildup.\n- Use a soft-bristled toothbrush to prevent further irritation.\n- Consider using an antiseptic mouthwash to help reduce gum inflammation.\n\n4) When to seek urgent care:\n- If you experience severe pain, heavy bleeding, or pus, seek dental care immediately.\n\n5) Disclaimer + consultation offer:\n- “I’m an AI assistant, not a medical professional. This is general guidance based on the image only and is not a diagnosis.”\n- “If you want, I can help you book a consultation now.”", "created_at": "2026-03-23T17:20:11.222346", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/1352/download", "media_mime_type": "image/jpeg"}, {"id": 6785, "message_id": "3AFF619FA9D908CF059B", "sender": "user", "message_type": "text", "content": "Chof snani kfch dayrin", "created_at": "2026-03-23T17:20:18.518866", "media_url": null, "media_mime_type": null}, {"id": 6786, "message_id": "bot_3AFF619FA9D908CF059B_5520", "sender": "bot", "message_type": "text", "content": "كنعتدر، مفهمتش الرسالة الصوتية بالضبط. واش تقدر توضح ليا شنو قصدك؟", "created_at": "2026-03-23T17:20:38.257387", "media_url": null, "media_mime_type": null}, {"id": 6791, "message_id": "3A5E288157796F653971", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"analysis_version\": \"1.0\",\n  \"image_quality\": {\n    \"score\": 85,\n    \"issues\": []\n  },\n  \"visible_domain\": \"dental\",\n  \"observations\": [\n    {\n      \"feature\": \"gum redness\",\n      \"evidence\": \"gums appear red around the upper and lower teeth\",\n      \"severity\": \"moderate\"\n    },\n    {\n      \"feature\": \"tooth alignment issue\",\n      \"evidence\": \"noticeable misalignment of the teeth\",\n      \"severity\": \"moderate\"\n    }\n  ],\n  \"possible_concerns\": [\n    {\n      \"label\": \"gum_inflammation\",\n      \"confidence\": 0.8,\n      \"basis\": \"visible redness of the gums around teeth\",\n      \"non_diagnostic\": true\n    },\n    {\n      \"label\": \"alignment_irregularity\",\n      \"confidence\": 0.9,\n      \"basis\": \"teeth appear misaligned\",\n      \"non_diagnostic\": true\n    }\n  ],\n  \"service_candidates\": [\n    {\n      \"service_code\": \"periodontal_consult\",\n      \"confidence\": 0.8,\n      \"reason\": \"due to visible gum redness and potential inflammation\"\n    },\n    {\n      \"service_code\": \"orthodontics\",\n      \"confidence\": 0.9,\n      \"reason\": \"apparent misalignment of teeth observed\"\n    }\n\nUser message context: ```json\n{\n  \"analysis_version\": \"1.0\",\n  \"image_quality\": {\n    \"score\": 85,\n    \"issues\": []\n  },\n  \"visible_domain\": \"dental\",\n  \"observations\": [\n    {\n      \"feature\": \"gum redness\",\n      \"evidence\": \"visible redness on the gums\",\n      \"severity\": \"moderate\"\n    },\n    {\n      \"feature\": \"teeth misalignment\",\n      \"evidence\": \"visible crowding of teeth\",\n      \"severity\": \"moderate\"\n    }\n  ],\n  \"possible_concerns\": [\n    {\n      \"label\": \"gum_inflammation\",\n      \"confidence\": 0.8,\n      \"basis\": \"visible redness on the gums\",\n      \"non_diagnostic\": true\n    },\n    {\n      \"label\": \"alignment_irregularity\",\n      \"confidence\": 0.9,\n      \"basis\": \"visible crowding of teeth\",\n      \"non_diagnostic\": true\n    }\n  ],\n  \"service_candidates\": [\n    {\n      \"service_code\": \"periodontal_consult\",\n      \"confidence\": 0.8,\n      \"reason\": \"gum redness is apparent\"\n    },\n    {\n      \"service_code\": \"orthodontics\",\n      \"confidence\": 0.9,\n      \"reason\": \"visible crowding of teeth\"\n    }\n  ],\n  \"no_apparent_issue\": {\n    \"value\": false,", "created_at": "2026-03-23T19:01:43.561577", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/1356/download", "media_mime_type": "image/jpeg"}, {"id": 6792, "message_id": "bot_3A5E288157796F653971_5520", "sender": "bot", "message_type": "text", "content": "كنعتدر، مفهمتش الرسالة الصوتية بالضبط. واش تقدر توضح ليا شنو قصدك؟", "created_at": "2026-03-23T19:02:10.620688", "media_url": null, "media_mime_type": null}, {"id": 6793, "message_id": "3A27C94BA534806F22B7", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (Arabic script):\n\n**السلام عليكم أختي شيفاء، كيديرة بخير لاباس عليك؟ بخير؟ هانية؟ عواشرك مبركة أختي، تعيدي بالصحة والهنا. الله يحفظك. المهم أختي ديني فبالك وصافي. أختي شيفاء ما كرهتش نجي الجمعة إن شاء الله ياربي، إلا كنتي أختي الجمعة ما خداماش نجي نعمرها فبلاصتها. صافي أختي؟ الله يحفظك أختي شيفاء.**\n\n---\n\n**Latin Script Transcription:**\n\n\"Salam o alaikom khti Chifa, kidayra bikhir labas 3lik? bikhir? haniya? 3wachrek mbroka a khti, t3idi b seha o lhna. Lah ihfdek. Lmohim a khti dini f balek o safi. Khti Chifa makrehtch nji ljom3a nchaallah yarbi, ila knti khti ljom3a makhedmach nji n3merha f blast-ha. Safi a khti? Lah ihfdek a khti Chifa.\"", "created_at": "2026-03-23T19:42:12.692464", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/1357/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 6794, "message_id": "bot_3A27C94BA534806F22B7_707", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، بارك الله فيك، نتوما بخير؟ 😊 عواشرك مبروكة وتعيدي بالصحة والهنا. بالنسبة للجمعة، غادي نتأكد واش ممكن نجي ونعمرها فبلاصتها. شكرا بزاف على التواصل ديالك، والله يحفظك.", "created_at": "2026-03-23T19:42:40.414071", "media_url": null, "media_mime_type": null}, {"id": 6869, "message_id": "3AF7059F5CF2ACD2C7C8", "sender": "user", "message_type": "text", "content": "https://ma.nouveaudepart-ma.com/?utm_source=facebook&utm_medium=paid&utm_campaign=WEBI%2029%20ADS%20Maroc%20DOUAA%20ICIII&utm_term=Broad&utm_content=Vidéo%2014&fbadid=120240238453280225&fbc_id=120240227274330225&h_ad_id=120240238453280225&utm_id=120240227274490225&fbclid=PAaWdyZAQwpbtleHRuA2FlbQEwAGFkaWQBqy3cYs-j4XNydGMGYXBwX2lkDDI1NjI4MTA0MDU1OAABpzO4CosaovZDG6WKBljL07N0GuG7Xu-EdFxlHvENmg4l1dnDyLUIDLzQAHk3_aem_p64RW6VFTKacUlwy-JPQww", "created_at": "2026-03-25T11:27:41.428337", "media_url": null, "media_mime_type": null}, {"id": 6870, "message_id": "bot_3AF7059F5CF2ACD2C7C8_8439", "sender": "bot", "message_type": "text", "content": "كنعتدر، مفهمتش الرسالة بالضبط. واش تقدر توضح ليا شنو قصدك أو كيفاش نقدر نعاونك؟", "created_at": "2026-03-25T11:27:54.920852", "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 187 in training_review_items