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": "Hello. I would like to know how much is canal root treatment lower 6"}, {"type": "bot", "content": "The price for root canal treatment (canal treatment) for the lower 6 is determined after an evaluation by Dr Haitham, as it depends on your specific case. If you wish, you can book a consultation to get a precise quote \ud83d\ude0a Would you like to schedule an appointment?"}, {"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": "Can you give me just approximately price."}, {"type": "bot", "content": "I\u2019m sorry, but I can\u2019t give an approximate price for root canal treatment, as the clinic policy is to determine the exact cost only after an evaluation. If you\u2019d like, you can book a consultation (200DH) to get a precise quote for your case. Would you like to schedule an appointment?"}, {"type": "user", "content": "If I book appointments will you be able to do treatment the same day?"}, {"type": "bot", "content": "Usually, the first appointment is for consultation and evaluation. Depending on your case and the doctor\u2019s schedule, sometimes treatment can start the same day, but it\u2019s not guaranteed. If you\u2019d like, I can help you book a consultation and note your preference to begin treatment as soon as possible. Would you like to proceed with booking?"}, {"type": "user", "content": "I will be in Tanger from 27 may for two days"}, {"type": "bot", "content": "Thank you for the details! To help you book, could you please provide your full name and confirm if the reason is root canal treatment for the lower 6? Also, do you prefer a specific time (morning or afternoon) on May 27 or 28?"}, {"type": "user", "content": "Tomasz Zwolinski root canal treatment lower 6 . I prefer afternoon"}]

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