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 an intraoral clinical photograph showing the mandibular (lower) arch in occlusal view. The dental arch is fully visible from first molar to first molar bilaterally. Cheek retractors are used for better visualization. The teeth appear mostly intact, but there is notable brownish discoloration and buildup, particularly on the lingual surfaces of the lower anterior teeth and premolars on both sides. The gum tissues appear generally pink but display mild erythema (redness) and slight swelling along the marginal gingiva of lower incisors. No significant visible carious lesions, obvious fractures, or restorations are present. The alignment appears mildly crowded in the mandibular anterior zone. No orthodontic appliances or prostheses are present. Plaque and calculus (tartar) deposits are visible, especially on the lingual surfaces of anterior teeth.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_lower",
        "observation": "Brownish deposits and visible plaque/calculus on lingual surfaces. Mild crowding visible.",
        "severity_signal": "moderate"
      },
      {
        "location": "lower_left",

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