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": "The image shows an intraoral view of the lower dental arch with the tongue retracted upward out of view. Both left and right quadrants are visible, as well as the anterior lower teeth. The teeth in the mandibular arch are present, and the gingival tissue is visible. There is a notable presence of brownish calculus or staining along the gumline and interproximal surfaces of multiple posterior teeth in both quadrants. The enamel surfaces appear intact with no obvious large cavities or fractures. The mucosa of the floor of the mouth appears healthy, smooth, pink, and moist. No visible lesions, swelling, or signs of active inflammation on the mucosa, but deposits near the gumline can be observed.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "lower_left",
        "observation": "Brownish deposits/staining present on molars and premolars near the gumline and interproximal areas. Enamel generally intact.",
        "severity_signal": "mild"
      },
      {
        "location": "lower_right",
        "observation": "Brownish deposits/staining present on molars and premolars near the

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