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": 44565, "message_id": "AC6AE8D7871365DA4F24A34AA823B3D2", "sender": "user", "message_type": "text", "content": "An appointment for Wednesday evening?", "created_at": "2026-06-16T16:31:42.756254", "media_url": null, "media_mime_type": null}, {"id": 44566, "message_id": "bot_AC6AE8D7871365DA4F24A34AA823B3D2_4111", "sender": "bot", "message_type": "text", "content": "Great! To help you book the appointment for Wednesday evening, could you please provide your full name? Also, just to confirm, is the appointment for teeth cleaning?", "created_at": "2026-06-16T16:31:54.433823", "media_url": null, "media_mime_type": null}, {"id": 44567, "message_id": "AC24A8C29003E455974FB7A0896928D4", "sender": "user", "message_type": "text", "content": "<reply_to>The cost of teeth cleaning depends on your specific case and is determined after an evaluation by Dr Haitham Boutaib. Would you like to book a cons...</reply_to> I go every 3-6 months so they're in good condition so just prefer a total cost", "created_at": "2026-06-16T16:32:04.349078", "media_url": null, "media_mime_type": null}, {"id": 44568, "message_id": "bot_AC24A8C29003E455974FB7A0896928D4_189", "sender": "bot", "message_type": "text", "content": "Thank you for clarifying.", "created_at": "2026-06-16T16:32:16.324448", "media_url": null, "media_mime_type": null}, {"id": 44569, "message_id": "bot_AC24A8C29003E455974FB7A0896928D4_4860", "sender": "bot", "message_type": "text", "content": "The exact cost for teeth cleaning is still determined after an evaluation, even if your teeth are in good condition.", "created_at": "2026-06-16T16:32:16.391966", "media_url": null, "media_mime_type": null}, {"id": 44570, "message_id": "bot_AC24A8C29003E455974FB7A0896928D4_9739", "sender": "bot", "message_type": "text", "content": "Dr Haitham Boutaib will check your situation first to confirm the treatment and give you the total price during the consultation.", "created_at": "2026-06-16T16:32:16.440262", "media_url": null, "media_mime_type": null}, {"id": 44571, "message_id": "bot_AC24A8C29003E455974FB7A0896928D4_8408", "sender": "bot", "message_type": "text", "content": "Would you like to confirm your appointment for Wednesday evening?", "created_at": "2026-06-16T16:32:16.482127", "media_url": null, "media_mime_type": null}, {"id": 44572, "message_id": "ACA6EAB7E26499632A60BB7B51E5239A", "sender": "user", "message_type": "text", "content": "Do you have an approximate price as otherwise it's uncertain", "created_at": "2026-06-16T16:32:53.804045", "media_url": null, "media_mime_type": null}, {"id": 44573, "message_id": "bot_ACA6EAB7E26499632A60BB7B51E5239A_2315", "sender": "bot", "message_type": "text", "content": "I understand your concern.", "created_at": "2026-06-16T16:33:06.750161", "media_url": null, "media_mime_type": null}, {"id": 44574, "message_id": "bot_ACA6EAB7E26499632A60BB7B51E5239A_2076", "sender": "bot", "message_type": "text", "content": "The clinic’s policy is that the price for teeth cleaning is determined after Dr Haitham Boutaib evaluates your case in person, so I can’t provide even an approximate amount in advance.", "created_at": "2026-06-16T16:33:06.818246", "media_url": null, "media_mime_type": null}, {"id": 44575, "message_id": "bot_ACA6EAB7E26499632A60BB7B51E5239A_2402", "sender": "bot", "message_type": "text", "content": "If you wish, I can confirm your appointment so you can get all the details directly from the doctor.", "created_at": "2026-06-16T16:33:06.887433", "media_url": null, "media_mime_type": null}, {"id": 44576, "message_id": "bot_ACA6EAB7E26499632A60BB7B51E5239A_2308", "sender": "bot", "message_type": "text", "content": "Would you like to proceed with booking?", "created_at": "2026-06-16T16:33:06.951007", "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 3683 in training_review_items