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": 33928, "message_id": "A580AC53E12DB3F2FCE9618A81BBA448", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-05-22T11:14:40.295230", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9694/download", "media_mime_type": "image/jpeg"}, {"id": 33929, "message_id": "A5A472A50E3C61695C8E2DCAE2B38DE8", "sender": "bot", "message_type": "text", "content": "<reply_to>[Image]</reply_to> Hada", "created_at": "2026-05-22T11:14:43.742419", "media_url": null, "media_mime_type": null}, {"id": 33932, "message_id": "AC6517C63E5F45D8081EF228E4514271", "sender": "user", "message_type": "text", "content": "Hada CIH", "created_at": "2026-05-22T11:18:29.341568", "media_url": null, "media_mime_type": null}, {"id": 33934, "message_id": "A56C8EAECF11E221C3E458325597E24E", "sender": "bot", "message_type": "text", "content": "Oui", "created_at": "2026-05-22T11:18:38.948946", "media_url": null, "media_mime_type": null}, {"id": 33935, "message_id": "ACC689EC3BD3C96D41D6BA0431107AF0", "sender": "user", "message_type": "text", "content": "Parfait", "created_at": "2026-05-22T11:18:47.123642", "media_url": null, "media_mime_type": null}, {"id": 33937, "message_id": "A5EAD2F8ADA5338D2D9F9D400FE19064", "sender": "bot", "message_type": "text", "content": "Merci", "created_at": "2026-05-22T11:21:50.787264", "media_url": null, "media_mime_type": null}, {"id": 33939, "message_id": "AC199E1A81EB452CED4C6F94AE2FD6FE", "sender": "user", "message_type": "text", "content": "🙏🏼", "created_at": "2026-05-22T11:21:55.861598", "media_url": null, "media_mime_type": null}, {"id": 33941, "message_id": "3EB0A758E8B34A8E0E318F", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *4000,00* dirhams (*Virement*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-15855,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-05-22T11:23:32.786356", "media_url": null, "media_mime_type": null}, {"id": 33943, "message_id": "3EB0CF922DAD24C88C047A", "sender": "bot", "message_type": "document", "content": "2026052212225386.pdf", "created_at": "2026-05-22T11:23:42.499851", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9699/download", "media_mime_type": "application/pdf"}, {"id": 38884, "message_id": "AC72F03D237BB21A822B8E6C760A3AE3", "sender": "user", "message_type": "document", "content": "26851673.pdf", "created_at": "2026-06-04T13:25:20.327565", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10807/download", "media_mime_type": "application/pdf"}, {"id": 44340, "message_id": "AC4BDC5C0A3B42FF004C4FD714260F76", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-06-16T13:08:54.760001", "media_url": null, "media_mime_type": null}, {"id": 44341, "message_id": "bot_AC4BDC5C0A3B42FF004C4FD714260F76_8907", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Tanger Bay وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-06-16T13:09:06.485501", "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 3675 in training_review_items