SQLite Web: app.db

id

Primary key. INTEGER

chatbot_id

INTEGER NOT NULL

conversation_id

INTEGER NOT NULL

user_id

TEXT NOT NULL

reason

TEXT NOT NULL

user_name

TEXT

user_email

TEXT

user_phone

TEXT

conversation_messages

[{"type": "user", "content": "Hi, can I book an appointment tomorrow?"}, {"type": "bot", "content": "Hello! Of course, I can help you with that. Could you please tell me your full name and the reason for your visit? Also, let me know what time tomorrow would suit you best."}, {"type": "user", "content": "I have had braces when I was younger, but I\u2019m not satisfied with my teeth today. If we can facade one tooth that is dead, and bleach all of teeth. As well as fix the rail that I have behind my teeth. \n\nIt sounds like I have a lot of requirements, maybe it\u2019s better we can look at them tomorrow?"}, {"type": "bot", "content": "Thank you for explaining your situation."}, {"type": "bot", "content": "It\u2019s completely fine to have several concerns\u2014Dr Haitham can review everything with you during a consultation and suggest the best options."}, {"type": "bot", "content": "Could you please share your full name and let me know what time tomorrow would be convenient for you?"}, {"type": "bot", "content": "I\u2019ll forward your request to the team, and they\u2019ll contact you to confirm the appointment."}, {"type": "bot", "content": "Please note: your appointment will only be confirmed after our team contacts you directly \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "My full name: Fatima Ismael"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

lead_source

TEXT

lead_source_id

TEXT

app.db — notifications

Update row 580 in notifications