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 is a professionally designed promotional graphic for Tanger Bay Dental Center. At the center, there is a cartoon-style anthropomorphic tooth character with two eyes, eyebrows, and a smiling mouth. The tooth is holding a notepad with a large green checkmark and is giving a thumbs-up gesture. In the background, there is a blurred view of a modern dental clinic room with dental chairs and equipment faintly visible. At the top of the image is the logo of Tanger Bay Dental Center featuring a stylized tooth outline. Text is prominently displayed in French, confirming an appointment: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a checkmark symbol, and below it, 'CHEZ TANGER BAY DENTAL CENTER'. The overall color scheme uses blue, white, and beige tones and gives a friendly, welcoming impression.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": null,
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": null,
    "alignment": null,
    "calculus_plaque": null,
    "periap

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

📅 Date : *mercredi 17 juin 2026*
🕘 Heure : *10:30*
📍 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 44504 in messages