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-resolution intraoral clinical photograph showing both upper and lower anterior teeth with cheek retractors in place. The upper front teeth exhibit a uniform, artificial appearance suggesting the presence of dental crowns or prosthetic restorations. The lower front teeth show natural dentition with notable yellowish discoloration, particularly toward the cervical margins, and visible accumulation of calculus. The gingival tissue is visible, appearing generally pale pink although there is mild redness in certain areas, particularly cervically around the lower anteriors. Restorative material is not evident on the lower teeth, but the upper teeth's crowns indicate full-coverage restorations.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Upper anterior teeth have crowns or bridge restorations with homogeneous shade and contour; natural tooth structure is not visible.",
        "severity_signal": "moderate"
      },
      {
        "location": "front_lower",
        "observation": "Lower anterior teeth display yellowish stains and visible calculus accumulation; tooth surfaces appear naturally worn with minor chipping at incisal edges.",
        "severity_signal": "moderate"
      },
      {

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