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 showing the upper and lower anterior and posterior teeth in occlusion. The patient's lips are retracted. The upper central and lateral incisors appear to have crowns or veneers, which are lighter in color than the adjacent teeth. There are visible metallic dental restorations on the upper right and upper left posterior teeth, likely crowns or large amalgam/composite restorations. There are brownish-yellow discolorations and possible calculus deposits along the gingival margins of several lower anterior and some posterior teeth. The gingival tissues appear erythematous, particularly at the lower anterior region, with some mild swelling noted. Generalized mild gum recession is present, and the teeth alignment shows mild crowding of the lower anterior teeth. The lower anterior gingiva shows localized redness and possible irritation. The overall teeth color on natural teeth is more yellowish compared to the prosthetic crowns."
  ,
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Central and lateral incisors have crowns or veneers with lighter color and smooth surface",
        "severity_signal": "none"
      },
      {
        "location": "

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