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 photograph showing the frontal view of upper and lower teeth. The patient's lips are retracted with a transparent appliance. The teeth are generally present with some crowding of lower anteriors. There are visible areas of yellowish discoloration and staining, especially on the upper and lower canines and premolars. The gingiva appears generally pink but shows mild redness near the upper central incisors. There are areas of translucency and visible wear on incisal edges of upper and lower anteriors. Some calculus or plaque deposits are observed near the lower anteriors. The general alignment shows overlapping of lower incisors and edge-to-edge relation in parts of anterior teeth.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Upper central and lateral incisors present, with incisal edge translucency, mild wear, mild yellowish discoloration.",
        "severity_signal": "mild"
      },
      {
        "location": "front_lower",
        "observation": "Crowding of lower incisors, visible mild staining, incisal edge wear and translucency, calculus at gingival margin.",

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