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 an intraoral photo of the lower jaw taken with cheek retractors in place. The lower teeth and gums are clearly visible. Multiple lower posterior teeth (molars and premolars, particularly on the left side of the image) exhibit extensive brownish and dark areas, suggesting visible cavities or decay. The surfaces appear rough, broken down, and discolored. Several teeth show large structural loss. The anterior lower teeth (incisors and canines) are present and show moderate to mild yellowish discoloration, with some visible surface irregularities but retention of tooth structure. The gum tissue is generally pink, but with areas of localized redness, especially around decayed teeth. There is no obvious swelling or purulent exudate present. The upper teeth are partially visible at the top of the image. No orthodontic appliances, implants, or crowns are visible. A portion of a white plastic cheek/lip retractor is visible at the bottom of the image. No visible text, numbers, or patient identifiers.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_left",
        "observation": "Multiple molars with extensive brown discoloration

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