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": 43038, "message_id": "bot_3ACA41724B34049B550B_7927", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Bienvenue au Centre Dentaire Tanger Bay, cabinet du Dr Haitham Boutaib. Comment puis-je vous aider ?", "created_at": "2026-06-13T22:54:44.374598", "media_url": null, "media_mime_type": null}, {"id": 43039, "message_id": "3A6BEA503A54F085D38D", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-06-13T22:55:05.392420", "media_url": null, "media_mime_type": null}, {"id": 43040, "message_id": "bot_3A6BEA503A54F085D38D_9630", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Tanger Bay وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-06-13T22:55:16.023696", "media_url": null, "media_mime_type": null}, {"id": 43041, "message_id": "3AEDB0AA59D1FE67C132", "sender": "user", "message_type": "text", "content": "Bghit gha n3raf chhal bax it9amo 3liya snan fixe", "created_at": "2026-06-13T22:56:01.217918", "media_url": null, "media_mime_type": null}, {"id": 43042, "message_id": "bot_3AEDB0AA59D1FE67C132_4841", "sender": "bot", "message_type": "text", "content": "الثمن ديال snan fixe كيتحدد على حساب الحالة ديالكوم بعد التقييم 😊 واش بغيتو شي consultation باش يشوف Dr Haitham Boutaib الحالة ديالكوم ويعطيكوم التفاصيل؟", "created_at": "2026-06-13T22:56:19.813300", "media_url": null, "media_mime_type": null}, {"id": 43043, "message_id": "3A104F35D4FFF1D5CA80", "sender": "user", "message_type": "text", "content": "Ah Ila momkin", "created_at": "2026-06-13T22:57:02.209334", "media_url": null, "media_mime_type": null}, {"id": 43044, "message_id": "bot_3A104F35D4FFF1D5CA80_4794", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 باش نحجزو ليكوم consultation، محتاجين الإسم الكامل ديالكوم والوقت اللي مناسبكوم إن شاء الله.", "created_at": "2026-06-13T22:57:14.340027", "media_url": null, "media_mime_type": null}, {"id": 43045, "message_id": "3AAD7B53E335D248F1A8", "sender": "user", "message_type": "text", "content": "Hamza El mousaoui", "created_at": "2026-06-13T22:57:41.168752", "media_url": null, "media_mime_type": null}, {"id": 43046, "message_id": "bot_3AAD7B53E335D248F1A8_1558", "sender": "bot", "message_type": "text", "content": "شكراً Hamza! واش كاين شي وقت معيّن اللي مناسبك باش تدير consultation؟ (مثلاً صباح، عشية، أو نهار معيّن)", "created_at": "2026-06-13T22:57:53.186171", "media_url": null, "media_mime_type": null}, {"id": 43047, "message_id": "3A5CF26646CB06E6767E", "sender": "user", "message_type": "text", "content": "F ayi watt", "created_at": "2026-06-13T22:58:22.720748", "media_url": null, "media_mime_type": null}, {"id": 43048, "message_id": "3A3995BF4604A91F146F", "sender": "user", "message_type": "text", "content": "Waqt", "created_at": "2026-06-13T22:58:25.538290", "media_url": null, "media_mime_type": null}, {"id": 43049, "message_id": "bot_3A3995BF4604A91F146F_7239", "sender": "bot", "message_type": "text", "content": "واخا Hamza، غادي نبلغ الفريق الطبي ديالنا بطلبك وغادي يتواصلوا معاكوم في أقرب وقت باش يحددوا معاكوم الموعد اللي يريحكوم إن شاء الله. شكراً على الثقة ديالك! 😊", "created_at": "2026-06-13T22:58:37.508288", "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 3536 in training_review_items