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": "dental_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "High-resolution intraoral photograph of the upper dental arch, viewed from below. The image shows the palate, upper teeth, attached gingiva, and parts of the lower anterior teeth. There are orthodontic retractors used at the corners for cheek and lip retraction. A complete upper arch is visible with slight crowding of the anterior teeth and visible calculus/tartar deposits behind the upper front teeth. Surfaces of the posterior teeth appear generally smooth and clean, though some staining and calculus are present on the lingual surfaces of the anterior teeth. The gums appear pink and moist, without overt swelling or ulceration. Some natural anatomical variations of the palate are visible. No restorations, metal crowns, or implants are obvious in the visible field.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Slight lingual crowding and overlapping of the anterior teeth, with visible yellowish calculus deposits and some discoloration on the lingual surfaces.",
        "severity_signal": "mild"
      },
      {
        "location": "upper_right",
        "observation": "Molars and premolars visible with intact

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