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": 16917, "message_id": "A55A4A71DC5081511AAE3948FE514271", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-16T16:22:59.675736", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4531/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16920, "message_id": "A558C613AAFD47A5A1032378137F89F8", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-16T16:23:28.278611", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4532/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16921, "message_id": "3A3FBE2971071498B39C", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-04-16T16:23:32.700199", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4533/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16922, "message_id": "3A3D2DAC081AF8FDE880", "sender": "user", "message_type": "text", "content": "Ah safi wkaha meziana", "created_at": "2026-04-16T16:23:57.763001", "media_url": null, "media_mime_type": null}, {"id": 16923, "message_id": "3EB09CF78B1183E068EDAE", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*SORF Oumaima *\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 02 mai 2026* à *10:00* .\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لديكم موعد مع ** يوم *السبت 2 ماي 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-16T16:24:05.517040", "media_url": null, "media_mime_type": null}, {"id": 16924, "message_id": "3AAEFF54274EF0E89723", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-04-16T16:24:11.212874", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4534/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16938, "message_id": "A5113B921567A47F891182D3DE03650F", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-16T16:32:46.714291", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4542/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16948, "message_id": "3AB9A9C29E6D45778C83", "sender": "user", "message_type": "text", "content": "Safi", "created_at": "2026-04-16T16:50:37.058865", "media_url": null, "media_mime_type": null}, {"id": 16949, "message_id": "3A104CADEAD760A77015", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-04-16T16:51:00.710734", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4550/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 17016, "message_id": "A510C254355BDC0AE048B416234E33E6", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-16T17:22:01.003765", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4590/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 18895, "message_id": "3AB6E167479E53CB4E53", "sender": "user", "message_type": "text", "content": "Bonsoir ! \nSvp J’ai une urgence ! Thatak le mini vice m’en blasto…. Ça le fait hyper mal", "created_at": "2026-04-24T19:48:14.040915", "media_url": null, "media_mime_type": null}, {"id": 18899, "message_id": "bot_3AB6E167479E53CB4E53_8003", "sender": "bot", "message_type": "text", "content": "Je suis désolé d'apprendre ça 🙏🏻 Notre équipe va vous contacter très bientôt.", "created_at": "2026-04-24T19:48:29.857690", "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 1430 in training_review_items