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 clinical photograph showing both upper and lower anterior and premolar teeth in occlusion, retracted with cheek retractors. The gums, tooth crowns, and some soft tissue are visible. There are visible yellow-brownish deposits at the gumlines of multiple teeth, especially on lower anterior and upper lateral/ canine regions. The upper left and right posterior teeth show visible metallic restorations. Gum tissues show mild redness at some locations, particularly around the lower anterior teeth. There are no obvious soft tissue lesions or large cavities visible, but there is some crowding in the lower anterior teeth and mild marginal gingival swelling. The photograph appears to be taken with clinical lighting and focus, with good detail of tooth color, surface texture, and tissue.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Central and lateral incisors and canines present, mild staining near gumlines, overall intact crowns, no fractures seen.",
        "severity_signal": "mild"
      },
      {
        "location": "front_lower",
        "observation": "All six anterior teeth present, obvious yellow

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