SQLite Web: app.db

id

Primary key. INTEGER

conversation_id

INTEGER NOT NULL

message_id

TEXT NOT NULL

sender

TEXT NOT NULL

message_type

TEXT NOT NULL (default 'text'

content

[Image analysis] Image description: ```json
{
  "visible_domain": "non_dental",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a stylized, cartoon-like tooth character in the foreground. The tooth has a smiling face, raised eyebrows, and is giving a thumbs up with one hand while holding a spiral calendar with a large green check mark on it. In the background, there is a blurred dental clinic setting, including a dental chair and what seems to be clinical equipment. At the top, there is a logo of a tooth with the text 'Tanger Bay Dental Center.' Below the logo, there is prominent French text indicating that an appointment is confirmed, followed by the name 'Chez Tanger Bay Dental Center.' The color palette is predominantly blue and white, conveying a clinical and welcoming environment. No real teeth or medical features are visible; the setting is clearly intended as a promotional or informational graphic, not a clinical photo.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": "",
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": "",
    "alignment": "",
    "calculus_plaque": "",
    "periapical_areas": "",
    "other_findings": ""

User message context: Salut *QUECHICHI Safae*👋
Nous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷

📅 Date : *lundi 06 avril 2026*
🕘 Heure : *09:00*
📍 Adresse : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)
📞 Pour toute question : 06 60 02 22 63
✅ Merci de nous confirmer votre présence en répondant « OUI » à ce message

⚠️ IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement considéré comme annulé automatiquement. 
Merci de votre compréhension.

TEXT

media_url

TEXT

media_mime_type

TEXT

chatbot_id

INTEGER NOT NULL

created_at

TEXT NOT NULL

status

TEXT (default 'sent'

delivered_at

TEXT

read_at

TEXT

sender_user_id

TEXT

metadata

TEXT

app.db — messages

Update row 12311 in messages