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": "\u0645\u0631\u062d\u0628\u0627 \u0627\u0644\u0644\u0647 \u0627\u0648\u062f\u064a\u060c \u0634\u0643\u0631\u0627 \u0639\u0644\u0649 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u062f\u064a\u0627\u0644\u0643\u0648\u0645 \u0645\u0639 Centre Dentaire Tanger Bay. \u0648\u0627\u0634 \u0645\u0645\u0643\u0646 \u062a\u0642\u0648\u0644\u0648\u0644\u064a \u0634\u0646\u0648 \u0627\u0644\u062d\u0627\u062c\u0629 \u0627\u0644\u0644\u064a \u0645\u062d\u062a\u0627\u062c\u064a\u0646\u0647\u0627 \u0627\u0644\u064a\u0648\u0645\u061f"}, {"type": "user", "content": "Jaber"}, {"type": "bot", "content": "\u0645\u0631\u062d\u0628\u0627 Jaber \ud83d\ude0a \u0648\u0627\u0634 \u0645\u0645\u0643\u0646 \u062a\u0642\u0648\u0644 \u0644\u064a\u0627 \u0634\u0646\u0648 \u0627\u0644\u062e\u062f\u0645\u0629 \u0623\u0648 \u0627\u0644\u0639\u0644\u0627\u062c \u0627\u0644\u0644\u064a \u0645\u062d\u062a\u0627\u062c \u062a\u0639\u0631\u0641 \u0639\u0644\u064a\u0647 \u0623\u0643\u062b\u0631 \u0623\u0648 \u0648\u0627\u0634 \u0628\u0627\u063a\u064a \u0634\u064a \u0645\u0648\u0639\u062f\u061f \u062d\u0646\u0627 \u0631\u0647\u0646 \u0627\u0644\u0625\u0634\u0627\u0631\u0629 \u062f\u064a\u0627\u0644\u0643."}, {"type": "user", "content": "Salam, 3endi mouchkil f sen li dar liha traitement de canal 3am li fat.\nWlat gris, kayna riha khayba w kanhess b wja3 mlli kanakol.\nMomkin nder rendez-vous 3afak bach tchecki wach kayn infection ?\n\n\n\nhad sen dar liha traitement de canal.\nDaba kanhess b wja3 mlli kanakol w kayna riha khayba.\nMomkin tchecki wach kayn infection w tdir radio?\n\n\nOk\u00e9 3afak, 9bel ma nbda, momkin tgol lia ch7al ghadi tkoun l\u2019koulchi?\n\n\n\nWash kayn chi reduction ila khalast\n\nWash had sen kay7taj couronne bach ma yt9ssarch?\n\n\n\n\n\n3afak, wach t9dar t\u0634\u0631\u062d lia ach kayn f had sen? \n\n\nMomkin tchoufni f radio fin kayn lmochkil?\n\n\n3lach khasni couronne? wach ila madertch ayt9ssar sen?"}]

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