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, Shafaqat Ali!"}, {"type": "bot", "content": "Could you please confirm if the reason for your visit is a consultation for composite bonding on a chipped tooth?"}, {"type": "bot", "content": "Also, do you prefer the 25th or the 26th, and if you have a preferred time of day (morning or afternoon)?"}, {"type": "bot", "content": "Once I have these details, our team will contact you to confirm your 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": "Visit is for composit bonding"}, {"type": "bot", "content": "Thank you, Shafaqat Ali."}, {"type": "bot", "content": "Which day suits you better for the consultation\u201425th or 26th?"}, {"type": "bot", "content": "And do you prefer morning or afternoon?"}, {"type": "bot", "content": "Once you let me know, our team will contact you to confirm your 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": "26"}]

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