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 description: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a close-up intraoral photo of a person's mouth, with lips retracted in a smile. Both the upper and lower anterior and some posterior teeth are visible. The gums are partially visible, particularly in the upper arch. The person is wearing a striped pink and black shirt, and the background appears to be indoors with part of a ceiling detail visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Upper front teeth appear mostly well aligned. Slight spacing is visible between upper right central and lateral incisor. Teeth coloration is generally uniform, but some minimal staining or slight discoloration is present on lateral teeth.",
        "severity_signal": "mild"
      },
      {
        "location": "front_lower",
        "observation": "Lower anterior teeth visible and relatively aligned but with slight crowding, particularly on the left side. Some differences in coloration; lower teeth appear slightly more yellow compared to upper teeth.",
        "severity_signal": "mild"
      },
      {
        "location": "upper_left",
        "observation": "Partial view. Canine and first premolar visible;

User message context: بغيت غير تقريباً الثمن قبل ما نحجز consultation. هادي صورة، السن اللي كنقصد هو اللي على اليسار حد السنين القدام. 😊

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 52077 in messages