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": 47022, "message_id": "ACB47A08D289C2DF5C1A2F70AB469938", "sender": "user", "message_type": "text", "content": "Vous avez le médecin urgrntiste sur place?", "created_at": "2026-06-22T17:55:31.936160", "media_url": null, "media_mime_type": null}, {"id": 47023, "message_id": "bot_ACB47A08D289C2DF5C1A2F70AB469938_2688", "sender": "bot", "message_type": "text", "content": "Je ne suis qu'un assistant virtuel.", "created_at": "2026-06-22T17:55:46.683186", "media_url": null, "media_mime_type": null}, {"id": 47024, "message_id": "bot_ACB47A08D289C2DF5C1A2F70AB469938_3085", "sender": "bot", "message_type": "text", "content": "Au Centre Dentaire Tanger Bay, nous sommes spécialisés en soins dentaires, implantologie, orthodontie et esthétique dentaire, mais nous n'avons pas de médecin urgentiste généraliste sur place.", "created_at": "2026-06-22T17:55:46.741684", "media_url": null, "media_mime_type": null}, {"id": 47025, "message_id": "bot_ACB47A08D289C2DF5C1A2F70AB469938_5961", "sender": "bot", "message_type": "text", "content": "Si c'est une urgence médicale générale, il vaut mieux contacter un service d'urgence ou un hôpital.", "created_at": "2026-06-22T17:55:46.786443", "media_url": null, "media_mime_type": null}, {"id": 47026, "message_id": "bot_ACB47A08D289C2DF5C1A2F70AB469938_362", "sender": "bot", "message_type": "text", "content": "Si c'est une urgence dentaire, souhaitez-vous que notre équipe vous rappelle rapidement ?", "created_at": "2026-06-22T17:55:46.911662", "media_url": null, "media_mime_type": null}, {"id": 47027, "message_id": "ACC408A43E881C9CE7AF01DF7973B9B5", "sender": "user", "message_type": "text", "content": "Non, dentaire", "created_at": "2026-06-22T17:56:17.767944", "media_url": null, "media_mime_type": null}, {"id": 47028, "message_id": "bot_ACC408A43E881C9CE7AF01DF7973B9B5_4339", "sender": "bot", "message_type": "text", "content": "Merci pour la précision.", "created_at": "2026-06-22T17:56:29.776706", "media_url": null, "media_mime_type": null}, {"id": 47029, "message_id": "bot_ACC408A43E881C9CE7AF01DF7973B9B5_7754", "sender": "bot", "message_type": "text", "content": "Oui, nous gérons les urgences dentaires au cabinet.", "created_at": "2026-06-22T17:56:29.830847", "media_url": null, "media_mime_type": null}, {"id": 47030, "message_id": "bot_ACC408A43E881C9CE7AF01DF7973B9B5_8791", "sender": "bot", "message_type": "text", "content": "Si vous avez une douleur aiguë, une infection, une dent cassée ou tout autre souci dentaire urgent, Dr Haitham Boutaib peut vous recevoir rapidement selon la disponibilité.", "created_at": "2026-06-22T17:56:29.948790", "media_url": null, "media_mime_type": null}, {"id": 47031, "message_id": "bot_ACC408A43E881C9CE7AF01DF7973B9B5_8160", "sender": "bot", "message_type": "text", "content": "Souhaitez-vous prendre un rendez-vous en urgence ?", "created_at": "2026-06-22T17:56:30.004055", "media_url": null, "media_mime_type": null}, {"id": 47033, "message_id": "AC688BCE54CF1E23D8A65972F365C581", "sender": "user", "message_type": "text", "content": "Vous êtes ouvert maintenant ?", "created_at": "2026-06-22T17:56:55.469615", "media_url": null, "media_mime_type": null}, {"id": 47034, "message_id": "bot_AC688BCE54CF1E23D8A65972F365C581_4536", "sender": "bot", "message_type": "text", "content": "Oui, nous sommes ouverts en ce moment 😊 Nos horaires aujourd'hui sont de 09:00 à 19:00. \n\nSouhaitez-vous passer directement ou prendre un rendez-vous ?", "created_at": "2026-06-22T17:57:06.917338", "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 3890 in training_review_items