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 shows an intraoral view of the upper arch of a patient's mouth. The mouth is being held open with a cheek retractor. Multiple teeth in the upper arch are visible, fitted with clear and metallic orthodontic brackets and archwires. There is a significant gap (edentulous space) suggesting a missing upper anterior tooth. The surrounding gum tissue appears erythematous (reddened) in some areas, especially near where the tooth is missing, with visible swelling and irregular surface texture. The teeth present show mild yellowish discoloration and possibly some plaque accumulation. No restorations, crowns, or prosthetics are immediately visible. The image is clearly captured, allowing detailed assessment.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Teeth with orthodontic brackets and wires; significant gap where a tooth appears missing. Adjacent teeth appear to be healthy but show mild staining.",
        "severity_signal": "moderate"
      },
      {
        "location": "upper_right",
        "observation": "Visible brackets and wires; gum tissue appears mildly inflamed.",
        "severity_signal": "mild

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