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": 7259, "message_id": "3A5AD425C79C69A76845", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-03-26T20:50:29.047043", "media_url": null, "media_mime_type": null}, {"id": 7337, "message_id": "3EB08173E045B662DC40CB", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*THOMAS JR Marcus wiley*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *vendredi 27 mars 2026* à *14:30* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الجمعة 27 مارس 2026* على الساعة *14:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-27T08:57:15.126845", "media_url": null, "media_mime_type": null}, {"id": 7339, "message_id": "3A21908AC0D48B91DA1F", "sender": "user", "message_type": "text", "content": "Good morning is 1:30 available? I have another practice at 5pm today", "created_at": "2026-03-27T08:59:22.429645", "media_url": null, "media_mime_type": null}, {"id": 7340, "message_id": "A5367864BDBB3B3DC171C934B3B8E7DF", "sender": "bot", "message_type": "text", "content": "<reply_to>Good morning is 1:30 available? I have another practice at 5pm today</reply_to> Unfortunately no", "created_at": "2026-03-27T09:03:15.689577", "media_url": null, "media_mime_type": null}, {"id": 7341, "message_id": "3A78E5E0493B7D9553DE", "sender": "user", "message_type": "text", "content": "Ok 2:30 works see you then", "created_at": "2026-03-27T09:11:59.957676", "media_url": null, "media_mime_type": null}, {"id": 7367, "message_id": "3EB029BA74C9663C9A156A", "sender": "bot", "message_type": "document", "content": "20260327_10561864.pdf", "created_at": "2026-03-27T10:14:19.476167", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1515/download", "media_mime_type": "application/pdf"}, {"id": 7415, "message_id": "A5E7A1ECAC0B19843EBB64E98407D737", "sender": "bot", "message_type": "text", "content": "<reply_to>Ok 2:30 works see you then</reply_to> Ok", "created_at": "2026-03-27T11:07:25.350557", "media_url": null, "media_mime_type": null}, {"id": 7735, "message_id": "3A3111A1FEFC4D3513D3", "sender": "user", "message_type": "text", "content": "Hi, I am free tomorrow morning", "created_at": "2026-03-27T19:40:25.377301", "media_url": null, "media_mime_type": null}, {"id": 7736, "message_id": "bot_3A3111A1FEFC4D3513D3_7329", "sender": "bot", "message_type": "text", "content": "Hello! 😊 It looks like your appointment is already confirmed for today at 14:30 with Dr. Haitham Boutaib. If you need to reschedule for tomorrow morning, please let me know, and I'll assist you with the changes.", "created_at": "2026-03-27T19:40:41.924724", "media_url": null, "media_mime_type": null}, {"id": 7737, "message_id": "3AE26D9A303FC246A163", "sender": "user", "message_type": "text", "content": "I was there already today", "created_at": "2026-03-27T19:41:24.629030", "media_url": null, "media_mime_type": null}, {"id": 7738, "message_id": "3A1066A0E5523CF68B50", "sender": "user", "message_type": "text", "content": "He wants me to come back tomorrow/saturday", "created_at": "2026-03-27T19:41:42.111905", "media_url": null, "media_mime_type": null}, {"id": 7739, "message_id": "bot_3A1066A0E5523CF68B50_9659", "sender": "bot", "message_type": "text", "content": "Oh, on avait réservé ce créneau spécialement pour vous aujourd'hui. Y a-t-il une chance que vous puissiez quand même venir ? Sinon, pas de souci. Voulez-vous que je vérifie les disponibilités pour demain matin ? 😊", "created_at": "2026-03-27T19:41:56.310941", "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 324 in training_review_items