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": 41843, "message_id": "3EB0A9B41652703822FC17", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BILAL  Lakhdar *\r\nVous avez Rendez Vous avec *Dr. RIAD GUENNOUNI* le *jeudi 11 juin 2026* à *18: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*BILAL *\r\nلديكم موعد مع ** يوم *الخميس 11 يونيو 2026* على الساعة *18:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-11T09:43:17.194692", "media_url": null, "media_mime_type": null}, {"id": 41905, "message_id": "A522BFABE5154022B84110897B86BED5", "sender": "user", "message_type": "text", "content": "Rdv confirmée", "created_at": "2026-06-11T10:24:26.013464", "media_url": null, "media_mime_type": null}, {"id": 42237, "message_id": "A52F5802545CA5C5DF83B9246DE066D0", "sender": "user", "message_type": "text", "content": ".", "created_at": "2026-06-11T18:07:29.455568", "media_url": null, "media_mime_type": null}, {"id": 42238, "message_id": "A5BAD841ABD9E9A8ACAB6CB94A9F499A", "sender": "bot", "message_type": "text", "content": "https://temu.to/k/e7uw35giu5l", "created_at": "2026-06-11T18:07:44.204494", "media_url": null, "media_mime_type": null}, {"id": 42239, "message_id": "A5A1A875309E9CA6966893973D0CC6FD", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-11T18:07:46.411014", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11714/download", "media_mime_type": "video/mp4"}, {"id": 42240, "message_id": "A5B7476F3FC38DA530D5262842240B19", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-11T18:07:48.071014", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11715/download", "media_mime_type": "video/mp4"}, {"id": 42241, "message_id": "A5AEBB97FC05FE6A6844D3DD74B48AAB", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-11T18:07:51.994969", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11716/download", "media_mime_type": "video/mp4"}, {"id": 42242, "message_id": "A5820234C7D6B581B2E06971D83D301A", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-11T18:07:52.482698", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11717/download", "media_mime_type": "video/mp4"}, {"id": 42243, "message_id": "3EB02856C2F8D96F41BB4C", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *2000,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+2000,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-11T18:08:46.243386", "media_url": null, "media_mime_type": null}, {"id": 42244, "message_id": "3EB066DC12CA39A809B220", "sender": "bot", "message_type": "document", "content": "2026061119080003.pdf", "created_at": "2026-06-11T18:08:57.584387", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11718/download", "media_mime_type": "application/pdf"}, {"id": 47286, "message_id": "A569C815A67ACC5063F8D501E52F1321", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic and Latin scripts:\n\n**Arabic Script:**\nألو، السلام عليكم ختي لاباس بخير؟ عيطتي لي لبارح، كنت أوكيبي (occupée)، سمحي لي.\n\n**Latin Script:**\nAllo, Salamo Alaykom khti labas bikhir? Ayatli lbareh, kount occupée, smaheli.", "created_at": "2026-06-23T10:10:39.633793", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13079/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47287, "message_id": "bot_A569C815A67ACC5063F8D501E52F1321_6752", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، مرحبا الله أودي، ماكاين حتى مشكل 😊 واش نقدر نعاونكوم بشي حاجة اليوم؟", "created_at": "2026-06-23T10:10:57.756016", "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 3928 in training_review_items