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 is a high-quality intraoral photograph showing the upper dental arch and palate. The upper teeth are visible from the right to left posterior regions, including molars, premolars, and anterior teeth. Several teeth display large metallic restorations (amalgam fillings), especially present on the upper left and right molars. On the upper right, there appears to be significant structural loss and brown discoloration on one molar, suggestive of advanced breakdown. Gums appear generally pink but there is localized redness and possible inflammation near the affected areas, particularly around the upper right molar. The palate appears healthy without obvious lesions. There are some teeth with visible staining and mild plaque accumulation, especially around the restorations. Overall, the arch shape appears preserved.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_right",
        "observation": "Posterior molar with substantial structure loss, brown/black discoloration, and breakdown. Extensive metallic restoration on neighboring teeth.",
        "severity_signal": "significant"
      },
      {
        "location": "upper_left",
        "observation": "Large metallic restorations (amalgam)

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