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": "Just to let you know, the clinic is closed on Sunday."}, {"type": "bot", "content": "Would you like to book your appointment for Saturday morning instead, or do you prefer another day?"}, {"type": "bot", "content": "And could you please tell me the reason for your visit?"}, {"type": "bot", "content": "No problem Mohamed Amine Karraz \ud83d\ude0a Could you please tell me the reason for your visit, and if you have a preferred time on Saturday morning?"}, {"type": "bot", "content": "Once I have these details, I\u2019ll notify the team to contact you for confirmation."}, {"type": "bot", "content": "Please note: your appointment will only be confirmed after our team contacts you directly \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "Saturday morning is good"}, {"type": "bot", "content": "Thank you Mohamed Amine Karraz!"}, {"type": "bot", "content": "Could you please let me know the reason for your visit (for example: d\u00e9tartrage, consultation, douleur, etc.)?"}, {"type": "bot", "content": "This will help the team prepare for your appointment."}, {"type": "bot", "content": "Once I have this last detail, I\u2019ll send your request to the team."}, {"type": "user", "content": "I just want cleaner and whiter teeth"}]

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