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": 11974, "message_id": "3AA0B12B009790DC951E", "sender": "user", "message_type": "text", "content": "Chwiya nkon m3ak sf tri9 3amra bzaff", "created_at": "2026-04-04T13:34:20.926612", "media_url": null, "media_mime_type": null}, {"id": 11975, "message_id": "bot_3AA0B12B009790DC951E_6685", "sender": "bot", "message_type": "text", "content": "ماشي مشكل Fatima، خدي راحتك، يلا تأخرتي شوية ما كاين باس، غير يلا وصلتي قولي لينا. مرحبا بيكوم 😊", "created_at": "2026-04-04T13:34:33.532950", "media_url": null, "media_mime_type": null}, {"id": 12079, "message_id": "3EB0C7A6404EBEEF4BD202", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *19000,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+20000,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-04T14:35:07.280971", "media_url": null, "media_mime_type": null}, {"id": 12080, "message_id": "3EB011A58F583200E21932", "sender": "bot", "message_type": "document", "content": "2026040415350277.pdf", "created_at": "2026-04-04T14:35:19.809150", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3061/download", "media_mime_type": "application/pdf"}, {"id": 12101, "message_id": "3A2A05501E6D7B09F961", "sender": "user", "message_type": "text", "content": "Slm khti 3afak siftili scaner li dirt", "created_at": "2026-04-04T15:43:57.170156", "media_url": null, "media_mime_type": null}, {"id": 12104, "message_id": "A516830BBDE7131B7BBD076AEAA19D17", "sender": "bot", "message_type": "text", "content": "Ok", "created_at": "2026-04-04T15:58:03.866171", "media_url": null, "media_mime_type": null}, {"id": 12108, "message_id": "A53AD64B6A501AC774F535542D44D2D3", "sender": "bot", "message_type": "text", "content": "https://drive.google.com/drive/folders/1O0Q8zsoAxDYfBhB4HATyL9ZWWg2ixQBx?usp=sharing", "created_at": "2026-04-04T15:59:39.352848", "media_url": null, "media_mime_type": null}, {"id": 12109, "message_id": "3A1C02C2EB8495A0A65B", "sender": "user", "message_type": "text", "content": "شكراا", "created_at": "2026-04-04T16:16:04.988399", "media_url": null, "media_mime_type": null}, {"id": 12110, "message_id": "A5564861A5C1EF4DE7848AE735325ACD", "sender": "bot", "message_type": "text", "content": "Marhbba", "created_at": "2026-04-04T16:37:45.450318", "media_url": null, "media_mime_type": null}, {"id": 13543, "message_id": "3EB042F9A0803CB9D2D368", "sender": "bot", "message_type": "document", "content": "ordonnance_n45654502_4387241.pdf", "created_at": "2026-04-10T10:57:43.078403", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3482/download", "media_mime_type": "application/pdf"}, {"id": 13550, "message_id": "3AFADC6733E0203DC305", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-04-10T10:58:57.305435", "media_url": null, "media_mime_type": null}, {"id": 13551, "message_id": "bot_3AFADC6733E0203DC305_8296", "sender": "bot", "message_type": "text", "content": "مرحبا Fatima 😊 يلا احتاجيتي شي توضيح على ordonnance ولا شي مساعدة أخرى، أنا هنا نعاونك.", "created_at": "2026-04-10T10:59:08.520564", "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 925 in training_review_items