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": 8823, "message_id": "AC57E5A798EDE808365F881DBB6BE203", "sender": "user", "message_type": "text", "content": "Youssra el lahyani", "created_at": "2026-03-30T11:58:35.388948", "media_url": null, "media_mime_type": null}, {"id": 8824, "message_id": "AC39FAA17B3185EFB47E74DEBBA6BCAB", "sender": "user", "message_type": "text", "content": "20/10/99", "created_at": "2026-03-30T11:58:40.858901", "media_url": null, "media_mime_type": null}, {"id": 8827, "message_id": "bot_AC39FAA17B3185EFB47E74DEBBA6BCAB_2084", "sender": "bot", "message_type": "text", "content": "مرحبا يسرى 😊 كيف نقدر نعاونك اليوم؟ واش كاين شي خدمة معينة أو استفسار عندك؟", "created_at": "2026-03-30T11:58:53.681081", "media_url": null, "media_mime_type": null}, {"id": 8829, "message_id": "ACDD35A7553ADCEBEB9F2CE9E3B65F37", "sender": "user", "message_type": "text", "content": "LB233418", "created_at": "2026-03-30T11:59:13.609954", "media_url": null, "media_mime_type": null}, {"id": 8830, "message_id": "AC34453637F9185B6F76BA1B85ECB8D1", "sender": "user", "message_type": "voice", "content": "[Voice message] أنا اختصرت ليك المعلومات ديالي، شوف ليا شي رانديفو في العشية الله يعطيك الستر.", "created_at": "2026-03-30T11:59:23.598185", "media_url": "/api/v1/chatbots/41/knowledge-bases/media/files/1954/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8833, "message_id": "bot_AC34453637F9185B6F76BA1B85ECB8D1_5569", "sender": "bot", "message_type": "text", "content": "شكرا يسرى على المعلومات ديالك. واش عندك شي وقت محدد فالعشية اللي كيناسبك؟ وغادي نبلغ الفريق باش يتواصلوا معاك ويأكدوا الموعد إن شاء الله. 🙏🏻", "created_at": "2026-03-30T11:59:34.874013", "media_url": null, "media_mime_type": null}, {"id": 8835, "message_id": "ACCAFEEB92025F1ADDCE651B5D0F114B", "sender": "user", "message_type": "text", "content": "معا 17:00", "created_at": "2026-03-30T12:00:21.469756", "media_url": null, "media_mime_type": null}, {"id": 8837, "message_id": "bot_ACCAFEEB92025F1ADDCE651B5D0F114B_1254", "sender": "bot", "message_type": "text", "content": "تم تسجيل طلبك يسرى، والفريق غادي يتاصلوا بيك باش يأكدوا الموعد على الساعة 17:00 إن شاء الله. شكرا على الثقة ديالك! 😊", "created_at": "2026-03-30T12:00:38.412660", "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 465 in training_review_items