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": 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}, {"id": 7745, "message_id": "3A63EF55A18CF7C04E56", "sender": "user", "message_type": "text", "content": "Do you understand?", "created_at": "2026-03-27T19:43:14.654197", "media_url": null, "media_mime_type": null}, {"id": 7746, "message_id": "3A0DE3419CD71B42A3C7", "sender": "user", "message_type": "text", "content": "I am looking for an appointment for tomorrow", "created_at": "2026-03-27T19:43:24.987382", "media_url": null, "media_mime_type": null}, {"id": 7747, "message_id": "bot_3A0DE3419CD71B42A3C7_5586", "sender": "bot", "message_type": "text", "content": "Pour demain, samedi 28 mars, nous avons plusieurs créneaux disponibles le matin. Vous pouvez choisir parmi les horaires suivants : 08:00, 08:30, ou 09:00. Quel horaire vous conviendrait le mieux ? 😊", "created_at": "2026-03-27T19:43:43.842375", "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 325 in training_review_items