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 mandibular (lower) arch viewed from above. The image is sharply focused and well-lit, utilizing a cheek and tongue retractor and dental mirror. All lower teeth from molars to incisors on both sides are visible. The tongue is partially visible at the bottom of the field. The mucosa appears moist and healthy with no obvious lesions. Some posterior teeth, particularly on the lower left, show discoloration and dark material suggestive of possible decay or large restoration failures. A few teeth have filling material. The gum tissue visible is generally pink and not swollen. There is evidence of plaque/calculus on some teeth.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "lower_left molars",
        "observation": "Discoloration and brownish areas, possible caries or stained fissures; filling material present on first molar. The distal molar shows extended areas of brown/yellow material, possibly caries or large restoration defect.",
        "severity_signal": "significant"
      },
      {
        "location": "lower_right molars",
        "observation": "Filling material visible on

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