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": "Thank you Khawlah!"}, {"type": "bot", "content": "Your request for teeth cleaning on 12th June has been sent to the team."}, {"type": "bot", "content": "They will contact you soon 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": "On the day would it be possible to book the same cleaning service for another person as well or do I need to book in advance?"}, {"type": "bot", "content": "It\u2019s always best to book in advance to guarantee availability, especially if you want two cleanings on the same day."}, {"type": "bot", "content": "If you\u2019d like, I can also take the details for the second person now and pass the request to the team."}, {"type": "bot", "content": "Would you like to do that?"}, {"type": "user", "content": "<reply_to>Would you like to do that?</reply_to> Yes please"}, {"type": "bot", "content": "Great! Could you please provide the full name of the second person who would like a teeth cleaning, and confirm if they also prefer 12th June?"}, {"type": "bot", "content": "This will help the team organize both appointments for you."}, {"type": "user", "content": "Usman Khan\n12th June is perfect. We will be arriving together once the appointment is confirmed."}]

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