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] ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This is an intraoral clinical photograph showing the upper and lower anterior and posterior teeth with cheek retractors in place. The image is well-focused and high resolution. The photo reveals partial dentition with most teeth visible from premolar to premolar, and some posterior teeth partially visible. Teeth color varies with noticeable yellowing and some darker staining, particularly on the lower and posterior teeth. There is moderate crowding in the lower anterior teeth and some crowding in the upper anterior as well. The gingival tissues are pink in most areas but with a slightly erythematous (reddened) appearance in the upper anterior region. There is visible plaque and calculus, especially along the gumline and on the lower anterior teeth. Some teeth show signs of wear and possibly chipping on incisal edges. No visible large carious lesions, but areas of possible enamel opacity and staining. No visible metal or ceramic restorations.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Central and lateral incisors and canines present, off-white with some yellow discoloration and irregular alignment. Mild incisal edge wear.",
        "severity_signal

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