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": "dental_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows an intraoral view of the upper and lower arches with the mouth open, using cheek retractors to allow full visibility of the teeth and gums. The teeth appear uniformly white, bright, and have a uniform shape and contour indicating the likely presence of prosthetic crowns or veneers on all visible teeth. The gums are visible, with a healthy pink coloration in most areas, but there is some mild redness and recession, especially in the lower anterior region. There is calculus or staining visible in the lower right and left posterior regions near the gumline. Alignment appears good and symmetrical; no obvious crowding or spacing is observed. The occlusion shows no obvious trauma or irregular contact. There are no visible soft tissue lesions or swelling. No orthodontic appliances are present.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "White, uniform crowns/veneers, smooth surfaces, appear prosthetic",
        "severity_signal": "none"
      },
      {
        "location": "front_lower",
        "observation": "White, uniform crowns/veneers, smooth surfaces, appear prosthetic",
        "severity

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