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": 13545, "message_id": "AC418C30905B69F91AACE604A84826A6", "sender": "user", "message_type": "text", "content": "Ok merci", "created_at": "2026-04-10T10:58:06.588502", "media_url": null, "media_mime_type": null}, {"id": 13547, "message_id": "A5305130B78974077D52B435D23FF5F1", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-10T10:58:22.205472", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3484/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13548, "message_id": "bot_AC418C30905B69F91AACE604A84826A6_8601", "sender": "bot", "message_type": "text", "content": "Avec plaisir ! L’équipe va vous contacter très bientôt إن شاء الله. Si besoin, n’hésitez pas à écrire ici. Bonne journée à vous 😊", "created_at": "2026-04-10T10:58:24.968640", "media_url": null, "media_mime_type": null}, {"id": 13549, "message_id": "A5AA793DFA590AF5F597C22C4F62230A", "sender": "bot", "message_type": "text", "content": "Harbouch amine", "created_at": "2026-04-10T10:58:39.511075", "media_url": null, "media_mime_type": null}, {"id": 13554, "message_id": "AC37494F5E0F9126A8CEF26DDD21B53F", "sender": "user", "message_type": "text", "content": "D'accord, donc de 17h30 à 18h30 ?", "created_at": "2026-04-10T10:59:56.562065", "media_url": null, "media_mime_type": null}, {"id": 14285, "message_id": "A568CAD00E3606348CCAFD0F49635E2B", "sender": "bot", "message_type": "text", "content": "Oui", "created_at": "2026-04-12T10:46:24.962365", "media_url": null, "media_mime_type": null}, {"id": 14865, "message_id": "3EB06D06F02DF2C8463BDB", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HARBOUCH Amine*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 13 avril 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*HARBOUCH*\r\nلديكم موعد مع ** يوم *الأثنين 13 أبريل 2026* على الساعة *18:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-13T13:41:51.043219", "media_url": null, "media_mime_type": null}, {"id": 15111, "message_id": "3EB03E71EB0376C58AC755", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HARBOUCH Amin*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *vendredi 24 avril 2026* à *17: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لديكم موعد مع ** يوم *الجمعة 24 أبريل 2026* على الساعة *17:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-13T17:48:47.742845", "media_url": null, "media_mime_type": null}, {"id": 15112, "message_id": "3EB04D8D0214730C89A4C1", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *400,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+400,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-13T17:50:23.406887", "media_url": null, "media_mime_type": null}, {"id": 15113, "message_id": "3EB061481D6D615A0F432D", "sender": "bot", "message_type": "document", "content": "2026041318502060.pdf", "created_at": "2026-04-13T17:50:44.173640", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3884/download", "media_mime_type": "application/pdf"}, {"id": 17433, "message_id": "ACBFC516850ED7E2EC2928DF0DD83B8E", "sender": "user", "message_type": "text", "content": "Yes at 17:30?", "created_at": "2026-04-22T16:04:40.635229", "media_url": null, "media_mime_type": null}, {"id": 17434, "message_id": "bot_ACBFC516850ED7E2EC2928DF0DD83B8E_4085", "sender": "bot", "message_type": "text", "content": "Votre demande pour 17h30 a bien été notée, mais le rendez-vous ne sera confirmé qu’après validation directe par notre équipe. Ils vont vous contacter pour vous confirmer l’horaire exact très prochainement.\n\nNote : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-04-22T16:04:52.799691", "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 1336 in training_review_items