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": 10698, "message_id": "ACF9590A0240FA283AB4006E697B94DA", "sender": "user", "message_type": "text", "content": "سلام عليكم", "created_at": "2026-04-02T12:06:52.993030", "media_url": null, "media_mime_type": null}, {"id": 10699, "message_id": "bot_ACF9590A0240FA283AB4006E697B94DA_6755", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله 😊 أنا هنا لمساعدتك في أي شيء تحتاجه في Centre Dentaire Dr DINANI Hicham. كيف يمكنني نعاونك اليوم؟", "created_at": "2026-04-02T12:07:05.729134", "media_url": null, "media_mime_type": null}, {"id": 10700, "message_id": "AC537A0BD4E1485BD2D516B2BED26CE9", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: (a) This appears to be a dental photo. \n\n(b) Visually observable features include: \n- Teeth are visible.\n- No visible discoloration on the teeth in this image.\n- The lips and part of the face are visible, with a natural skin tone. \n\n(c) There is no visible text in the image.\n\n(d) Flag: Information is factual and observational only.\n\nUser message context: (a) Type of image: Dental photo\n\n(b) Visually observable description: The image shows a close-up of a person's face, focusing on their mouth area. The teeth are visible, and there is a noticeable gap between two of the teeth.\n\n(c) Visible text (OCR): None\n\n(d) Flag: Observation provided; no diagnostic terms or treatment recommendations included.", "created_at": "2026-04-02T12:07:24.841807", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/2571/download", "media_mime_type": "image/jpeg"}, {"id": 10701, "message_id": "ACB6C35AE4E1D5CAB0BF1D8962ED37A3", "sender": "user", "message_type": "text", "content": "عندي مشكل فهاد بلاصة فيها جدر مسوس كايضرني", "created_at": "2026-04-02T12:07:41.339957", "media_url": null, "media_mime_type": null}, {"id": 10702, "message_id": "AC18098ABBABF02BEAF8F9D3E543A561", "sender": "user", "message_type": "text", "content": "وشنو نقدر ندير", "created_at": "2026-04-02T12:07:52.026724", "media_url": null, "media_mime_type": null}, {"id": 10703, "message_id": "bot_AC18098ABBABF02BEAF8F9D3E543A561_533", "sender": "bot", "message_type": "text", "content": "كنعتدر بزاف على الألم اللي كتعيشو 😔 من الأفضل تزور الدكتور باش يشوف الحالة ديالك ويعطيك العلاج المناسب. غادي نبلغ الفريق باش يتاصلوا بيكوم في أقرب وقت ممكن. واش يمكنني نعرف الإسم الكامل ديالك باش نكمل الإجراءات؟", "created_at": "2026-04-02T12:08:04.926047", "media_url": null, "media_mime_type": null}, {"id": 10704, "message_id": "AC67778F0CE8B0A0D310602E76308661", "sender": "user", "message_type": "text", "content": "شحال تدوز", "created_at": "2026-04-02T12:08:33.603947", "media_url": null, "media_mime_type": null}, {"id": 10705, "message_id": "bot_AC67778F0CE8B0A0D310602E76308661_4722", "sender": "bot", "message_type": "text", "content": "كنعتدر، خاصني الإسم الكامل ديالك باش نقدر نبلغ الفريق ويتواصلوا معاك بسرعة. واش ممكن تكتبه ليا من فضلك؟", "created_at": "2026-04-02T12:08:48.144397", "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 631 in training_review_items