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": "This is a high-quality intraoral photo showing the upper arch (maxillary teeth) of a patient. The teeth appear clean and all are present in the field of view. There is a lingual (palatal) fixed orthodontic retainer bonded to the palatal surfaces of the anterior teeth from canine to canine. The palate and gingival tissues are clearly visible and appear pink and firm, with no obvious signs of swelling, redness, or ulceration. There are minor color changes on the occlusal surfaces of some posterior teeth. One of the molars has a visible restoration (with a darker shade) and another has a slight groove in the occlusal surface, possibly a fissure sealant or restoration.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Presence of a fixed wire retainer bonded from canine to canine on the palatal aspect. Teeth surfaces appear smooth and aligned.",
        "severity_signal": "none"
      },
      {
        "location": "upper_right_molar",
        "observation": "Visible composite or amalgam restoration; occlusal surface shows normal anatomy but

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