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": "Salam!"}, {"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": "bot", "content": "Merci beaucoup et bienvenue encore une fois \ud83d\ude0a Si vous avez besoin d\u2019aide ou d\u2019information, n\u2019h\u00e9sitez pas \u00e0 pr\u00e9ciser votre demande. Nous sommes \u00e0 votre \u00e9coute !"}, {"type": "user", "content": "Hello doctor!\nI hope you are doing well. I'm planning to visit my home country (around May or June )and I would like to schedule a dental appointment with you. I currently have multiple cavities affecting all my sides of my mouth upper left upper right lower left and lower right based on my previous consultation. I might need several root canal treatment. I also believe that one two sides. I might need dental bridge around 3 teeth each. and on the other side at least two teeth may require root canal treatment and restoration.\nSince I\u2019ll be staying there forb25 days! I would like to know if it possible to complete all the necessary treatment within this time frame. It is very important for me to finish everything during this visit , as I will not be able to return again soon! \nCould you please let me know you availability and whether this treatment plan can be provide more details or previous records. \nThank you very much and looking forward to your response."}, {"type": "bot", "content": "Thank you for your detailed message and for reaching out. I understand how important it is for you to complete all your dental treatments during your stay.\n\nTo best assist you, could you please share your full name and your preferred dates for the appointment (around May or June)? This will help our team review your case and check the availability for a comprehensive treatment plan.\n\nPlease note: your appointment and treatment plan will only be confirmed after our team contacts you directly \ud83d\ude4f\ud83c\udffb\n\nIf you have any previous dental records or X-rays, feel free to send them here\u2014they can help the doctor prepare for your visit."}, {"type": "user", "content": "Imane Bensaid \nI\u2019ll confirm the dates once I\u2019ll get the response from you about the possibility"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

app.db — notifications

Update row 167 in notifications