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": 39193, "message_id": "bot_ACADBCC8B7EBB1B0DA29DDECAF26D879_3284", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Bienvenue au Centre Dentaire Tanger Bay, cabinet du Dr Haitham Boutaib. Comment puis-je vous aider ?", "created_at": "2026-06-05T09:26:00.202048", "media_url": null, "media_mime_type": null}, {"id": 39195, "message_id": "ACDAE8C928A6BB41221819F25A1E263D", "sender": "user", "message_type": "text", "content": "Je voudrais réaliser un sceletique clipser", "created_at": "2026-06-05T09:26:18.291489", "media_url": null, "media_mime_type": null}, {"id": 39196, "message_id": "ACDAD2D7032A9A5BE24EBD0BF5621D73", "sender": "user", "message_type": "text", "content": "Pour dent du haut", "created_at": "2026-06-05T09:26:28.579074", "media_url": null, "media_mime_type": null}, {"id": 39198, "message_id": "AC64C43CF402F131912C89FE3EE7E616", "sender": "user", "message_type": "text", "content": "Je serai a tanger 11", "created_at": "2026-06-05T09:26:42.742314", "media_url": null, "media_mime_type": null}, {"id": 39199, "message_id": "ACD563FF19C8979123DF73C0C8539CE9", "sender": "user", "message_type": "text", "content": "Juin", "created_at": "2026-06-05T09:26:46.036969", "media_url": null, "media_mime_type": null}, {"id": 39200, "message_id": "bot_ACD563FF19C8979123DF73C0C8539CE9_8594", "sender": "bot", "message_type": "text", "content": "Merci pour votre message !", "created_at": "2026-06-05T09:26:56.666798", "media_url": null, "media_mime_type": null}, {"id": 39201, "message_id": "bot_ACD563FF19C8979123DF73C0C8539CE9_1543", "sender": "bot", "message_type": "text", "content": "Pour organiser votre demande de squelettique à clipser pour la dent du haut, pouvez-vous me donner votre nom complet s’il vous plaît ?", "created_at": "2026-06-05T09:26:56.737196", "media_url": null, "media_mime_type": null}, {"id": 39202, "message_id": "bot_ACD563FF19C8979123DF73C0C8539CE9_5183", "sender": "bot", "message_type": "text", "content": "Cela nous permettra de préparer votre dossier et de vous proposer un créneau autour du 11 juin.", "created_at": "2026-06-05T09:26:56.801543", "media_url": null, "media_mime_type": null}, {"id": 39203, "message_id": "AC76667A3E5FC1ED173769E91D7FDC10", "sender": "user", "message_type": "text", "content": "Serifi Laila", "created_at": "2026-06-05T09:27:21.501838", "media_url": null, "media_mime_type": null}, {"id": 39208, "message_id": "bot_AC76667A3E5FC1ED173769E91D7FDC10_1712", "sender": "bot", "message_type": "text", "content": "Merci beaucoup Serifi Laila !", "created_at": "2026-06-05T09:27:33.611306", "media_url": null, "media_mime_type": null}, {"id": 39209, "message_id": "bot_AC76667A3E5FC1ED173769E91D7FDC10_4290", "sender": "bot", "message_type": "text", "content": "Votre demande est transmise à l’équipe, qui va vérifier les disponibilités autour du 11 juin et vous recontactera rapidement.", "created_at": "2026-06-05T09:27:33.677138", "media_url": null, "media_mime_type": null}, {"id": 39210, "message_id": "bot_AC76667A3E5FC1ED173769E91D7FDC10_6428", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-05T09:27:33.743993", "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 3177 in training_review_items