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 a close-up intraoral photograph of an adult patient's mouth, taken with cheek retractors in place to expose the teeth and gums. Both upper and lower anterior and premolar teeth are fully visible with partial view of some molars. The teeth appear yellowish, with notable brown staining and buildup, particularly on the lower front teeth. There is visible crowding and misalignment, especially in the lower anterior region, causing overlapping of the incisors. The gums appear generally pink, but with some mild redness and slight swelling observed in the lower front region. There is no obvious active bleeding or severe gum recession visible in this view. The upper and lower right canine and premolars are also visible. Some teeth present with worn incisal edges.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Central and lateral incisors appear intact but with slight discoloration. Mild wear of the incisal edges is noticeable.",
        "severity_signal": "mild"
      },
      {
        "location": "front_lower",
        "observation": "Significant brown staining and calculus buildup, particularly on the incisor

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