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 the right lateral view of the patient's upper and lower anterior and premolar teeth, gums, and surrounding mucosa. A cheek retractor is in place, exposing the dental and gingival tissues clearly. The teeth show noticeable yellow-brown staining, especially on the cervical and interproximal regions. Alignment of the teeth is visibly irregular, with crowding and overlapping of both upper and lower incisors and canines. The gum tissue appears generally pink but presents with mild localized erythema, especially in the upper canine area. No obvious open caries or fractures are seen. There is some plaque or calculus deposit visible primarily along the gingival margins. No soft tissue lesions, swelling, or ulcerations are observed on the visible gum tissue. There are no metal restorations, crowns, or visible prosthetic appliances. Lips, facial hair, and parts of the cheek are visible at the periphery.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_right",
        "observation": "Teeth are present and show moderate staining on the surfaces, with noticeable crowding and overlapping of canine and lateral incisors

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