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": "This is a high-quality intraoral clinical photograph of a patient's mouth held open with plastic retractors. Both upper and lower arches are visible from canine to canine and to some premolars/molars posteriorly. The teeth exhibit moderate yellow and brown discoloration, particularly pronounced on the lower incisors and canines. There are visible stains or calculus deposits, especially on the lower anterior teeth and canines. The alignment shows some crowding and rotation in the lower front teeth. The gums appear pale pink but show signs of mild recession, especially in the lower anterior region. Posterior teeth are partially visible; right and left molars show darker areas consistent with buildup or possible carious lesions, though details of occlusal surfaces are less distinct. No soft tissue lesions or obvious swelling noted.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Upper incisors and canines present, moderate yellow discoloration, mild wear, generally intact.",
        "severity_signal": "mild"
      },
      {
        "location": "front_lower",
        "observation": "Lower incisors and canines show brown staining and

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