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 clinical intraoral photograph showing the anterior teeth of both the upper and lower arches. The mouth is held open with retractors for clear visibility. All visible teeth appear generally clean and free of visible heavy stains or major restorations. The gingival (gum) tissue is pink, generally healthy in color and contour, with no obvious swelling or ulceration. The teeth show some minor irregularities in alignment, especially apparent in the lower anterior region where mild crowding and rotational differences are present. The incisal edges appear intact, without obvious gross chipping or wear facets. Some gingival recession is visible in the lower anterior area, particularly around the lower canines and incisors, exposing more root surface. No obvious calculus or plaque deposits are seen. There are no visible cavities, large dental work, or soft tissue lesions.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Upper anterior teeth are well-aligned with healthy appearance and visible incisal edges. No obvious caries or restorations.",
        "severity_signal": "none"
      },
      {
        "location": "front_lower",

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