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": "bot", "content": "Would you like to book your appointment between June 15 and 20?"}, {"type": "bot", "content": "If yes, could you please confirm your full name so I can pass your request to the team?"}, {"type": "bot", "content": "Please note: your appointment will only be confirmed after our team contacts you directly \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "Okay I will let you know as soon as possible"}, {"type": "bot", "content": "Thank you! \ud83d\ude0a Whenever you\u2019re ready, just send your full name and preferred date, and I\u2019ll pass your request to the team.\n\nIf you have any other questions, feel free to ask!"}, {"type": "user", "content": "Do you work on sundays, 14 June?"}, {"type": "bot", "content": "Thank you for your question! The clinic is closed on Sundays. On Saturday, June 14th, we are open from 09:00 to 14:00. If you\u2019d like an appointment that day, just let me know!"}, {"type": "user", "content": "I can take on 15june Monday 9am?\nTeeth Whitening and teeth cleaning treatments"}, {"type": "bot", "content": "Great! To request your appointment for teeth whitening and cleaning on Monday, June 15 at 9:00 am, could you please provide your full name?"}, {"type": "bot", "content": "This will help the team process your booking."}, {"type": "bot", "content": "Please note: your appointment will only be confirmed after our team contacts you directly \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "Name: Hadizjat Elbukaeva"}]

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 528 in notifications