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

```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This is an intraoral photo showing the anterior and lateral teeth of both the upper and lower dental arches. A cheek and lip retractor is used for clear visualization. The image captures the full width of the mouth, showing teeth, gums, and part of the lips and mustache.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Central right and left incisors appear lighter in color than adjacent teeth, possibly indicating restorations. Incisal edge of right central incisor appears chipped or uneven.",
        "severity_signal": "mild"
      },
      {
        "location": "front_lower",
        "observation": "Mild yellowish discoloration visible, especially on the canines. Some mild incisal wear and slight crowding visible.",
        "severity_signal": "mild"
      },
      {
        "location": "upper_right",
        "observation": "General alignment is acceptable, mild tooth rotation or crowding observable towards the canine and premolar area. No major lesions or fractures visible.",
        "severity_signal": "mild"
      },
      {
        "location": "upper

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