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": "Cleaning 600dh or 800 dh \nTeeth whitening 4000dh by laser"}, {"type": "user", "content": "Is the teeth cleaning airflow?"}, {"type": "bot", "content": "Yes"}, {"type": "user", "content": "Hi. \ud83d\ude0a\n\n\nMy friend ( Amina) changed her mind and doesn\u2019t want the appointment.\n\nI want the teeth cleaning only not the whitening."}, {"type": "bot", "content": "Thank you for letting us know!"}, {"type": "bot", "content": "Your request to cancel Amina\u2019s appointment and keep only the teeth cleaning for yourself has been sent to the team."}, {"type": "bot", "content": "They will contact you soon to confirm the update."}, {"type": "bot", "content": "Please note: your appointment will only be confirmed after our team contacts you directly \ud83d\ude4f\ud83c\udffb"}, {"type": "bot", "content": "Good morning"}, {"type": "bot", "content": "How are you"}, {"type": "bot", "content": "<reply_to>Hi. \ud83d\ude0a\n\n\nMy friend ( Amina) changed her mind and doesn\u2019t want the appointment.\n\nI want the teeth cleaning only not the whitening.</reply_to> Ok"}, {"type": "user", "content": "Hi. I will not be able unfortunately to visit dentist this time in Tangier. I would like to cancel my appointment  on Monday"}]

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