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": 7274, "message_id": "A5A6D58A3D7794EF70426B78586CD8F4", "sender": "bot", "message_type": "text", "content": "Oui 400 dh par dent", "created_at": "2026-03-26T21:21:28.782227", "media_url": null, "media_mime_type": null}, {"id": 7275, "message_id": "3A655A026FFBB45DE23F", "sender": "user", "message_type": "text", "content": "Dcc Prix Cristal", "created_at": "2026-03-26T21:23:09.057864", "media_url": null, "media_mime_type": null}, {"id": 7276, "message_id": "3AF40867EDD2BD13CDE1", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"oral_photo\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"Close-up intraoral photo of the front teeth and lips. The lips appear well hydrated, with a shiny gloss applied. Most of the upper and lower incisors and canines are visible. There are metallic (silver-colored) accessories or caps seen on the upper lateral incisors bilaterally. The teeth themselves appear well aligned and without visible discoloration or gross decay. The gumline is visible and appears normal in coloration and contour. No visible lesions, swelling, or obvious inflammation of the gingival tissues. No obvious dental plaque or calculus is apparent. Teeth have a healthy, white shade with no visible chips or cracks. The background and surrounding area are not shown; only the mouth area is in the image and in focus.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"partial\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"front_upper\",\n        \"observation\": \"Two upper lateral incisors have shiny silver-colored metallic accessories or caps at the incisal edges. Central incisors and canines appear intact with smooth surfaces.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"front_lower\",\n        \"observation\": \"Visible lower anterior teeth appear intact and well aligned, with\n\nUser message context: Bghit exactly like this", "created_at": "2026-03-26T21:24:09.087572", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1490/download", "media_mime_type": "image/jpeg"}, {"id": 8302, "message_id": "A5527A2746CBEB8675629104C671DA14", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here’s the transcription of the audio in Moroccan Darija (using Arabic script):\n\nالسلام عليكم، صبا لاباس عليك؟ مزيانة بخير؟ سمحي لي ما جاوبتكش حيتاش عليهم الدوموند بزاف، تقاداو، حتى نتأكد ليك غدا من لاكلينيك نشوف واش جات لاكوموند ولا باقي ونرد عليك.\n\n**Transcription in Latin script (Darija):**\n\"Assalamu alaykum, Saba labas alik? Meziana, bikhir? Smehli ma jawbtkch hitach alihoum l'demande bezzaf, tgadaw, hta n'tkedlek ghedda m'la clinique nchouf wach jat la commande wela baqi w n'rred alik.\"", "created_at": "2026-03-29T13:01:42.669926", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1809/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8333, "message_id": "3A0981F645141FD8A1E1", "sender": "user", "message_type": "text", "content": "Dcc", "created_at": "2026-03-29T13:45:04.010646", "media_url": null, "media_mime_type": null}, {"id": 8334, "message_id": "bot_3A0981F645141FD8A1E1_2057", "sender": "bot", "message_type": "text", "content": "هاد الصورة كتوضح الأسنان ديالكوم من القدام، وبالنسبة لطلبكم \"Prix Cristal\" أو \"dcc\"، خاصني نفهم بالضبط واش كتقصدو facettes en cristal ولا couronnes cristal ولا شي نوع آخر؟ وبالنسبة للثمن، واش كتقلبو على أرخص سعر ولا على أحسن نتيجة لحالتكوم؟", "created_at": "2026-03-29T13:45:36.264270", "media_url": null, "media_mime_type": null}, {"id": 8812, "message_id": "A55BFE4161326837200786F81A434632", "sender": "bot", "message_type": "text", "content": "<reply_to>Bghit exactly like this</reply_to> Kaynin", "created_at": "2026-03-30T11:54:21.090993", "media_url": null, "media_mime_type": null}, {"id": 8813, "message_id": "A5BB0052AA1453E6260E7B757E722ECE", "sender": "bot", "message_type": "text", "content": "Marhba", "created_at": "2026-03-30T11:54:23.288808", "media_url": null, "media_mime_type": null}, {"id": 8814, "message_id": "A545725337307112407FDE9B817E3DB0", "sender": "bot", "message_type": "voice", "content": "[Voice message] الو السلام عليكم، بغيت ناخد غونديفو مع الدكتور.", "created_at": "2026-03-30T11:54:28.982813", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1946/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8864, "message_id": "3A06C4E1D6D89CD776DF", "sender": "user", "message_type": "text", "content": "Wakha 9oli prix ?", "created_at": "2026-03-30T12:34:49.523207", "media_url": null, "media_mime_type": null}, {"id": 8866, "message_id": "3A2DE056E4D9F8628627", "sender": "user", "message_type": "text", "content": "Svp", "created_at": "2026-03-30T12:35:19.629102", "media_url": null, "media_mime_type": null}, {"id": 8868, "message_id": "bot_3A2DE056E4D9F8628627_9371", "sender": "bot", "message_type": "text", "content": "واخا نقدر نعطيكوم une estimation على الثمن 😊 ولكن خاصني نسولكوم واش كتقلبو على أرخص سعر ولا على أحسن نتيجة لحالتكوم؟", "created_at": "2026-03-30T12:35:57.874659", "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 473 in training_review_items