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": "user", "content": "Hi"}, {"type": "bot", "content": "Bonjour et bienvenue au Cabinet dentaire Tanger Bay \n\u0645\u0631\u062d\u0628\u0627 \u0628\u0643\u0645 \u0641\u0640 \u0639\u064a\u0627\u062f\u0629 \u0637\u0646\u062c\u0629 \u0628\u0627\u064a \u0644\u0637\u0628 \u0627\u0644\u0623\u0633\u0646\u0627\u0646.\n\n Merci de nous indiquer en quoi nous pouvons vous aider afin que notre \u00e9quipe puisse vous orienter au mieux.\n\u0645\u0646 \u0641\u0636\u0644\u0643\u0645\u060c \u0623\u062e\u0628\u0631\u0648\u0646\u0627 \u0643\u064a\u0641 \u064a\u0645\u0643\u0646\u0646\u0627 \u0645\u0633\u0627\u0639\u062f\u062a\u0643\u0645 \u0644\u0643\u064a \u064a\u062a\u0645\u0643\u0646 \u0641\u0631\u064a\u0642\u0646\u0627 \u0645\u0646 \u062a\u0648\u062c\u064a\u0647\u0643\u0645 \u0628\u0634\u0643\u0644 \u0645\u0646\u0627\u0633\u0628\n\n\ud83d\udccd Localisation : https://maps.app.goo.gl/ZCXz3sMZkhk9diph7\n\ud83c\udf10 Site web : www.tangerbay.ma\n\ud83d\udce7 Email :\ntangerbay01@gmail.com\n\n\u2705 Notre \u00e9quipe vous r\u00e9pondra dans les plus brefs d\u00e9lais.\n\u0633\u064a\u0642\u0648\u0645 \u0641\u0631\u064a\u0642\u0646\u0627 \u0628\u0627\u0644\u0631\u062f \u0639\u0644\u064a\u0643\u0645 \u0641\u064a \u0623\u0642\u0631\u0628 \u0648\u0642\u062a \u0645\u0645\u0643\u0646"}, {"type": "user", "content": "Wanted to get our teeth cleaned - do you guys do this"}, {"type": "user", "content": "We on holiday and just wanted a clean"}, {"type": "user", "content": "Tomorrow"}, {"type": "bot", "content": "Welcome to Centre Dentaire Tanger Bay! Yes, we do teeth cleaning (d\u00e9tartrage et polissage) at the clinic.\n\nIf you\u2019d like to book for tomorrow, could you please share your full name and the preferred time of day? That way, I can pass your request to our team so they can confirm the appointment with you.\n\nAlso, how many people would like to get their teeth cleaned?"}, {"type": "user", "content": "2"}, {"type": "user", "content": "What is the costs"}, {"type": "user", "content": "Please confirm"}, {"type": "user", "content": "12.30 is good"}, {"type": "bot", "content": "Thank you! Could you please provide your full name, and let me know if the booking is for just you or for more people? I\u2019ll send your request for a teeth cleaning appointment tomorrow at 12:30 to our team, and they\u2019ll contact you directly to confirm.\n\nPlease note: your appointment will only be confirmed after our team contacts you directly \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "Aboobaker Sacranie \nMubina Sacranie"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

app.db — notifications

Update row 213 in notifications