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 photograph focusing on the anterior teeth and surrounding gum tissue. The mouth is open, showing both the upper and lower arches from canine to canine. All visible teeth appear clean, with no obvious caries, cracks, or significant stains. The gum tissue is pink, firm, and stippled, with no overt swelling, recession, or redness. There is a slight overlap of the lower right lateral incisor behind the upper anterior teeth, suggesting mild dental crowding. The bite appears to be a normal overjet and overbite, with the upper incisors overlapping the lower incisors. No restorations, prostheses, orthodontic appliances, or calculus deposits are visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Upper central and lateral incisors are present, with no visible decay or significant staining, and have a smooth surface.",
        "severity_signal": "none"
      },
      {
        "location": "front_lower",
        "observation": "Lower incisors are present, with slight overlap of the right lateral incisor, crowns appear intact, no visible caries or

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