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": 4254, "message_id": "3EB039974E915F97763CA3", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-13T17:16:23.387828", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/646/download", "media_mime_type": "image/jpeg"}, {"id": 4255, "message_id": "3EB0947CCFDBBB2387B67D", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-13T17:16:23.628529", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/647/download", "media_mime_type": "image/jpeg"}, {"id": 4256, "message_id": "3EB083977B9E1C9F0D0E95", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-13T17:16:23.919290", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/648/download", "media_mime_type": "image/jpeg"}, {"id": 4257, "message_id": "3EB0AC72CF19162778AE45", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-13T17:16:24.171247", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/649/download", "media_mime_type": "image/jpeg"}, {"id": 4258, "message_id": "3EB0A42D322025DAF57C15", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-13T17:16:24.413090", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/650/download", "media_mime_type": "image/jpeg"}, {"id": 4259, "message_id": "3EB05A0B46DD6821DBFD4A", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-13T17:16:24.657913", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/651/download", "media_mime_type": "image/jpeg"}, {"id": 4260, "message_id": "3EB04C81572F30DDFFAE9C", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-13T17:16:24.891730", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/652/download", "media_mime_type": "image/jpeg"}, {"id": 4261, "message_id": "3EB092EBA74E7627F5367F", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-13T17:16:25.159867", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/653/download", "media_mime_type": "image/jpeg"}, {"id": 4262, "message_id": "3EB01F60FD849FDE5DDC1B", "sender": "bot", "message_type": "document", "content": "_radios_GHAMMARTI Ouissal_20260313_17095436.pdf", "created_at": "2026-03-13T17:16:25.747171", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/654/download", "media_mime_type": "application/pdf"}, {"id": 8570, "message_id": "3EB0F74D91E43B0BD81282", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*GHAMMARTI Ouissal*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mardi 31 mars 2026* à *10: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لديكم موعد مع ** يوم *الثلاثاء 31 مارس 2026* على الساعة *10:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-30T08:09:14.635436", "media_url": null, "media_mime_type": null}, {"id": 8615, "message_id": "2A4D9D442E3209D373DC", "sender": "user", "message_type": "text", "content": "Salam \nPossible nrej3ouh le mercredi ?", "created_at": "2026-03-30T09:24:14.615431", "media_url": null, "media_mime_type": null}, {"id": 8616, "message_id": "bot_2A4D9D442E3209D373DC_5243", "sender": "bot", "message_type": "text", "content": "Oh mince… On avait réservé ce créneau spécialement pour vous. Est-ce qu'il y a une chance que vous puissiez quand même venir mardi ? Si c'est vraiment nécessaire de décaler à mercredi, pas de souci 😊", "created_at": "2026-03-30T09:24:29.980065", "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 427 in training_review_items