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": "The image shows a close-up intraoral view of the upper and lower anterior and premolar teeth. The lips are retracted using cheek retractors, exposing the gingiva and teeth clearly. Both upper and lower arches are visible from first premolar to first premolar (some molars partially visible). Teeth show a yellowish hue, with noticeable brownish discoloration, particularly near the gum line and interproximal areas. There is visible accumulation of calculus and/or staining, especially on the lower anterior and upper lateral/canine areas. The gum tissue appears generally pink but shows mild swelling and irregularity along the marginal gingiva. There is visible crowding of the lower anteriors and a slight misalignment between upper and lower dental midlines. Some existing dental restorations (possible composite or amalgam) can be seen on upper right posterior teeth.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Yellowish color, mild wear on incisal edges, mild brown staining interproximally",
        "severity_signal": "mild"
      },
      {
        "location": "front_lower",
        "observation

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